• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

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

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
funkymonk
Asked:
funkymonk
1 Solution
 
drbenCommented:
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
 
funkymonkAuthor Commented:
Thanks, DrBen.  that was totally it!  I had the permissions set for the share, but not under Security.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now