No permission to open database object error.

[OnMyBike]

I have a 2003 .mdb file and the associated Workgroup Information File which normaly resides on a network in a folder V:\V-Base-Database\DATA\. I have the Workgroup Information File.

The database is unsupported and we need to migrate the data to a new web based database.

When I try to open the database with the shift key down I get the following message :

You do not have the necessary permission to use the V:\V-Base-Database\DATA\V-Basebe.mdb object.

Can someone advise me what is the best way to access the data and do I need to do this on the server instead of a local drive off site?

Thanks

 

[kevlray]

From my experience you need to get the workgroup information file associated with Access. If you are still using Access 2003, it should be pretty easy. Otherwise you have to run the DoCmd.RunCommand acCmdWorkgroupAdministrator from VBA (2007-2010). Not sure about 2013. I was able to find everything I needed on the internet.