p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   How to connect an Access DB remotely? (http://p2p.wrox.com/showthread.php?t=43951)

frossie June 13th, 2006 09:40 PM

How to connect an Access DB remotely?
 
Hi everyone.

i'm having problems with connecting my access database on a remote network. I wanted to access my database from another client computer so i thought if anyone could help out with this problem?


mmcdonal June 14th, 2006 08:07 AM

The back end is in Access?

The issue is drive mappings, most likely. You need to paste the front end to the remote computer, and then reconnect all the tables based on that computer's drive mappings.

Alternatively, you can pull the data to local tables as needed if you are only using the front end for OLAP.

I know there are other solutions involving synchronizing databases, but this is VERY problematic in Access. I would suggest upsizing to SQL Server before considering this solution.

Did that help?

mmcdonal


All times are GMT -4. The time now is 09:55 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.