Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

You do not have the necessary permissions to use msAccess 2000 db

I'm trying to open an old MS Access 2000 Database that was working on windows XP, so that i can migrate the old DB in a new application. The DB was created by the previous old WPF application and I need to find a way to open it. I installed MS Access 2000 and used a program that generated the right password for the db but there is still this message that pops up:

You do not have the necessary permissions to use C:/pathToDB.MDB object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

Is there a way to solve this problem?

Many thanks.

like image 390
TAL Avatar asked Jul 24 '14 08:07

TAL


People also ask

How do I change permissions in Access database?

On the Database Tools tab, in the Administer group, click Users and Permissions. Click one of the following commands: User and Group Permissions Use this to grant or revoke user or group permissions, or to change the owner of database objects.

How do I bypass Microsoft Access?

When you open a database while holding down the SHIFT key, many of the options that are set on the Current Database page of the Access Options dialog box are bypassed. To change these options, do the following: Click the File tab, and then click Options. The Access Options box opens.


2 Answers

Earlier versions before 2007 had something called as the MDW (Microsoft Access Workgroup) file with the MDB .

If you cannot find this, you can create one. To create this file, first create a new shortcut Right click New > Shortcut>. When asked type the location of the item. You will need to enter the following, replacing MDB/MDW> to where your files are located and the version of Office you are using. It may be worth opening notepad so you can get the path right and then copy and paste.

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" ".mdb" /wrkgrp ".mdw" /user

Replace Office14 with your version of Microsoft office that is installed. To find this, browse to “C:\Program Files\Microsoft Office\ and note the “Office” folder.

Use this new shortcut to open your file. It should hopefully sort it out.

like image 120
PaulFrancis Avatar answered Nov 15 '22 14:11

PaulFrancis


delete the .ldb file and this should solve your problem. The .ldb file is created when a new session is created. If the program crashes, the .ldb file will not be deleted.

Hope this helps you.

like image 45
Ryan Avatar answered Nov 15 '22 16:11

Ryan