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:
Posting Komentar