Microsoft Access 2007 corrupted files

Question

I made a copy of a .ACCDB file and converted its contents into .xlsx, but when trying to access the original file, I'm encountering the following error: "the record source specified on this form or report does not exist."

The Navigation Pane is working and allows me to access the files I need. This seems to be a problem with the login form; regardless of which password I input, selecting the "OK" option doesn't do anything; it should take the user to a panel that allows them to select the data they want to access. I'm assuming it's something wrong with my visual basic code and/or the SQL query, but I can't pinpoint the problem and it's been quite frustrating.

Any suggestions?

Answer 1

Hi,

It's likely related to the login form and the associated Visual Basic code or SQL query. Here are a few suggestions:

1. Check the Record Source: Make sure the record source specified on the form or report exists and is correctly spelled. Verify that the table or query referenced in the record source is present in your database.
2. Verify SQL Query: If you're using a SQL query as the record source, double-check the query syntax and ensure it returns the expected results. Test the query separately to ensure it's functioning correctly.
3. Check Form/Report Properties: Review the properties of the form or report in question. Ensure that the record source property is correctly set and matches the underlying data source.
4. Rebuild the Form/Report: If all else fails, consider rebuilding the login form or report from scratch. This can help identify any potential issues in the design or code.

Also, refer to this thread- https://stackoverflow.com/questions/40461584/microsoft-access-2016-record-source-does-not-exist

If your file is corrupted, try using a 3rd party access database repair tool to repair your file.

Best Regards.