Cannot Update (1 Viewer)

LewisCooper

New member
Local time
Today, 04:37
Joined
Jan 15, 2015
Messages
2
We have a very mature (over 10 years old) MS Access application that is linked via an ODBC connection to a SQL backend. We deploy the application using RDP on a Terminal Server. Each user has their own copy of the front end application. We are running a full version of Access 2003 not a runtime version.
We have started receiving this error a couple weeks ago, about 1-1-15 . “Cannot update. Database or object is read only.
The VBA code had not changed.
The SQL server had not changed.
Nothing was changed intentionally.
I am willing to $1,000 to the person who can resolve this issue.
We have two veteran Access programmers who, one wrote the code years ago, and have stepped through the code and cannot resolve the issue.
We contracted a SQL expert and his opinion was it was not anything to do with the SQL database.
The code will run successfully IF we run directly against the mdb, however if we attempt to run the code the way it has run for years, via a menu system access application we get the error.
This is the only module/access date out of about 40 in our collection that is having any issues, and it is just one routine with this database that is having issues.
Please contact me direct at 435-657-5467 if you would like to have a crack at it.
Keep in mind we have been developing this Access application for over 15 years and have NEVER been stumped before.
Sincerely
Lewis Cooper
BMS Solutions

Terminal Server OS = 2008 R2 Enterprise
SQL Server OS = Windows Server 2012 standard
SQL server = SQL Server 2008 R2
MS Access Version = MS Access 2003 (11.8321.8405) SP3
 

jdraw

Super Moderator
Staff member
Local time
Today, 06:37
Joined
Jan 23, 2006
Messages
15,364
The 1-1-15 could be some trigger. Is it possible something has to be "updated/maintained" as calendar year end? Someone change a directory, moved a file... after Christmas?? Someone changed some file access permissions...? Could possibly be some corruption??

I presume the various support people have googled and tried things based on links returned. Yours is certainly not the first or only Access database to encounter this.

http://www.access-programmers.co.uk/forums/showthread.php?t=130366

http://office.microsoft.com/en-us/access-help/HV080760212.aspx

http://www.access-programmers.co.uk/forums/showthread.php?t=232208&page=2

http://stackoverflow.com/questions/20431018/recordset-update-database-or-object-is-read-only

Here's an interesting one
http://ph-tom.blogspot.com/2007/11/cannot-update-database-or-object-is.html
 
Last edited:

Galaxiom

Super Moderator
Staff member
Local time
Today, 21:37
Joined
Jan 20, 2009
Messages
12,849
There was another question here this week about a database that stopped working when the year changed to 2015.

They noted it worked if the system date was put back to 2014.

Unfortunately I can't find the thread.
 

LewisCooper

New member
Local time
Today, 04:37
Joined
Jan 15, 2015
Messages
2
Thanks for feedback guys, but my problem is tough because the routine/code/mdb runs fine from my desktop but if I copy and move to my user profile it fails so I don't think the system date is the issue, also am not able to "play" with the system date on the server. Leads me to believe it may be a permissions issue?
 

Users who are viewing this thread

Top Bottom