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!

Thanks,

Elizabeth

__._,_.___

Posted by: glcass58@yahoo.com
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:

Poskan Komentar