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?

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