Periodically we find a record in a table that has #Deleted in all feilds of the record. It can not be deleted. The database must be compacted and repaired...

I really seem to be having a bad day. I have a table which needs to be emptied and refilled at start up. The table is then used to supply the data for a...

No matter how many times, I can delete that record untill I turn purple fall over and die, but it just keeps coming back. And... do to the shear stupidity of...

I'm trying to fix a form that reads an sql database. The issue that I am having is when adding new records the detail line says "#deleted". What can i do to...

I'm working with an Access frontend against a MySQL backend . When I have more than one user connect to the same access database (it's in a shared folder),...

hello, My Access is linked to an Oracle 9 database and several tables when I opened it, It's showing the #deleted text on all fields. I want to know how to...

Hello all I have an Access application that export/import data using an ODBC connection. For some reason when I upload the data to one of my linked table I...

Why do I get #Deleted returned for all rows in a SQL Server linked table in Access2003 - I know the data exists as it comes up fine in an Excel Query. It...

The following query: SELECT U.User_ID, U.Org, NZ(GV.Gap_Likelihood, 0) as Gap_Likelihood, NZ(GV.Gap_Impact, 0) as Gap_Impact FROM...

All - I'm having a strange thing happening here. I'm trying to link a table from a Sybase ASE server through ODBC and when I try to open the table, all I...

I have a simple local table containing one memo field and several other fields. Only one field is linked to another table. On one record, a user attempted to...

WinXP/Access 2003 - when links to an Oracle table, every row displays #Deleted. When looking at the data through SQL - the data is visible. If the table is...

I have the following expression in a report in Access: =Sum(NZ((IIf(="Actual-LIHTC",,0))+(IIf(="Actual-HTC",,0))) -(IIf(="Original...

I have a small Access 97 database application that uses a couple of different forms to enter and update information. The last enterable field on all of...

Access 2000 Split Front-end/Back-end We had a field in our table incorrectly set as a number field rather than a date field. So, if a user typed today's date,...

Hi! I have a MainForm with a textbox to show us IdPlan in SubForm. In TextBox ControlSource in MainForm I have: =.! When there are a plan work fine. Show us...

I am creating database that will track issues for each day. Issues can be in 4 different statuses: Open, Assigned, Pending and Closed. At the end of the...

I am getting "#error" in one of my fields when I try to preview my database. What does that mean? I am a novice in Access, so please explain in...

I have the following formula in the control source of one of my textboxes and when there is no data in my "HoursAccrued" field then I get the #Error...

I have developed a report based on a query . The problem is if there is no records to be displayed on the reports it display #Error at that place . I want to...