Okay - my turn.
I have an Access app (duh) with linked tables to SQL Server 2005 at BE.
I have a specific table that is the record source for a form.
Whenever I try to edit data in this table it complains that someone else has edited or is busy editing the record. Gives me the option to save to clipboard or lose my changes.
Since this app is under development and I am the only person working on it, and I know that I have not got any other locks on it. I suspected that maybe there was some rogue element holding a lock on it.
So I went int SSMS, Management, Monitoring and looked for any locks - none there.
Opened the table in SSMS and could edit there directly - no problems there either.
So, I went directly into the table in Access 2007 by double clicking n the linked table and tried to edit there. Same error.
Dropped the linked table and recreated it. Tested a write into one of the cells and was informed that there is a record lock in place.
Frustrated, I created a new Access db, linked the table in again and tried from a different app. Same problem.
I stopped & restarted the SQL Server sevices. Tried again and same problem.
I then restarted the server & retried - same problem.
I then upsized 1 of the tables to SQl Server so that I could quickly create an ADE file. Went into the table from within the new app and could edit a record.
Went back to my linked in app - and couldn't.
I am going to walk away from this for an hour or two and try again later.
Anyone have any other ideas?
Does seem to point back to the linked table/ODBC driver type of issue.
I would really appreciate any suggestions.
Sean
I have an Access app (duh) with linked tables to SQL Server 2005 at BE.
I have a specific table that is the record source for a form.
Whenever I try to edit data in this table it complains that someone else has edited or is busy editing the record. Gives me the option to save to clipboard or lose my changes.
Since this app is under development and I am the only person working on it, and I know that I have not got any other locks on it.
I suspected that maybe there was some rogue element holding a lock on it.So I went int SSMS, Management, Monitoring and looked for any locks - none there.
Opened the table in SSMS and could edit there directly - no problems there either.
So, I went directly into the table in Access 2007 by double clicking n the linked table and tried to edit there. Same error.
Dropped the linked table and recreated it. Tested a write into one of the cells and was informed that there is a record lock in place.
Frustrated, I created a new Access db, linked the table in again and tried from a different app. Same problem.
I stopped & restarted the SQL Server sevices. Tried again and same problem.
I then restarted the server & retried - same problem.
I then upsized 1 of the tables to SQl Server so that I could quickly create an ADE file. Went into the table from within the new app and could edit a record.
Went back to my linked in app - and couldn't.
I am going to walk away from this for an hour or two and try again later.
Anyone have any other ideas?
Does seem to point back to the linked table/ODBC driver type of issue.
I would really appreciate any suggestions.
Sean
