Linking to existing SQL tables using Access

[tigernick]

I have recently designed an access database with several tables, queries and forms and have succesfully linked the tables to an sql server. I started by using the upsizing wizard and linking the tables to a new database on sql server. This works fine, all of my forms and queries still work and all data in the tables is forwarded to the sql server rather than stored in the access file.

My problem comes when trying to allow someone else access to use the access database front end, and therefore the linked sql server tables. I have given the person all the permissions on the sql server, but im not sure whether i can simply copy the access database, including the linked tables onto the other persons machine or whether i need to start the upsizing process again. I tried both but neither work, the upsizing wizard tries to create new tables on the sql server where i want it to link to the existing ones.

Im sure this problem has been seen before, any advice would be greatly welcome?????

 

[pbaldy]

How did you link to the SQL Server when you upsized? If you created a User or System DSN on your PC, then create one on theirs. Then the database should work fine. You do not need to upsize again.

 

[tigernick]

Thanks, I actually used a file DSN in the upsizing wizard, is that what i should have used or will this cause problems? Also, should i just copy the database, with its existing links across and then create another DSN?

 

[pbaldy]

Presuming the file DSN is in a location where the other user has permissions, you should just be able to give them a copy of the db and it will work fine (I'm assuming you're both on the same network). File DSN's are my preference, since then I don't have to go to every PC and set up DSN's.