Connecting to SQL Server

[Roy]

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
server.

Thanks,

Roy

[Beacher]

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.

[swingingming]

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

[Lee-Anne Waters via AccessMonster.com]

Hi,

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.

Lee-Anne

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

[Roy]

LeAnne,
Thanks much.It worked!

[swingingming]

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?
Thanks.