[MS_AccessPros] Re: odbc connection

 

If you use a file DSN you can put it in the same folder as the Access back end so all users have access to it. 

Bill Mosca

---In MS_Access_Professionals@yahoogroups.com, <glcass58@yahoo.com> wrote :

Hi all-

   I have a 2010 Access database with the forms and reports in a front end and the tables in an Access backend that link to the front end. My question is about my need to link to a few tables in a SQL Server database.  When I follow the ODBC wizard in Access, I don't know if I should pick User DSN, System DSN, or File DSN. 

   The users use an .accde copy on their desktop.  The SQL Server is on a separate server from the server that has the network of users.  Some users are off site and log into a terminal server (me included).  I have little knowledge of networks and servers so I don't know how to make the ODBC connection so that it works for everyone.

   Any guidance would be very, very appreciated!

Thanks,

Elizabeth

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___