John,
Well we have decided to upgrade out front-end and backend to Access 2013 and we will be moving the backend to SQL Server.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, December 10, 2014 8:29 AM
Subject: Re: [MS_AccessPros] Recordset is not updatable
John,
If that's the case I am wondering why it was working up fine up to yesterday. I am starting to wonder if a MS update was applied which effected it. I am going to check into the latest updates.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, December 10, 2014 3:39 AM
Subject: Re: [MS_AccessPros] Recordset is not updatable
Art-
AH! So the back end must be 2013 format. That would lead me to believe that 2010 can open 2013 back end, but it'll be read-only.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 9, 2014, at 11:31 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
Found out something interesting. If I run the front-end on a ACCESS 2013 desktop it works fine and I can add and modify records as usual.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, December 9, 2014 3:56 PM
Subject: Re: [MS_AccessPros] Recordset is not updatable
Yes I tried both ways, deleting the link and re-adding it and also created a new database and added the link tables and it did the same thing. I looked and there is no .laccdb file open.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, December 9, 2014 3:44 PM
Subject: Re: [MS_AccessPros] Recordset is not updatable
Art-
Have you tried deleting the linked table and re-linking it? Is that what you meant by "refreshing" the links?
If the answer to both questions above is yes, it sounds like the front end is linking to the back end as read-only. If so, are there other users who have the database open? When nobody is in the database, is there still a .laccdb file hanging around in the back end folder? If so, try deleting that file.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 9, 2014, at 10:18 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
I am opening a linked table.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, December 9, 2014 2:56 PM
Subject: Re: [MS_AccessPros] Recordset is not updatable
Art-
Are you opening a linked table or a query? If a query, what's the SQL?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 9, 2014, at 9:50 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John,
I can open the backend and edit data directly but if I open a table from the frontend I cannot edit and on the status bar it says This Recordset is not updateable. No error message.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Anyone who claimed that old age had brought them patience was either lying or senile."
From: "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, December 9, 2014 2:38 PM
Subject: Re: [MS_AccessPros] Recordset is not updatable
Art-
What sort of error messages are you getting? Can you open the back end directly and update data?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 9, 2014, at 9:06 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a Access 2010 database that for some reason has become un-updatable through the front-end. It was working fine yesterday. I ran the compact and repair on both sides. I tried refreshing the links too but to no avail.
Any ideas why this would happen?
Pretty darn, confused!
Art Lorenzini
Sioux Falls, SD
__._,_.___
Posted by: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (31) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar