|
| 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
September 8th, 2005, 10:31 PM
|
|||
|
|||
#name?/ deleted record error
I've used a database for a year, many users adding info to it. I've written
many queries and they've worked beautifully. This week I've been getting a "record is deleted" error and the query changes before my eyes to all the cells reading "#name?". What gives? 
|
|
#2
September 9th, 2005, 12:18 AM
|
|||
|
|||
|
If its a link table, try and refresh the link, if it doesn't help or if it is
a local table try compact and repair. BackUp first -- I hope that helped Good luck "Pogue Mahone" wrote: I've used a database for a year, many users adding info to it. I've written many queries and they've worked beautifully. This week I've been getting a "record is deleted" error and the query changes before my eyes to all the cells reading "#name?". What gives?
|
|
#3
September 9th, 2005, 04:28 PM
|
|||
|
|||
|
It worked!!!!!Thank you, OFer whom ever you are
"Ofer" wrote: If its a link table, try and refresh the link, if it doesn't help or if it is a local table try compact and repair. BackUp first -- I hope that helped Good luck "Pogue Mahone" wrote: I've used a database for a year, many users adding info to it. I've written many queries and they've worked beautifully. This week I've been getting a "record is deleted" error and the query changes before my eyes to all the cells reading "#name?". What gives?
|
|
#4
September 10th, 2005, 06:56 PM
|
|||
|
|||
|
Any time :-)
-- I hope that helped Good luck "Pogue Mahone" wrote: It worked!!!!!Thank you, OFer whom ever you are "Ofer" wrote: If its a link table, try and refresh the link, if it doesn't help or if it is a local table try compact and repair. BackUp first -- I hope that helped Good luck "Pogue Mahone" wrote: I've used a database for a year, many users adding info to it. I've written many queries and they've worked beautifully. This week I've been getting a "record is deleted" error and the query changes before my eyes to all the cells reading "#name?". What gives?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
| Ms-Access 2003 | RC | General Discussion | 23 | January 19th, 2005 08:22 PM |
| Error: Record is Deleted | Lester | Running & Setting Up Queries | 2 | June 9th, 2004 05:14 PM |
| Error: Record is Deleted | Lester | New Users | 1 | June 9th, 2004 04:38 PM |
| Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Linear Mode
