Connecting thru a network.

[TDS]

I need to connect an MDB file on one computer to a SQL server express
database on another computer on a network. Any links on where I can go to
learn to do this?

Terry

 

[Norman Yuan]

If the SQL Server Express is set up correctly (meaning it allows access from
other computers), you simply start your MS Access and click menu File->Get
External data->Link Tables...(or Import, if you you want import data from
SQL Server one time only). On "Link" or "Import" file open dialog box, go to
"Files of tpe" dropdown list, select "ODBC databases()", which lead you to
"Selct Data Source" dialog. Continue on to create new ODBC data
source/select existing ODBC data source, which connects to SQL Server
Express. Once all this done, you have a Access *.mdb file that links to SQL
Server database.

BTW, this NG is for Access ADP project, not *.mdb linked Access front end.
You may go to microsoft.public.access to get better responds to your
questions

 

[TDS]

Thank you,

If the SQL Server Express is set up correctly (meaning it allows access
from other computers), you simply start your MS Access and click menu
File->Get External data->Link Tables...(or Import, if you you want import
data from SQL Server one time only). On "Link" or "Import" file open
dialog box, go to "Files of tpe" dropdown list, select "ODBC databases()",
which lead you to "Selct Data Source" dialog. Continue on to create new
ODBC data source/select existing ODBC data source, which connects to SQL
Server Express. Once all this done, you have a Access *.mdb file that
links to SQL Server database.

BTW, this NG is for Access ADP project, not *.mdb linked Access front end.
You may go to microsoft.public.access to get better responds to your
questions

 

[aaron.kempf]

if you're using SQL Server you really should be using Access Data
Projects

SERIOUSLY

MDB sucks compared to ADP