View Single Post
  #2 (permalink)  
Old June 14th, 2006, 08:07 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
Reply With Quote