MS Access Database Won't Open when in use & double-clicked

[Davenz]

I have a microsoft access database installed on a network. If the database is not in use, any user can double-click on it and it will open. However, if the database is in use by another user when you double-click nothing happens. But... you can still open microsoft access and open the database by clicking file-open- and browsing for the mdb!

Any ideas?

I'm quite sure the database is not being opened exclusively.

Thanks in advance for your help

 

[dhookom]

Do all users have create and delete permissions in the folder containing the MDB?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Davenz]

Yes they do have full permissions to this folder

 

[dhookom]

Check the "Default open mode" in Tools->Options->Advanced. Is there an ldb in the folder?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Davenz]

Hi

The "Default open mode" is set to "Shared" on the database. I have asked the users to also check their own computers as I am unsure whether this is a database or user setting.

There is an ldb in the folder.

 

[Davenz]

forget last post - there is NOT an ldb file in the folder

 

[dhookom]

If there is not an ldb, it suggests not all users have full righs in the folder. See if all users can create a text file (or any other) in the folder. Then see if they can delete it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Davenz]

Users definately have create and delete permissions in the folder.

I have also copied the files from the client site to a network location in our office and opened it on two different computers and it runs fine - it must be something on their network/computers?

 

[dhookom]

No offense but I would expect a reply back like "I witnessed a user create and then delete a file in the folder". It only takes one user to make an mdb read-only to all other users.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[traingamer]

I see this on our network. Create a shortcut to the database and put it on the desktop; use the shortcut.

Don't ask me why this works.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Davenz]

Thanks Duane - Users definately have create and delete permissions in the folder because I had asked them to create a text file and delete it again as per your previous post =)

 

[Davenz]

Thanks Greg. Unfortunately this didn't work either! I'm starting to wonder if it is nothing to do with access and is more a network type thing any ideas?

 

[dhookom]

You might want to open Windows Explorer and find an mdb file. Right click the file and choose properties. You will see "Type of File" and "Opens With". Click the "Change" button to see if the mdbs might be associated with a run-time environment exe. Otherwise, you might want to find similar information in the registry under HKEY_Classes_Root. You might find that mdb files are being hijacked by a run-time version.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]