dbTalk Databases Forums  

Problem with Database Opening Read-Only

comp.databases.ms-access comp.databases.ms-access


Discuss Problem with Database Opening Read-Only in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
C-Rod
 
Posts: n/a

Default Problem with Database Opening Read-Only - 02-22-2011 , 09:41 AM






I have a split Access database with the backend located on a server
and the frontend on user desktops. Database generally has about 10
users at a time. Some people have office 2007 on their computers, but
most are still using 2003, so we've kept the db in 2003 format.
Database seems to work flawless for most individuals, but there are
about 4 people (all 2003 users) who everytime they open the database,
it appears to be read-only. At first I thought it was a record
locking issue, but it doesn't appear they can edit any record in any
table. We've verified that their access to the server is correct.
Any ideas we can try to troubleshoot this?

Reply With Quote
  #2  
Old   
Salad
 
Posts: n/a

Default Re: Problem with Database Opening Read-Only - 02-22-2011 , 12:32 PM






C-Rod wrote:
Quote:
I have a split Access database with the backend located on a server
and the frontend on user desktops. Database generally has about 10
users at a time. Some people have office 2007 on their computers, but
most are still using 2003, so we've kept the db in 2003 format.
Database seems to work flawless for most individuals, but there are
about 4 people (all 2003 users) who everytime they open the database,
it appears to be read-only. At first I thought it was a record
locking issue, but it doesn't appear they can edit any record in any
table. We've verified that their access to the server is correct.
Any ideas we can try to troubleshoot this?
This may not be of any benefit. But I'll pass it on.
http://support.microsoft.com/kb/324666

Do you get any error messages/

What happens if you open it with the Shift-key to get to the database
window? If you create a local table on the FE can it be modified?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.