DSN connection

[qwertyjjj]

I have an Access DB (complete data and forms, etc.) at present.
I would like to use this as a front end with SQL Server as the back end.
I have used to upsizing wizard to transfer everything to SQL Server and now all the tables are linked tables.

This all works but I need to send out the front end to many different users and was wondering how the DSN connection will behave. Is it saved with Access or will I have to refresh it in code each time.

If so, how ?

 

[WayneRyan]

qwerty,

You would have to give each user their own DSN.

You can however use a Dynamic connection with ADO.
You basically provide the Server Name, Server Type, Database name,
and either trusted connection or Username/Password.

Don't have an example now, but can dig one up if you need it.

hth,
Wayne

 

[WayneRyan]

Qwerty,

You can also refresh the table links dynamically.

Wayne