linking to database on remote server

[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

 

[Guest]

You link to tables in the other mdb file. File, Get External Data, Link.

 

[Guest]

Hello.

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

Marco

 

[Guest]

Not necessary if you are linking mdb to mdb.

Hello.

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

Marco

 

[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?

 

[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 ...

 

[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

 

[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 ...

 

[Brendan Reynolds]

Albert Kallal's article on Access and WAN's might be of interest here ...

http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html