Link to Access db using IP Address

[alexisb]

I have an IP address, login and password to view an Access db on another system. I have read many posts in this forum but I just can't get this work. I set up an ODBC connection but get the error "You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database. (Error 3423)". Maybe I set up the ODBC wrong? I used the Microsoft Access Driver (.mdb). I just need to view the data in the other db to write reports in an existing Access application. We are using Access 2000.
Thanks so much for your help.
Alexis

 

[lupins46]

The error message tells you everything.
It is not possible to connect Access to Access using ODBC.

 

[alexisb]

Okay. I didn't know that. Does anyone know how I can connect Access to Access without using the ODBC? I could write code using ADO but I really wanted to do a direct link like I would with Oracle tables.
Thanks,
Alexis

 

[lupins46]

If you can see the other db in Windows Explorer then you should be able to navigate to the other database if you use File>GetExternal Data>Link Tables.

However, if this is a WAN link then you are possibly wasting your time. Access requires LAN speeds so unless you have VERY high speed WAN links you'll be waiting for ever for anything to happen.

What are you trying to do with the linked db?

 

[willir]

If you can not easily navigate to the location, you can map a drive...

\\YourIPAddress\NameOfShare\

You can do this with Explorer, NetworkNieghborhood.

At the command line,

for NT to XP workstations

net use x: \\YourIPAddress\NameOfShare\
...where X is the drive letter

for Novell

map x:=\\YourIPAddress\NameOfShare\

Richard

 

[alexisb]

Thanks everyone for your replies. It turns out that there was a misunderstanding about the database and it is actually a SQL Server db. I was able to set up that ODBC connection with no problem and link to the tables I need.

Thank you so much for all your help. I will keep this additonal info in case I do ever have to link Access to Access.
Regards,
Alexis