I'm working on from last 2 days and every time i'm getting the same error message, i appreciate any1 can help here.

I'm trying to connect to MDB and from query analyzer I want to run MDB tables.

1)
sp_addlinkedserver 'myserver', 'Access 97', 'Microsoft.Jet.OLEDB.4.0','C:Mag.mdb&# 39;

after i ran this it displays....

(1 row(s) affected)
(1 row(s) affected)
Server added.

2)
sp_addlinkedsrvlogin 'myserver', true, 'sa', 'dev','dev'

(0 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)

3)
after that when i try to run the sql statement like

Select * from myserver..tablename

I GOT THIS ERROR MESSAGE:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'linkedserver..tablename'.