468,247 Members | 1,296 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,247 developers. It's quick & easy.

Connecting to SQL Server

We are moving our backend to SQL Server from the existing Access
database.The front end is still Access.I have set up the ODBC
Connection to the new SQL Server.How to access the table information in
SQL from the Access database.I know this is simple and bear with me for
this silly question.

Also I loaded up SQL Server standard edition on my workstation.How do i
use the enterprise manager to access the tables on the remote SQL



Nov 13 '05 #1
5 1215
If you've created an ADP in access, and it is currently connected to
SQL Server, the tables show up in access as if they were in an access
database.. for the most part.

Nov 13 '05 #2
I want to do the same thing. But I only have a mdb file. Is it easy to
convert MDB to ADP?

Nov 13 '05 #3

i run a multiuser .mdb (mde) using a SQL server backend.

set up your data source using the system DSN tab on the Data Sources(ODBC)
located under administrive tools.

you can then link your tables in access front end as normal. only you select
Databases (ODBC) as your file type to link

for a mulituser system also check out DSN Stripper. that way you wont have to
go around and set up the data source on each PC.


swingingming wrote:
I want to do the same thing. But I only have a mdb file. Is it easy to
convert MDB to ADP?

Message posted via http://www.accessmonster.com
Nov 13 '05 #4
Thanks much.It worked!

Nov 13 '05 #5
Hi Lee-Anne, I never used SQL server backend before, and I want to use
one. The database will be used by 7-10 people, from different locations
(not in a LAN). From what I know, I should put the frontend on the
client machines, and let them all connect to the backend server. The
server will be on a LAN behind a router. Is this possible?

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Ann Marinas | last post: by
6 posts views Thread by Todd Brewer | last post: by
10 posts views Thread by mairhtin o'feannag | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.