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: 919
Joined: Thu Mar 12, 2009 2:57 pm
Company: Lincoln Agritech Ltd, IRRICAD Software
City / Town: Lincoln
Location: Canterbury, 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.
4. The database may be located on a network drive and multiple users are trying to access it.


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 viewtopic.php?p=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.

4. Located on a network drive.
Move the database to the local drive.
To enable IRRICAD to open successfully the database path in the registry will need to be edited.
Run Regedit and browse to Computer\HKEY_CURRENT_USER\SOFTWARE\AEI Software\Irricad\VisualSettings\HydraulicDesign.
Double-click on the “DbsName” string on the right-hand-side.
Change the database or path so that IRRICAD can successfully finish loading.


The IRRICAD Team
Post Reply