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

Thanks,

Roy

re: Connecting to SQL Server

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.

re: Connecting to SQL Server

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

re: Connecting to SQL Server

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:[color=blue]
>I want to do the same thing. But I only have a mdb file. Is it easy to
>convert MDB to ADP?[/color]


--
Message posted via http://www.accessmonster.com

re: Connecting to SQL Server

LeAnne,
Thanks much.It worked!

re: Connecting to SQL Server

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.