Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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)
share|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 '12 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 '12 at 17:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .