Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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