Solved

Windows 2003 Server: Access 2003:  Recordset Not Updateable...

Posted on 2004-10-05
2
184 Views
Last Modified: 2010-03-18
Hi everyone,

I have a database (MS Access backend (2000 format) and mde frontend (2002 format) and I'm running it in a bunch or environments without problem.  People run the frontend and it connects to the backend.

I just loaded in in a new environment (a campus with 3 buildings connected by WiFi bridges), a Windows 2003 server and Access 2003.  On some computers it works fine, but on others it says "the recordset is not updateable" in the status bar when forms are loading and then no new data can be put in the database.

Is this something to do with the new Win2k03 security with XP workstations or is it an Access issue?

Thanks

Ben
0
Comment
Question by:funkymonk
2 Comments
 
LVL 1

Accepted Solution

by:
drben earned 500 total points
Comment Utility
Make sure the user has full permssions (read/write) on that folder, including for the share (if it's mapped) and under Security for the folder/files.  That should solve the issue.
0
 
LVL 1

Author Comment

by:funkymonk
Comment Utility
Thanks, DrBen.  that was totally it!  I had the permissions set for the share, but not under Security.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Sometimes you might need to configure routing based not only on destination IP address, but also on a combination of destination IP address (or hostname) and destination port number. I will describe a method how to accomplish this with free tools. …
Have you ever set up your wireless router at home or in the office to find that you little pop-up bubble in the bottom right-hand corner of Windows read "IP Conflict - One of more computers on the network have been assigned the following IP address"…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now