Microsoft Access "Path is Invalid" over SonicWall Global VPN

By GZ2525 ·
Here is my scenario and problem. I appreciate any help.

I have my server (Microsoft Small Business Server 2003) setup at home and I am protected by SonicWall. I have Microsoft Access 2003 setup on all the computers for my business. Currently I have an Access database (MDB) located on my server that also contains a User Interface (MDE).

I need one of my workers to be able to access this database from home (Windows XP) so I have SonicWall Global VPN setup. Everything is working properly. She connects to the VPN, can see the database and the files needed. I had her map the network drive to the specified folder. When she tries to open the MDE file, a popup comes up and says "Path is Invalid". Of course I thought there was a linking problem and tried linking the tables to the MDB file with no success. I can't figure out for the life of me what to do.

My current and inefficient way to access the database is to have her use GoToMyPC to remote into a computer connected to the server's switch and everything works.

I really need a better solution.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

MS Access

by tav29 In reply to Microsoft Access "Path is ...

First setup that user on Small Business Server 2003 and Make sure she has rights to the Directory where the Database is located

Second Map the drive on your your Worker's Computer.(this is where the database is located)Go to My Computer >>> Tools >>> Map Network Drive....
For example: \\NameofServer\AccessDatabaseDirectory\

That's it.

Related Discussions

Related Forums