|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 15th, 2009, 04:26 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
#Deleted record on Database
I am using Access 2007. On one of my databases there is a record embeded
that has #Deleted in all fields. I tried to manually delete the record, but when I close the database and reopen , the bad record is still there. All queries fail when trying to read the database. I've tried to run a delete query but it fails too. Help. 
|
|
#2
April 15th, 2009, 04:34 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
#Deleted record on Database
My guess would be it is because the table or query is not editable (has the
asterisk and arrow at the bottom un-highlighted.) To get around that, pull the info into a query then make-table to create a table that is editable. Then delete the record. -- Milton Purdy ACCESS State of Arkansas "Steve." wrote: I am using Access 2007. On one of my databases there is a record embeded that has #Deleted in all fields. I tried to manually delete the record, but when I close the database and reopen , the bad record is still there. All queries fail when trying to read the database. I've tried to run a delete query but it fails too. Help.
|
|
#3
April 15th, 2009, 05:01 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
#Deleted record on Database
The Database is editable.....I can update other records with no problems. I
can not run queries - I get error message Error Occurred "golfinray" wrote: My guess would be it is because the table or query is not editable (has the asterisk and arrow at the bottom un-highlighted.) To get around that, pull the info into a query then make-table to create a table that is editable. Then delete the record. -- Milton Purdy ACCESS State of Arkansas "Steve." wrote: I am using Access 2007. On one of my databases there is a record embeded that has #Deleted in all fields. I tried to manually delete the record, but when I close the database and reopen , the bad record is still there. All queries fail when trying to read the database. I've tried to run a delete query but it fails too. Help.
|
|
#4
April 15th, 2009, 05:13 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
#Deleted record on Database
Here's the error msg:
Record is deleted. (Error 3167) You referred to a record that you deleted or that another user in a multiuser environment deleted. Move to another record, and then try the operation again. "Steve." wrote: The Database is editable.....I can update other records with no problems. I can not run queries - I get error message Error Occurred "golfinray" wrote: My guess would be it is because the table or query is not editable (has the asterisk and arrow at the bottom un-highlighted.) To get around that, pull the info into a query then make-table to create a table that is editable. Then delete the record. -- Milton Purdy ACCESS State of Arkansas "Steve." wrote: I am using Access 2007. On one of my databases there is a record embeded that has #Deleted in all fields. I tried to manually delete the record, but when I close the database and reopen , the bad record is still there. All queries fail when trying to read the database. I've tried to run a delete query but it fails too. Help.
|
|
#5
April 15th, 2009, 06:15 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
#Deleted record on Database
On Wed, 15 Apr 2009 08:26:09 -0700, Steve.
wrote: I am using Access 2007. On one of my databases there is a record embeded that has #Deleted in all fields. I tried to manually delete the record, but when I close the database and reopen , the bad record is still there. All queries fail when trying to read the database. I've tried to run a delete query but it fails too. Help. This could be corruption. Make a backup of your database, and Compact it. Is this a local table in your database? .accdb or .mdb? Or is it linked to some other backend database? More info please! -- John W. Vinson [MVP]
|
|
#6
April 17th, 2009, 04:59 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
#Deleted record on Database
Steve, create a new table, and import the good records, without referring to
the bad one. Details: http://allenbrowne.com/ser-47.html#RowsShowDeleted -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Steve." wrote in message ... Here's the error msg: Record is deleted. (Error 3167) You referred to a record that you deleted or that another user in a multiuser environment deleted. Move to another record, and then try the operation again.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
