up vote 1 down vote favorite
share [g+] share [fb]

I just ran the upsizing wizard on my copy of Access and have successfully connected my Access app to my SQL Server DB but I need to do this for multiple users. Am I going to have to run the upsize wizard on each machine?

I noticed that the wizard created a data source name (.dsn) file, can I use that file on the other instances of Access to connect their apps to the SQL Server DB?

link|improve this question
feedback

1 Answer

up vote 0 down vote

For Small Network

Front End (on every user's machine):

  • Access file in ADP Format. (It contains forms and reports)
    • Copy to C: Drive (Not on the share/network drive).
  • DSN File. So Access client knows where to look for SQL Servers.

Back-end

  • 1 SQL Server (tables, views, stored procedures)
link|improve this answer
Ah cool, I mean, I could also put both the ADP file and the DSN on a shared drive couldnt I? – rugbert Jan 5 at 12:45
Yes, you can. For my project, I write a batch file to copy from share to local. You can run on the share using Run-time only option. However, I think local copy is better performance (run faster). – 1888 Jan 5 at 17:34
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.