Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cstill
Starting Member
2 Posts |
 Posted - 2008-03-19 : 15:05:21
|
| I have been using Access 2000 for quite some time and am trying move the application to use SQL Server 2005 Express. Is there any way to connect directly to an Access MDB using SQL Server 2005 Express, or can it only connect to an MDF? |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-03-19 : 15:24:53
|
| One way is to import data (in management studio) on destination database using import/export wizard.Other way is to set set ODBC connection in MS access 2000 to import data in SQL Server 2005. |
 |
|
|
jrogers
Starting Member
34 Posts |
Posted - 2008-03-19 : 15:24:54
|
| you can create a linked server. |
|
|
|
cstill
Starting Member
2 Posts |
Posted - 2008-03-19 : 17:32:18
|
| I am actually running a VB6 application that is currently accessing an Access 2000 database that I am looking to convert it to a SQL Server 2005 Express database. I have found the MS SQL Server Migration Assistant for Access which will convert the MDB files to MDF files. In addition to the main Access DB there are also 17 esternal databases. There are also a number of queries in the main DB that reference tables in the external databases. Is there a way to have linked tables in SQL like there are in Access or is there another method that would need to be used in order to access the tables in the external databases? If I remove the links to the external DBs and convert the main DB, I get errors on all the queries that reference external tables since it no longer has a link to them. |
|
|
|
|
|
|
Connecting to Access 2000 DB