I have a .MDB back-end database that is created with Access 2.0.
And multiple front-end mdb's, some are created by Access 2.0, and the
rest are created by Access 2003.
The fron-ends had table attachments to the back-end database.
The problem is I'm unable to access any table by both versions of
Access in the same time!
Here are the steps to replicate the problem
1- Open one Access 2.0 front-end mdb, then open the attached table T1
2- Open another Access 2003 front-end mdb, try to open the same
attached table, you will get the error "Could not use .mdb; file
already in use."
3- I can only open the table from Access 2.0 front-end.
It seems Access 2.0 locks the table against 2003 version only.
I'm trying to find a patch/service pack, workaround.
Your feed back is greatly appreciated.
Thanks,
Moor
9  2416 
The easiest workaround would be to export the data from the
tables in the Acc2.0 mdb as textfiles and then import those textfiles
into an Acc2003 mdb. If this will be tedious because you have a few
dozen tables to export then an alternative would be to ... well, you
could automate the process with VBA and loop through the tabledefs
collection (for the table names) and create the textfiles that way and
then import them into a Acc2003 mdb.
Rich
*** Sent via Developersdex http://www.developersdex.com ***
Thanks, Rich,
In fact the problem is not in the Export/Import process. It is about
opening the 2.0 mdb files using different versions of MS Access,
epecifically 2.0 and 2003.
Best regards,
Mourad
Right. You can't open/access the Acc2.0 tables from the Acc2003 mdb.
So export the data from the Acc2.0 mdb to textfiles. Then import those
textfiles to a new Acc2003 mdb. Now you will be able to open/access the
tables in the Acc2003 mdb from any other Acc2003 mdb.
Rich
*** Sent via Developersdex http://www.developersdex.com ***
Thanks Rich and Tony,
I will have to admit I was not clear about my question.
I have two front-end databases, one is version 2.0 and the other is
version 2003.
Both have links to tables that are stored in a back-end database
(version 2.0)
Now I open the 2.0 Front-end database using Access 2.0
Then open the 2003 front-end database using Access 2003 (from another
machine)
Now I cannot open any linked table in Access 2003, I get the error
"Could not use '.mdb'; file already in use.
It seems Access 2.0 locks the whole database.
Upgrading the back-end database to 2003 is not an option.
Upgrading ALL the front-ends to 2003 is not an option either.
I have to live with the situation of mixed front-end and 2.0 back-end
Thanks for reading,
Mourad
OK. Now I have your situation straight. It turns out that I too have
had a similar situation where there were no options for synchronizing
the systems correctly. The solution I came up with is summed up in 2
words:
"Good bye!"
Rich
*** Sent via Developersdex http://www.developersdex.com ***
Moor <mo************ @gmail.comwrote :
>I will have to admit I was not clear about my question.
I have two front-end databases, one is version 2.0 and the other is
version 2003.
Both have links to tables that are stored in a back-end database
(version 2.0)
Now I open the 2.0 Front-end database using Access 2.0
Then open the 2003 front-end database using Access 2003 (from another
machine)
Now I cannot open any linked table in Access 2003, I get the error
"Could not use '.mdb'; file already in use.
It seems Access 2.0 locks the whole database.
Upgrading the back-end database to 2003 is not an option.
Upgrading ALL the front-ends to 2003 is not an option either.
I have to live with the situation of mixed front-end and 2.0 back-end
I undetstand all that. However you didn't answer my question.
Is this a new problam or has this never worked before? Was this working for you at
one time?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
This is a new situation, that came up when I decided it's time to
upgrade.
Moor <mo************ @gmail.comwrote :
>This is a new situation, that came up when I decided it's time to
upgrade.
I doubt very much you will find a solution. I suspect that MS removed support for
A2.0 in A2003.
Now it may be possible to use A2000 to link to an A2.0 MDB. Ah, here we go. A quote
from A2000 help.
"Run the Linked Table Manager (Tools menu, Database Utilities command) to link the
new Microsoft Access 2000 front-end database to the tables in the previous-version
database. You can then enhance the Microsoft Access 2000 front-end database to
support new features, for users that have upgraded to Microsoft Access 2000. Users of
previous versions can continue to use the previous-version database. For example, if
the back-end tables are in Microsoft Access version 2.0 format, you can use up to
four versions of Microsoft Access: Microsoft Access version 2.0 (using the original
database), Microsoft Access 95 and 97 (using an enabled version of the original
database or a converted front-end database), and Microsoft Access 2000 (using a
converted front-end database). "
One possibility then might be to use an A2000 runtime for your users to use A2.0
data.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Thanks, Tony,
I've found some work around, but I need to do more testing.
If I open a 2003 front-end FIRST, then open the other 2.0 front-end,
things seem to work OK. I even tested some concurret updates and they
succeded!
I colcluded that if the .ldb file (for the back-end database 2.0) was
initially created by A2.0, for some reason A2003 fails to open it or
fails to recognize its contents. So by creating it using A2003, then
it can be oened and read by A2.0 !!
My concern is that the Locking layout in the header page of the
database is different: A2.0 use 256 bytes (one byte per user), and
starts at x700 Hex, while A2003 use 512 bytes (2 bytes per user), and
starts at x600 Hex! But Microsoft claims that Jet 3.x (used by A2003)
is backword compatible to Jet 2.x, and it can access linked tables
created by Jet 2.x
Best regards,
Mourad
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Hardik Shah |
last post by:
Hi,
I am calling an ASP.Net page from an ASP classic application but need
the .Net page to have access to ASP classic's session variables. I am
using HTTPWebRequest to call ASP classic page which could then return
the session values. But the values are always blank. If I do a
Response.Redirect() to call the ASP page, it returns the values okay.
But I cannot do a Response.Redirect() as I just need to access some
session variables and...
|
by: bruce.1 |
last post by:
I'm trying to figure a way for a remote user -- using ASP.NET -- to
share files on a local office LAN.
The remote user would go to an ASP.NET website (on the LAN), mark the
files they want, and ASP.NET would facilitate a download, and keep a
record in a small database of who downloaded and uploaded whatever.
These are big files, say 4 MB, so it's best if the remote user downloads
the file, edits it, then uploads it back to some folder...
|
by: ShyGuy |
last post by:
Is there a simple way to allow someone to access a backend on my
computer with another person over the internet?
|
by: Bob Alston |
last post by:
Having problems sharing an Access database on a Windows 2000 PC. The
other PC is windows 98 (as I recall) but NOT windows 2000!
The 2nd PC has a shortcut to the MDB on the primary PC.
The MDB can be opened - 1 user at a time.
The MDB Options - Advanced -
Default open mode = shared
Open databases using record locking is checked
|
by: Kissi Asiedu |
last post by:
I have a database in a shared folder, however users with permission can only
access the database in read-only format. What have I done wrong? This is on
Win Xp Pro and Access 2003. Please help.
Thanks.
| | |
by: Max Vit |
last post by:
I have deployed few Access apps splitting it in Front End and Back
End. Our environment uses Win XP SP2 for clients, Win 2k3 for servers
and Access 2003. The max. number of clients is about 50 (concurrent
users is estimated around 10).
Whilst the Back End always lives on a server, I am not quite clear
where the Front End should live.
I have searched the web and find contradicting views.
|
by: Peri |
last post by:
Dear All,
Is there a way in which 2 application can share a common memory location to
access static data?
Say for example I have a product master data that is available in a single
place, and I have an application that uses this data to do its own
operation. I also have a similar kind of another application that uses the
same data for its another operation. Can we implement this in C#?
|
by: ARC |
last post by:
Hello all,
This is really a computer sharing / network question, so sorry for posting
here; it's the only newsgroup I post in.
I have a customer with a database file on a vista machine under Users\\, who has a 2nd pc with window xp. They're getting all kinds of access
errors relating to the .mdb being read-only, etc., when they try to access
the database from the xp machine.
Using remote control, I turned on sharing for that folder...
|
by: limperger |
last post by:
Hello everybody!
I have just found out that the sharing properties of a single database (mdb file on a network), accessed by 3 users, change depending on the user accessing the database. That is, with the file opened by 2 users at the same time, in my computer, the sharing properties appeared as set to share (not exclusive) and single entry-lock. Nevertheless, in the computer of the other user, the sharing properties are set to exclusive mode...
|
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: 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...
| | |
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
| |
