Question Concurrent use no longer possible

[Noel]

THis is a shot in the dark. I have a multi-mde (frontends)/mdb (backend) applications running on a client's network server. The server crashed (a virus I think). They have since restored everything (supposedly), however, the applications (mde's) are no longer opening on more than one workstation simultanteously.

When you try to open a second instance of the application, you get a quick flash of the mouse pointer and then nothing.

Anyone have any ideas what could be the problem?

Thanks

 

[DCrake]

Have you tried re-creating the MDE from the MDB and testing that?
More importantly, do you have Access to the MDB?

 

[Dennisk]

I get this a lot and it it usually caused by an abnormal shutdown which leaves the DB lock file 'in limbo' so to speak.

What I do is to log into the db as the administrator then log off, then ensure the lock file has gone, if not then I delete it.

Another cause is permissions, each user requires read/write/delete permission on the folder where the db is so the lock file can be deleted by Access when the last person logs out of the db.

 

[Noel]

Thanks for the responses.

I do have access to the mdbs and, in fact I test the mdbs as well and found that they behave the same way... unable to open more than one instance of the mdbs. I have not tried to regenerate the mde, but since the mdbs behave similarly, I'm thinking that regen'ing the mdes may not solve the problem, but it's worth a try...thanks.

I will also forward the suggestion regarding checking that the workstations have the correct permissions on the folders.

Thanks again.

 

[Guus2005]

When you doubleclick the mdb file while pressing the shift, does it still occure? To determine you don't have some obscure code (like i do) to check for multiple occurences of the same database.

If you don't perhaps the virus was spread further than you thought.
Try opening Access and open the database from within access. This way you know certain that at least the Access application still works.

Otherwise i'd try re-installing Office.

HTH

 

[Noel]

I am able to get concurrent instances of the applications opening as Gus suggested, i.e. by first opening an Access shell and then opening the application from the Access application.

The above test tell me that it's a Windows Explorer issue? and not an Access issue? What do you think?

Re-creating the mde's don't help.

Thanks.

Noel

 

[Guus2005]

A utility like TweakUI will show you the command that is executed when you doubleclick an Access database. When you see nothing more than

<PATH>\MSAccess.exe %1 %2

Then there is nothing wrong with the way windows opens the database.
However is you see any flags like /readonly or /exclusive(?) Then there's you problem.

I don't think that is the case.
I believe that you have to browse through the code that is executed when you open the database.

Could you post a sample database?