Share via

Can not save Access database

Anonymous
2019-12-05T05:21:37+00:00

I'm trying to save a database and I got the error "you attempted to open a database that is already opened by user 'account' on machine 'computer'. try again when the database is available. I don't get how i'm opening it when i'm saving it, and i'm also using save as to save it under a different name, so there's no way it could be the same file.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,855 Reputation points Volunteer Moderator
    2019-12-05T14:46:34+00:00

    One of the hardest things about trouble-shooting problems when we can't see the network, the accdb(s) or the actual actions being described is that we can't see those things to be able to identify the problem points.

    So, some questions might help understand the dimensions of the problem. Let's start with architecure.

    Is this a shared accdb? In other words, do two or more people actually open and use the same accdb file at the same time? (Not a good plan, btw.)

    Or, is this a properly split Access Relational Database Application in which there is a shared "Back End" accdb in a network folder, and does that Back End accdb contain only the tables (and possibly some queries)? Does each user have their own copy of the "Front End" accdb on their own computers? And do those Front End accdbs contain only the forms, reports, VBA and queries needed for the interface?

    Was this answer helpful?

    0 comments