Solved

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

Posted on 2004-10-05
2
188 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
drben earned 500 total points
ID: 12244046
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
ID: 12244071
Thanks, DrBen.  that was totally it!  I had the permissions set for the share, but not under Security.
0

Featured Post

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

FIPS stands for the Federal Information Processing Standardisation and FIPS 140-2 is a collection of standards that are generically associated with hardware and software cryptography. In most cases, people can refer to this as the method of encrypti…
This is the first one of a series of articles I’ll be writing to address technical issues that are always referred to as network problems. The network boundaries have changed, therefore having an understanding of how each piece in the network  puzzl…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

738 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