I'm getting this message when starting application A (Access 2003),
while Application B (Access 2.0) is running.
ABC.mdb is a back-end Access database (2.0) that has shared tables
with links in both applications A and B.
This problem does not exist when application A (2003) is started first
(before application B (2.0)! It seems that A2003 cannot read .ldb file
created by A2.0, however A2.0 can read .ldb file created by A2003!
For now, I'm getting around this by opening all back-end databases by
some A2003 front-end, keep it open all time. But I'm looking for a
more robust solution.
Please note: upgrading applicationB (2.0) to Access 2003 is NOT an
option!
Thanks for reading
Mourad
2  5026 
The only thing I can think of is checking to see if the "Open exclusive" box
is not checked when starting App B. I don't think that checkbox should
affect the back-end db, but worth a look.
"Mourad" <mo************ @gmail.comwrote in message
news:b1******** *************** ***********@z6g 2000pre.googleg roups.com...
I'm getting this message when starting application A (Access 2003),
while Application B (Access 2.0) is running.
ABC.mdb is a back-end Access database (2.0) that has shared tables
with links in both applications A and B.
This problem does not exist when application A (2003) is started first
(before application B (2.0)! It seems that A2003 cannot read .ldb file
created by A2.0, however A2.0 can read .ldb file created by A2003!
For now, I'm getting around this by opening all back-end databases by
some A2003 front-end, keep it open all time. But I'm looking for a
more robust solution.
Please note: upgrading applicationB (2.0) to Access 2003 is NOT an
option!
Thanks for reading
Mourad
Thanks for your input,
Both front-ends are opened in shared mode (exclusive is unchecked),
otherwise the behaviours would be the same when I start 2003 first!
It is that 2.0 layout the header page of the back-end mdb in a way
that is interpreted by 2003 as the database is being locked/in use.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Fie Fie Niles |
last post by:
I have IIS installed on XP Professional workstation machine. I have an ASP
page that open connection to an Access database, then when trying to update
the database, it gave me the error "cannot update database or object is
read-only". This is a workstation machine, not connected to any other
computer, and I login to the PC using an administrator account. I already
check the .MDB file is NOT read-only. But, I do not see the .LDB file....
|
by: M K |
last post by:
I get the message: 'Could not use ''; file already in use.' on my pages if I
am working in the database. I used to be able work in the database (Access)
and users use the site, but I tried to install Remote Debugging tools from
VStudio 2k3 and since then it has been messed up.
Please, this is very important for us to fix. We are having errors if two or
more people are on the site at the same time.
|
by: Miro |
last post by:
I've read a couple of threads on this error but none of them could help me so
I'm posting myself.
When I try open and read (not update) an ACCESS database on a network share
I occasionally get:
"Could not use ''; file already in use." error.
This always happens when the database is open but sometimes even when it's
not. Not manually anyway. I consequently use DataAdapter.Fill() method which
|
by: ed |
last post by:
Hi, how do i check if other applications is already connected to an access database (.mdb file)? Let's say I have an application that opens an mdb file, for example - test.mdb. Then I opened another instance of the same application and it will also connect to the same mdb file, in this case - test.mdb. What i want is for the application to detect/check/filter that another application is connected to the .mdb file, thus preventing the second...
|
by: ed |
last post by:
Hi, how do i check in vb.net if other applications is already connected to an access database (.mdb file)? Let's say I have an application that opens an mdb file, for example - test.mdb. Then I opened another instance of the same application and it will also connect to the same mdb file, in this case - test.mdb. What i want is for the application to detect/check/filter that another application is connected to the .mdb file, thus preventing the...
| | |
by: PJSimon |
last post by:
I know that I can export a DataSet to XML. How can I save the DataSet to a
Microsoft Access MDB file?
Could you provide some sample code if it's a tough solution, please?
Thanks in advance!
|
by: Martin |
last post by:
Using ODBC in a PHP script, I'm trying to read an MS Access MDB file
that resides on another computer on my LAN. I'm getting the error:
Warning: odbc_connect() : SQL error:
The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened
exclusively by another user, or you need permission to view its data.,
SQL state S1000 in SQLConnect in ...
The file is NOT already opened exclusively (or in any other manner)...
|
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...
|
by: student2 |
last post by:
Hi,
I'm a student looking for any recommendation to finding a solution to the following problem.
(Hope I'm posting in the correct 'section' of the forum, since my error says both IIS and ASP)
I'm running IIS on my WIndows XP Pro OS.
I'm connecting an Access database (.mdb file) to Dreamweaver CS4.
I've made the connection with the following string
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\mySite\mySite.mdb;"
|
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...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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();...
|
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...
| | |
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
| |
