Backup difficulty "Opened Exclusively" message

[LJ63034]

Good Morning -

I am self taught on Access and have been working with a database for awhile.
I was able to backup my database last week, but this week I get the
following message "You attempted to open a database that is already opened
exclusively by user 'me' on machine 'XXXX' Try again when the database is
available". I did sign in exclusively last week. When I try signing on
exclusively now - I get a similar message. I have read some of the threads
dealing with this subject, but I don't understand about front end tables etc.
Can someone educate me further?

 

[Administrator]

Good Morning -

I am self taught on Access and have been working with a database for
awhile.
I was able to backup my database last week, but this week I get the
following message "You attempted to open a database that is already
opened
exclusively by user 'me' on machine 'XXXX' Try again when the database
is
available". I did sign in exclusively last week. When I try signing on
exclusively now - I get a similar message. I have read some of the
threads
dealing with this subject, but I don't understand about front end tables
etc.
Can someone educate me further?

 

[Jack Cannon]

1. Check to see if you have a file in the database folder with a filename
such as MyDatabase.ldb . If you find one delete it. If it will not delete,
use the Task Manager to see if the MyDatabase.mdb or MyDatabase.mde is listed
an open. If so select it and click on "End Task".

The ldb file is created whenever an mdb or an mde file is opened. It is
used by Access. It disappears when the mdb or mde file is closed but
sometimes remains in error.

2. FrontEnd and BackEnd are terms that are used to describe the two parts
of a split database. The BackEnd file contains the tables while the FrontEnd
file contains everything else. The BackEnd file is usually placed on a
server while the FrontEnd file is distributed to each user.

The purpose of splitting the database is to allow multiple users to access
the same group of tables. This allows each user access to all tables
regardless of who creates or edits a record within a table. There is also
the advantage of being able to create updates to the FrontEnd table and
distribute it to all users without affecting the data contained in the tables.

Jack Cannon

 

[LJ63034]

That worked! - Thanks so much and for the additional info on Front/Back end.
I have much more reading and learning to do. I appreciate the help.