Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help on error 3167: "Record is deleted"

Status
Not open for further replies.

VoiceOfThunder

Technical User
Joined
Mar 23, 2004
Messages
4
Location
US
My database is in the network (multi-users environment). one of the records keeps on creating "#error" across the fields by itself (at that is what I saw on the from where it litterally changing before my eyes), therefore, and when user try to update it, he gets error 3167, "Record is deleted". However, the "#error" record remain in the table (can't not delete it at all), and causing whole bunch of problems. Can't view reports, can't update, can't even repair db. Most of the times, I can't even open the database. I have to keep on using backups, but all the new records will be lost. This is very frustrating.

PLEASE HELP ME! I KNEEL BEFORE YOU TO HELP ME!
If anybody out there who about anything about this and how to solve it, please let me know. I am running of knowledge and option on what to do. Thanks in advance.
 
Have you tried PACK or SET DELETE ON|OFF?

Off hand I'd say there's some code doing something you don't want. Try tracking all references in your code related to DELETE.

Brian
 
I use DAO in Access 2000 to get the information from the SQL Server in my company and then put those information into the Access 2000 database for tracking. Could this be the cause?

We have been using Access database in version 97 in the past, it works fine. Couple of weeks ago, every department is upgrading their Office to version 2000, now this database is keep on putting in "#error" in certain record and cause it to crashed.

Also, a lot of us are still running on Windows NT but few are run under Windows XP. Could there be conflicts or NT is not compatible with Office 2000?

Anyone has anymore suggestions?

Thanks,
VoiceOfThunder
 
Anyone has anymore suggestions?
Post the question in Access forum?
 
I use DAO in Access 2000 to get the information from the SQL Server

I meant I used ADO . . .
 
VoiceOfThunder,

This is a VFP (Visual FoxPro) forum.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top