Senin, 08 Agustus 2016

[MS_AccessPros] odbc connection


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!




Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. 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.



Tidak ada komentar:

Posting Komentar