Access 2010 Table suddenly read-only, how do I remove that restriction?

[Cleave_1b]

This application has worked fine in the past, but now I find it stops cold saying a particular linked table is read-only. I've looked around and all I can find in the various forums is how to MAKE a table read-only. Reversing that process seems very difficult.



The application is a copy of another that now exhibits the same problem. Each uses a different data mdb - part of the development I'm doing involves changing a different table. I'm developing changes to the application in this separate copy.

I can't tell if other tables would have this problem - the table in question is the very first used (initialization routine) and I can't get past it without deactivating a bunch of code.

I sure could use help on this one!

[burrina]

We can't advise because we don't know the routine code. Of course tables can be locked via code. Example:

Set r = CurrentDB.OpenRecordset(SomeTable, dbOpenTable , dbDenyRead)

However, I suspect that you have changed the Record Locks! Is this db being used in multi-user environment? What are your requirements for editing a record? Is some form based on a query and the record locks being incorrectly set?

[Cleave_1b]

I have just found that this is unique to my windows 7 desktop computer. Works ok on my windows 8 computer. The code is identical (dropbox keeps them updated). Must be something not in the application itself. What sort of thing could it be "on the outside?"

[burrina]

Using Dropbox is going to cause you corruption, suggest you stop using it.

[Cleave_1b]

I've used Dropbox for years now and never had a problem. Sugarsync was disastrous. It IS important, however, to give Dropbox plenty of time to sync before switching computers.

The unchanged application is now stopping at a different place on the desktop computer. The code:

Public Sub LogPoint(Process As String, Point As String)
If Not FileExists("P:\Log\Log.txt") Then Open "P:\Log\Log.txt" For Output As #1
Close #1
Open "P:\Log\Log.txt" For Append As #1 '<<<<<<<<<<<<<<<<<<<< Here's the error stop
Print #1, Format(Now(), "MM/DD/YYYY-HH:MM"), CurrentEditor, Process, Point
Close #1
End Sub

the function called is

Public Function FileExists(F As String) As Boolean
On Error GoTo no
FileExists = True
Open F For Input As #33
Close #33
On Error GoTo 0
Exit Function
no:
FileExists = False
On Error GoTo 0
End Function



The log file does exist with the same name in the same place. P: is a mapped drive. The log file is used as an external record, mostly of what user was doing what when so we can trace back for data goofs. In case anyone wonders, I did reboot yesterday and I got the same error.

[burrina]

Here is a link that may help. http://www.regmender.com/how-to-fix-...-error-75.html

[Cleave_1b]

I've narrowed the problem to the use of the mapped drive (P. If I replace it with the defined directory name the error does not occur. On a search I found that there is a possibility that it has to do with permissions.I verified that I am logged in as administrator and checked user privileges and all are set.

Something just occurred to me: I recently swapped out my hard drive on the desktop with what I call a "soft drive" - an SSD. The speed-up resulting might have something to do with the situation. Any ideas? Should I put in a sleep call?

[burrina]

I don't think the drive has anything to do with it. Is the problem resolved now? You don't need a sleep call unless under very special conditions. I don't think that applies in your case.

Good Luck!

[Cleave_1b]

Thank you - you're right; I put in a 50 ms sleep and it did nothing. Actually I should have realized it because of the delay between the error stop and the retry with F5 was plenty long.

PROBLEM SOLVED:

It was the mapping of P: I redefined the network, mapped P to "same place" and things work. The difference was that P was originally

\\Rgcdesk\c\Users\Dick\Dropbox\VoterNew

Where it should have been

\\RGCDESK\Users\Dick\Dropbox\VoterNew

Sigh!

Thanks to you, Dave, for sticking with me through all these dead ends!

Dick