Distribute Access Application - DSN

[Marckas]

I have an access application with existing linked tables to SQL Server. I just added another linked table from sql server using a file dsn. Now, the problem is everything is working fine on my computer but when I go ahead and distribute it to other users, it seems to not work. I know why, because they dont have the DSN that i set up on my PC. I think the existing linked tables somehow have the connection string in the mSysObject tables which carried over to other users. I know it is strong said not to touch the systems table but I just dont know how to make the connection string carry over to other users instead of me going to each user to create a dsn which will take a lot of time. Some one please help!

 

[dhookom]

I generally use the code at Using DSN-Less Connections

Duane
Hook'D on Access
MS Access MVP

 

[Marckas]

Where do you put this code. I have been trying to put it on the sqith board On open procedure and it is giving me an error on the first line.

 

[dhookom]

The code should be located in a standard module. You should run it once to change all of your DSN-dependent links to DSN-less.

Duane
Hook'D on Access
MS Access MVP

 

[SoCalAccessPro]

Or....

Create a routine that checks the conencted tables and automatically creates a DSN as needed.

I've done this with success on distributed applications.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com