I'm writing an app for distribution and need to use SQL linked tables. Going the file, get external data, link tables..works fine on my machine where I have the dsn set up and know the dsn name.
My concern is someone installing this app and having a different dsn name. In that case the links will not work because of the difference. My co-workers who have developed the forms use the record source drop down and select one of the linked tables (Access 2000) to use as a record source.
How can I set up these linked tables at start up using a user supplied dsn name? Any help is appreciated.
My concern is someone installing this app and having a different dsn name. In that case the links will not work because of the difference. My co-workers who have developed the forms use the record source drop down and select one of the linked tables (Access 2000) to use as a record source.
How can I set up these linked tables at start up using a user supplied dsn name? Any help is appreciated.
