File already open dbase

How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. In reply to dhookom's post on September 25, First of all access can be saved as mdb or accdb. This is not the issue. Save procedure 3. Run procedure, messages appears "done" 4. Scottgem MVP. So you closed then re-opened the same database? Its possible, the lock file hadn't closed yet causing Access to believe the file was still in use. In reply to Scottgem's post on September 25, Thank you for that.

How do i ensure the lock file is closed. Where is the lock file. Or is there vba code to close the lock file. When you have a database open with exclusive access, anyone else who tries to open the database receives a "file already in use" message. Click the arrow next to the Open button and then click Open Exclusive Read-Only to open the database for read-only access.

Other users can still open the database, but they are limited to read-only mode. In the list of drives, right-click the drive that you think might contain the database, and click Search.

Since the search was initiated from the Open dialog box, you must click Cancel in that dialog box before the database will open. Access automatically creates a new Access database in the same folder as the data file and adds links to each table in the external database. To open one of the last several databases you had open, click the file name in the Recent list on the getting started page. Access opens the database with the same option settings it had the last time you opened it.

If the list of recently used files is not displayed:. Under Display , type a number in the Show this number of Recent Databases box. In a single instance of Access, you can have only one database open at a time. In other words, you cannot start Access, open one database, and then open another database without closing the first database. However, you can run multiple instances of Access at the same time, each with a database open in it.

Each time you start Access, you open a new instance of it. For example, to have two Access databases open at the same time, start Access and open the first Access database, and then start a new instance of Access and open the second database. Note: The number of instances of Access that you can run at the same time is limited by how much memory is available. Available memory depends on how much RAM your computer has and how much memory is being used by the other programs running at the time.

Each instance of Access runs in a separate window. If you have more than one instance of Access running and you want to view them simultaneously, you can tile the windows. You can create a desktop shortcut to open an Access database object for example, a form or report.

The database may be stored locally on your computer, remotely on a network file server, or in a shared directory. Resize the Access window and minimize any other open windows so that you can see the desktop behind the Access window.

Drag the object from the Navigation Pane to the desktop. Click Here to join Tek-Tips and talk with other members! Already a Member? Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free!

Already a member? Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail.

Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. I have a corrupt mdx file that refuses to get reindexed. I deleted it, created a new one, and I still get the same error whenever I try to reindex or pack: "File already open.

A few questions first: If on a network or accessing remotely, do you have the file permissions to both read and write? Will it reindex locally but not on the server? Sounds silly to ask, but in some other programming languages that message has been a rights issue.