How to access a remote ACCESS DB?

  • Thread starter Thread starter Goetz Martin
  • Start date Start date
G

Goetz Martin

Hello ACCESS-Experts!
I´ve got the problem to access a ACCESS-Database on Server (computer B) from
my own computer (A).

The only information available to me are the DSN ( computer B),
the account (user, password) und the server (IP)
the database is lying on. This is not enough I think!

It seems to be necessary (because DSN can only be used locally) that I have
to adress the .mdb file
directly (for example for my own (computer A) ODBC DSN.
Is this correct?
What about safety in this context, my boss only wants to give me read-access
to the DB...

For testing the connection, I created an empty .udl file , doubleclicked and
tried to get an connection.
->No success - how to enter the IP of computer B???

My favourite programming language ist perl - are there already available
solutions for this problem?!

Thanks a lot!!
 
You (your network self) need to have access to the other computer (shared
folder containing the DB) when working with msaccess
\\192.168.0.1\ACCESSSHARE\TheDb.mdb should work in the DSN after the
criteria is met ...

HTH
Pieter
 
Back
Top