Access MDE File

Posted on 2013-10-01
Medium Priority
Last Modified: 2013-10-02
Hi Guys

Created a database.Splitted the database in front End and back end and then created an MDE file. But multiple users can;t access it as it gives an error
"Could not lock file"

Question by:surah79

Assisted Solution

QuinnDex earned 750 total points
ID: 39538990
this error is seen when a user has read only privileges

check the other users have the correct read/write privileges for the database file.
LVL 17

Expert Comment

by:Kent Dyer
ID: 39538996
Are you using a WRKGADM (older-style) locking and workgroup Admin tool?  Why not use an MDB for the back-end?  Understand that MDE is compiled..  But Access is not a enterprise-grade DB anyway.  :)

Author Comment

ID: 39539077
Hi QuinnDex,

The users have all the read and write access both
Also I tried using the normal front end and backend file (without converting in to MDE still the same problem.
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

LVL 53

Expert Comment

by:Gustav Brock
ID: 39539300
The users probably are not granted create rights at the shared folder. Then the ldb cannot be created.
Or you have set up your frontend to be opened exclusively. Then the first user lock the file and following cannot gain access. If so, check your shortcut.

LVL 50

Expert Comment

by:Dale Fye
ID: 39539430
Are your users all using the same front-end (is sits on the server) or does each have their own front-end?
LVL 59

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 750 total points
ID: 39539528
As has been said, users need full read, write, and del privs for the directories where the DB's reside.

This includes the directory for the FE, BE, and workgroup file (and there is one whether you are using user level security or not).

Simple test; when logged in as a user, try creating, editing, and then deleteing a text file in each of the directories.

The fact that the FE is a MDE has nothing to do with the problem your having.  If you place a MDB instead of a MDE, you'll see that you have the same problem.


Author Closing Comment

ID: 39541850
Thanks for your help

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question