Search results

Form with several subforms, each accessed by selecting a tab at the top of the form. Like a web browser with multiple tabs open.

Different tables this time. Different tab than last time. No returns on the error handler. Have done multiple tests with breakpoints stepping through the code and haven't seen the delete happen. Unfortunately, database can't be shared. Issue started yesterday afternoon. I have 10 users that...

Unfortunately, just made things more confusing. I was the only user online, no event logs triggered, no audit lines triggered, I wasn't changing any data, and wasn't clicking any buttons. Just moved to a tab set and the data showed #DELETED#. There isn't ANY code or macros that trigger on a tab...

Just happened again. I was the only one in the DB just watching to see if it would happen again. No inputs were made and the tab set that I moved to had #DELETED# in all columns. Only 3 tables were affected this time.

Would have to be a REALLY old backup file. When checking audit logs on the damaged back end the dates on the unaffected tables were all current.

I don't think the first case could of happened, since the backup is done at midnight. I'm having the IT folk that run the server check the event logs to see if something happened with a delayed backup or something. Not saying it's impossible and doesn't happen at other offices but couldn't...

I'm having the IT folk that run the server the backend is on run full system and disk checks. I don't think this is the case, because it would be extremely odd that only a file was corrupted and even more odd that only certain tables in that file were affected.

I have an audit log system set up, but it is record based. So when the records get deleted the log for the record does as well. User deletes are disabled (it's a check on the record line that the user selects so the data no longer displays). After an allotted time, I go in and delete the files...

Only person that has direct access to the backend file is yours truly.

First point is correct. I have blocked delete ability for users. Thats what is most confusing to me is that a singular table I could see an issue with cascade failure, but it was 10 random tables. No users reported a Database in unusable format (Definitely doesn't mean that didn't happen...

Cascading delete is set up, but you can check the above reply as to why that wasn't the case here.

Absolutely agree with that first statement. As far as statement 2 goes is the weird part... Cascading deletes are set up, but the records that could cause that kind of delete weren't modified. As an example: Table 1 is the main with tables 2-10 as children of that main table. Relationship is set...

None of the users know SQL or know how to run a SQL statement.

Yeah, I've never run into an issue like this in the decade of work with this db. Safe to say I'll be stepping up the backups. The tables with data loss are enforced. It's like a DELETE * ran on the tables effected, but none of the users did anything of the sort and there isn't any automaton that...

Yeah, I've checked with all of them and had them show me what they were doing at that time. Either way, the amount of data across the tables in question were deleted way too fast for it to be one of the users. Virus/Malware scan also came back clean.

Yes, the backend is Access db. I backup every day, so the data loss isn't horrible. Users can't delete records.

First time poster here, long time reader. I have a mystery on my hands and I'm hoping for some Insite. 2016 MS Access with about 10 users running their own front end (all the same version) with a backend on a server. Yesterday ALL of the records in about 10 tables got deleted. I have run down...