Need help on EA

[Ritvika]

We have shared the EAP file on a common location and given write permission to team members.
But when the EAP file is attempted to be opened, it gives the foll error
An error has occurred: The Microsoft Jet database engine cannot open the file<file path here>, It is already opened exclusively by another user, or you need permission to view its data".

The file is not read only and the check box in model settings in unchecked.
I ticked the "Use JET 4.0 - requires restart" checkbox under Options, closed the window, and closed EA.  
Then I went back into EA and unticked the box.

If I have missed out on any other setting that can cause the error pls let me know.

[Takeshi K]

EA displays the error message when someone is opening the EAP file by Desktop edition.

Or if there is MDB lock file (.ldb), deleting the .ldb file may solve the problem.

HTH

--
t-kouno

[Ritvika]

I resolved the issue.
This is what I did:
Make a copy of the file
Open EA
Go to "Tools" -> Manage .EAP File -> Repair .EAP File
Select the copy of the file you made.
Try to open the new file concurrently...

[«Midnight»]

So far so good, but you have to attend to one more detail.

Make sure that every user has the Jet 4.0 setting checked. Since EA defaults to Jet 3.51 on installation - yes, I know that's an obsolete engine (and past its 10-year service life) but Sparx insists that's the minimum denominator they support - you will have to adjust this every time. Remember that you must exit and restart EA before this takes effect. If you open a project before restarting - or have one open already - you will still be using Jet 3.51.

The good news is that EA will remember the setting. And you can make this adjustment without having a project open; just start EA from the start menu or desktop.

The possible trap is that EA requires a new 'first time' initialization each time it is activated on a new user account. That means that if you install and configure EA from an administrator account, your user may still have to perform this step.

HTH, David

[Note: AFAIK Jet 4.0 isn't absolutely necessary to prevent lockouts, but it really helps. Regardless, Microsoft has never guaranteed that you won't have problems using Access - any version - with a shared database. So take all appropriate precautions - backups, etc. - that you would with any shared data resource.]