Programatically saving a project to an ODBC source ?

[J.Simpson]

Does anyone know how to prevent project from prompting you for a DSN name
when saving a project to an ODBC source programatically?

thanks,

James

 

[Rod Gill]

Hi,

Edit the DSN file to include the name of the data source (EG Access database
name). Record a macro of you opening or saving to the ODBC source and see
what's recorded. You do need to select a source in the DSN to avoid a
prompt.