Access MDE File

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"

thanks
One-Deal-Register.mdb
surah79Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QuinnDexCommented:
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.
0
Kent DyerIT Security Analyst SeniorCommented:
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.  :)
0
surah79Author Commented:
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.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Gustav BrockCIOCommented:
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.

/gustav
0
Dale FyeCommented:
Are your users all using the same front-end (is sits on the server) or does each have their own front-end?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
surah79Author Commented:
Thanks for your help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.