473,395 Members | 1,941 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

MDE file error 3045 - PLEASE HELP!

Hi

I hope you can help me with this it is driving me nuts.
I've created a database which I needed to give multiple people access
to but didn't want them messing so I created an MDE file. I ensured
that the MDB file was set to shared, not compacting and set to run
users not owners permissions before I converted.
However, if one of the users goes into the database, it does not create

and LDB file and if anyone else tries to get it, the error message:
Could not use <name>; file already in use. (Error 3045)
appears. Some of the tables in the MDE files were linking to and MDB
file, however, I have removed the links and it is still happening.
All of the help sites and articles refer to what to do if you get this
message when using a b/e - f/e MDB but I can't find anything about
getting this error with an MDE. Its the fact that the LDB file is not
being created that is really confusing.
Please help!!!!!
Willow

Dec 21 '06 #1
1 5066

Willow wrote:
Hi

I hope you can help me with this it is driving me nuts.
I've created a database which I needed to give multiple people access
to but didn't want them messing so I created an MDE file. I ensured
that the MDB file was set to shared, not compacting and set to run
users not owners permissions before I converted.
However, if one of the users goes into the database, it does not create

and LDB file and if anyone else tries to get it, the error message:
Could not use <name>; file already in use. (Error 3045)
appears. Some of the tables in the MDE files were linking to and MDB
file, however, I have removed the links and it is still happening.
All of the help sites and articles refer to what to do if you get this
message when using a b/e - f/e MDB but I can't find anything about
getting this error with an MDE. Its the fact that the LDB file is not
being created that is really confusing.
It shouldn't matter that the file is an MDE as opposed to an MDB, so
any advice you read concerning MDB's should apply to MDE's in this
regard. Both should create lock files. Did you put a single copy of
the MDE file on a network server for everyone to use? If so, you will
need to set permissions on the folder where you put it so that each
user can both create and delete files there. In general creating a
single MDB or MDE for shared use is a bad idea and you should consider
splitting it out so that each user has a copy of the front end linking
to a single back end. If you have already done this each user will
still need permission to create and delete files in the folder on the
network where the back end is stored and on the folder on the user's
machine where the front end is stored. This is because the first user
to access a closed database must be able to create the lock file and
the last user to leave it must be able to delete it.

Bruce

Dec 21 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: matt | last post by:
I have compiled some code, some written by me, some compiled from various sources online, and basically i've got a very simple flat file photo gallery. An upload form, to upload the photos and give...
0
by: Jagdeesh | last post by:
Hai Colleagues, I am using Tomcat 4.1.24 and JDK 1.4.0_03 in my winXP machine. I've transferred a set of folders(containing jsp files) into tomcat's webapps directory(to /webapps/bob ,...
1
by: jase_dukerider | last post by:
Hi I have an assignment to hand in shortly for which I am after some guidance. The task is to read a WAV file, request a fade in /out time for the track from the user and the do the fade by...
5
by: Codeman II | last post by:
Hi there, I am building a form where the user must upload a picture and fill in his details. Now I have a problem as all of this is on the same form. How will I be able to have the Browse...
1
by: Erland | last post by:
Hi all, I have made an ASP.NET 1.1 application on windows 2000 advanced server. In the application, i have saved the file using the following code string str; str="this is my data";...
2
by: antonyliu2002 | last post by:
I am testing AJAX. I've downloaded the AJAX Extension and the CTP December package and installed on BOTH my development machine and the production server. Then I created a very very simple web...
1
by: Sean128 | last post by:
Hi, I hope someone can help me - this seems like it should be a really simple problem but I've been having trouble trying to solve it all week. I have hosted my website on a Linux server in 1...
3
by: MLH | last post by:
The specified file is currently being used by another user or session. Wait for the other user or session to finish working with the file, and then try the operation again. So, I've got db1.mdb...
3
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I cut and paste the following code from msdn help page which it just introduces view and multiview server controls. Here is what I do: in vs studio 2005, File --New Web Site, it...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.