Link to home
Start Free TrialLog in
Avatar of saikit
saikit

asked on

Can I query MDB file via SQL server (not convert to MDF)

I use MS SQL 7 and have a MDB file in its local harddisk.

If I don't convert my MDB file to MDF, can I query this MDB file via SQL server?

Thank you very much.
Avatar of chrhedga
chrhedga
First set up the link:

sp_addlinkedserver 'Nwind', 'Access 97', 'Microsoft.Jet.OLEDB.4.0', 'c:\mydata\Nwind.mdb'

Next, logininfo:

sp_addlinkedsrvlogin 'Nwind', false, 'Joe', 'Admin', NULL

Query like this:

SELECT * FROM Nwind...Employees
Avatar of saikit
saikit

ASKER

The MDB file is Access 2000.

I'm new to SQL server, would you please give more details on doing this?

Thanks.
Avatar of saikit
saikit

ASKER

How to specify the MDW file for the Access 2000 MDB for the linkedserver ?
ASKER CERTIFIED SOLUTION
Avatar of chrhedga
chrhedga
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of saikit
saikit

ASKER

Thanks. I followed you example and successed.

My Client program is using DSN (SQL server driver) to connect the SQL server, but the LinkedServer doesn't showing in the database list of the SQL server.

How to make linked server showing in the DB list?


Thanks.