linking to database on remote server

P

phil

Hope someone can help

Can I use Access on my local machine to connect to an access database that
is on our company server?

I've look for information but cant find too much

Any help will be much appreciated
Phil
 
M

Marco Silva

Hello.

In my opinion you should create an ODBC link to the external data.

Marco
 
B

Brendan Reynolds

Not only not necessary, but not possible if you're linking MDB to MDB.

To the original poster - if you're still having difficulties, could you
perhaps clarify what you mean by 'remote'? How does the client PC connect to
the server?
 
V

Van T. Dinh

Remote like the server is located in a different site and linked via WAN?

Beware that in Access, the Front-End constantly "talks" to the Back-End so
using Back-End via a WAN may not be too fast ...
 
P

phil

yes, the server is only accessible via its ip address

how do I go about linking an MDB on that machine to my local Access system

thanks for all the help so far

Phil
 
V

Van T. Dinh

Sorry, no ideas. In networks that I have worked with, even multi-site
networks, we still use DNS names and shares.

I had a quick look on Microsoft Support Web site but found nothing ...
 
Top