File DSN's connecting to Access DB's

Hi

I need to be able make dsn less connections to various access databases, or maybe use a File DSN.

I cannot seem to make this work. Does anyone know if this is possible?

Thanks in advance
Jacques

You must have at least one ODBC profile even if it does not point to any specific file and just references the MS Access driver to be used. Then you can eneter into ODBC profile field something like
'My_ODBC_profile;DBQ=my_path\my_file.MDB;FIL=MS Access'

If you are connecting to database in script using DatabaseConnectEx statement you will need to specify this in the Database Name parameter.

An ODBC profile can be also created dynamicaly from a script. It is still just an .INI file.

: Hi

: I need to be able make dsn less connections to various access databases, or
: maybe use a File DSN.

: I cannot seem to make this work. Does anyone know if this is possible?

: Thanks in advance
: Jacques

Correction: by "ODBC profile field" I meant name of ODBC profile to use when you create new database profile within 24x7.

: You must have at least one ODBC profile even if it does not point to any
: specific file and just references the MS Access driver to be used. Then
: you can eneter into ODBC profile field something like
: 'My_ODBC_profile;DBQ=my_path\my_file.MDB;FIL=MS Access'

: If you are connecting to database in script using DatabaseConnectEx statement
: you will need to specify this in the Database Name parameter.

: An ODBC profile can be also created dynamicaly from a script. It is still
: just an .INI file.