473,569 Members | 2,813 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

2 New Member
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 1888
JanP
2 New Member
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 Recognized Expert Moderator MVP
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
2054
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 no records that matching the text input. Any idea ? Thanks
8
2130
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 INSERT queries into a function at the top of my php file and having the SELECT queries below it. I have a message that pops up that includes a link...
2
1935
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 validation controls) display when the controls to validate loose focus and not only when the submit button (with causesvalidation=true ) is pushed.
4
2298
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 by the user either scrolling or performing some other action that would move the treeview window to a particular "unloaded" node in the treeview ...
2
1497
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" ValidationGroup="1"> <asp:Button ID="Button1" runat="server" Text="Button 1" ValidationGroup="1"
8
2251
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 window later on, I want the list of records to be udpated when the window is back in front a simple onFocus doesn't work, as what happens is that...
0
1416
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 that formview page they might do a bunch of postbacks, so the back button might not always have the desired affect of taking them back to the calling...
2
1166
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 advance.
2
5389
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, but it fires multiple times when the form is closed ... and I only want my event to be triggered once. Could someone tell me a good way to do this?...
1
1559
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. Other than using the virtual store for some config information, it doesn't do anything fancy. The strange thing is that when the application is...
0
7618
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7983
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 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...
0
6287
agi2029
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...
0
5223
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...
0
3657
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...
0
3647
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2117
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
1
1228
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
946
bsmnconsultancy
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...

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.