MDE file error 3045 - PLEASE HELP! - Microsoft Access / VBA

Willow

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

Subscribe Reply

5092

deluxeinformation

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

Similar topics

3932

Help debugging Flat File Picture Gallery

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 them a caption, storing the caption and filename in a text file. It's a bit buggy when removing the photos and captions from the file, and also in displaying them on the delete page. you can see it in action at www.4am.com.au/gallery/upload.php...

PHP

3688

Error encountered in running a JSP file in Tomcat...Pls. Help

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 , /webapps/sue) and i have added the folders bob, sue in my server.xml(in the context path). When i am trying to run jsp files from my browser, it works fine. But, the following jsp files reports some exceptions which is quite hard to understand. Here is...

Java

4363

wav file fade in/out help

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 modifying the binary file then writing it as a new file I have attached my code so far but do not know how to do the fade and how to write it as a new file. Please help! #include <stdio.h> #include <stdlib.h> #include <string.h>

C / C++

5906

Upload file having Browse button and Submit button on same form

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 button to open the "file browse" dialog and the Submit button to submit the form data.

PHP

1454

Help to solve error while reading a file?

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"; FileStream fs=new FileStream("mytxt.txt",FileMode.open); StreamWriter sr=new StreamWriter (fs); sr.Write(str);

ASP.NET

151661

Could not load file or assembly 'System.Web.Extensions

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 application, which contains a button and a label. When the button is clicked, some message is shown on the label. That's it. The AJAX works great on my development machine, but on the production server, I got the typical error as follows:

ASP.NET

1719

What is wring in my .htacess file. Please help

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 and 1 that I can not modefiy the Apache server. They told me I need to create the .htaccess file. The code that I put in my Biocon folder in my .htaccess file is: php_value include_path "/bioconstore/lib:/plate-latest"

PHP

4358

Couldn't use <name>; file already in use. (Error 3045)

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 open, yeah. I select a report in database window, yeah, press ctrl-C, then change to another application window on same machine, running Access 97 with Other.mdb open and the Reports Tab selected it's database window... I press ctrl-V and get...

Microsoft Access / VBA

2933

web.config file problem

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 brings me to the dir: C:\Visual Studio 2005\WebSites\WebSite1, it creates default.aspx and default.aspx.vb and I pasted the following code into default.aspx. I go to build to build web site and it says:------ Build started: Project:

ASP.NET

9706

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10569

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10075

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7615

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6847

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5519

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4295

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3815

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2990

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General