DBS 5 Database Exception Error - already open or need permission to view the data (3051)

Frequently asked questions - and answers!
Post Reply
User avatar
jovivier
Site Admin
Posts: 695
Joined: Thu Mar 12, 2009 2:57 pm
Company: LVL
City / Town: Blenheim
Location: Lincoln, New Zealand
Contact:

DBS 5 Database Exception Error - already open or need permission to view the data (3051)

Post by jovivier »

This message can be caused by:
1. The .mdb file could be read-only.
2. The location of the .mdb file could require the “Read” and “Write” settings set on the folder
3. The database may be locked. This usually means an .ldb file is still present therefore the mdb file cannot be opened.


1. Read Only.
Browse to where the mdb file is saved. Right-click on the mdb file and select Properties. If “Read-only” is enabled, uncheck to disable.

2. Folder Permissions
Browse to where the database folder is located, so you can see the folder in the right-hand Windows Explorer pane. Right-click on the folder and go to the “Security” tab. Highlight the “Users” group in the top section.
If “Read” and “Write” are not enabled click the [Edit] button. Reselect the “Users” group and then enable “Read” and “Write” – this will enable all options. Click [Apply]. (See forum post https://www.irricad.com/phpbb3/viewtopi ... 1196#p1196).

3. Locked database
With IRRICAD closed, check to see if there is an .ldb file with the same name in the folder where the .mdb file is located. This is the ‘lock’ file for the database. Delete this file if it is present.

The IRRICAD Team

Post Reply