473,385 Members | 1,357 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,385 software developers and data experts.

Back-end now "read only" when opened by one user ...

2
Hello

I'm new here and hope someone can help solve this problem.

I built a database in MS Access 2000 and split it. Since I was upgraded to 2003, (the other user still has 2000) we cannot both use the database at the same time.

At first we got the "Access 2003 Open Exclusive Error" but have resolved that one.

Now we can both open our front ends, but only the first one in can update data. The other user gets a message saying "This recordset is not updatable".

I'm assuming that this is caused by the two versions of Access, but how do I get round it?

Cheers, Jan
Apr 3 '07 #1
2 1864
JanP
2
Sorry to ask again but I need help with this. I've seen other similar questions in this and other fora, but nothing applies to or helps this problem. Does anyone have any ideas?
Cheers, Jan
Apr 3 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
Hi Jan

Leave the backend as a 2000 file and make sure the Default Open Mode is set to Shared (Tools - Options).

Create two front-ends. One a 2000 version and the other a 2003 version. Now you should both be able to access the backend.

Mary
Apr 4 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: ywchan | last post by:
I have implemnt a onBlur event of a text input. In the event, a window with all records which related to the text input will be shown. However, I don't want to pop up the window in case there is...
8
by: Ian Davies | last post by:
Hello I am trying to run a few INSERT queries only if the user clicks 'continue' in a <a href> The queries takes variables created from SELECT queries. I have tried to acheive this by putting The...
2
by: Humberto Alvarez | last post by:
Hi All I'm using asp requiredfieldvalidator and regularexpressionvalidator to validate a text field and a file input field respectively. The validation messages (the text property of the...
4
by: pmcguire | last post by:
I have a treeview with a lot of nodes. I want to load only the nodes that are initially visible when the form loads, and then continue to populate it in background and/or when the nodes are required...
2
by: Pawel Pabich | last post by:
Hi, I have very simple code: <asp:TextBox ID="TextBox1" runat="server"/> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"...
8
by: zacware | last post by:
I have an AJAX enabled page which contains a list of records out of a database which are loaded into a div via an AJAX call. If the user switches to another window, and comes back to this open...
0
by: jobs | last post by:
I have a page where users select from a bunch of gridviews, setting session variables and then hit an a New or Edit button which redirects them to a formview in edit or insert mode. While in...
2
by: =?Utf-8?B?VkIgLk5FVCBSb29raWU=?= | last post by:
I am creating an application and now when I try to run my program the forms open as Read Only and I can't type any text into my text boxes. How do I change this back to normal???? Thanks in...
2
by: Tom_F | last post by:
To comp.databases.ms-access -- I would like to trigger an event when I close a form -- but ONLY when the data in the "RecordSource" table has been updated. I tried using the AfterUpdate event,...
1
by: Alex | last post by:
Hello everybody, I've been working for days on a "twilight zone" bug and I can't make any sense of it. This is in an application that was developped on XP and that was modified to handle Vista....
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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
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...

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.