Problem with multiple backup copies of database

LillyC
LillyC used Ask the Experts™
on
I have a client that has an Access Database that is used by 5 multiple users via the network server.  This has been running ok for 5 years but recently (started 2 weeks ago) the database has started creating multiple backups (eg backup..., backup of backup..., backup of backup of backup etc). This has happened twice over the last 2 weeks. It seems to create a new backup when a new user goes into it.

It was created in v2013 and the users have v2016. I can't access the original I get the error message 'id is not an index in this table'. I can however open the backup file.

Does anyone have any idea why this has started to happen?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AlexSenior Infrastructure Analyst

Commented:
The second you open a database in a newer version it tries to update the source of the database, give them 2013 again or be prepared to update the code running the DB.

Regards,
Alex
LillyCDatabase Developer

Author

Commented:
Please clarify what do you mean by updating the code (VBA code?) and how it can be done?  I have sent them fresh 2013 version couple days ago but it happened again this morning.

thank you
Lisa
AlexSenior Infrastructure Analyst

Commented:
So when you open up an access database with a new version, it upgrades the database, you'd have to restore the previous version and then open it in Access 2013. When it's updated it can't be reverted.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Alex,  I'm not sure this has anything to do with the backup issue that Lilly is experiencing.

@Lilly,

I believe what Alex is referring to is that if a user with A2016 opens an Access front-end it will update the references in the VBA editor to those used by Office 2016.  If another user running A2013 attempts to open the same FE after the A2016 has modified the references, then you will get errors because Access cannot properly adjust the references back to the Office 2013 versions.

Are users sharing the same front-end database, or just the same back-end?

Do you have anyone attempting to open the front-end via a WiFi connection?  Running Access over a WiFi connection can cause this type of corruption.
LillyCDatabase Developer

Author

Commented:
They have 2016 and I have 2013. They have been using it for last year, the multiple backups only start appearing two weeks ago, so it does not not look like its a version issue.

Can multiple backups be stopped somehow?

Thank you
LillyCDatabase Developer

Author

Commented:
Thank you both for your comments.

Dale - I will ask if any of the users are using wifi connection, just to clarify the users are using v2016 and I'm developing in v2013.  The latest version of their database has not yet been split as there has been regular changes.
So currently they are all accessing the latest unsplit database, but this hasn't created a problem before only in the last two weeks.
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
<<I get the error message 'id is not an index in this table'>>

 Th DB is corrupt in some way.  Create a new DB and import all the objects into it.

<<Does anyone have any idea why this has started to happen?>>

 It may be related to a recent windows update that causes problems for MS Access assuming nothing else has changed in your environment.  What you'll want to do is disable leasing on the server:

https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d

 and see if that clears up the issue.

Jim.
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
You also need to split the db.  Everyone should be working with their own copy of the application front end.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial