Up Convert Access .mdb file to .accdb

I'm trying to convert an old Access 2002 .mdb file to an Access 2010 .accdb file. I already decoded the file using Access 2003.

The file uses a .mdw file for workgroup security and runs by clicking a link file that has the following link text:

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "Y:\General\Check Requests\Database\Check Requests.mdb" /WRKGRP "Y:\General\Check Requests\Database\Secured.mdw"

Microsoft's instructions for up converting are contained on this page: http://office.microsoft.com/en-us/access-help/convert-a-database-to-the-accdb-file-format-HA010341552.aspx

When I try to Save and Publish the file as a .accdb file, I get the following error message:

"Could not use 'Y:\General\Check Requests\Database\Check Requests.mdb'; file already in use."

No one else has the file open, and I have to have the file open to convert it.
PerfishentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
Putting aside your problem for one moment, I take it you know that user level security is not available for accdb files.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Try this:

First, run the procedure below on your existing A2002/3 db, and resolve any issues.
Then:
Create a brand new empty ACCDB, then Import all objects (except any linked tables) from the A2002/2003 (which ever it is) into the new container.  Then run this procedure on the ACCDB and resolve any issues.


Open the VBA Editor and from the menu ...Tools>>References ....
If you see any listed as **Missing: <reference name>, including the asterisks and the word Missing, the
you need to fix that first.

Then, follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

AND ...
Once you get familiar with the Decompile idea (and ALWAYS make a BACKUP first!) ... you can add both Decompile and Compact/Repair to the Right Click menus in Windows Explorer, which I use multiple times daily:

Getting the Decompile and Compact context menu options
http://access.mvps.org/access/modules/mdl0039.htm

mx
0
PerfishentAuthor Commented:
Can the .mdb be converted to .accdb without the user-level security?
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

peter57rCommented:
That is what will happen automatically if you save the mdb as an accdb.
0
peter57rCommented:
I suppose I must say 'should' rather than 'will' based on the inconsistency of Office these days.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
umm ... I don't think you will be able to access the ACCDB w/o the mdw file ...

mx
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
As previously pointed out, the new ACE database engine that uses the .accdb format does not support the old JET workgroup file.  

Unless you absolutely need some of the new features in the ACE (.accdb) format you do not need to convert it.

If you must updates it to a .accdb then here is what I would do:

1) unsecure the mdb so that it is using the default system.mdw,
2) Test the database.
3) remove all code references to Workgroup stuff. You may nee to replace it with your own custom Logon system
4) Test the database.
5) convert it to a .accdb

Steps to unsecure a database:

1)    Log on as a Member of the Admins Group.
2)    Grant full permissions, including Administer permission, to the built-in Users Group for all Objects in the Database.
3)    Put the Admin User back in the Admins Group if he isn't there.
4)    Clear the Password for the Admin User.
5)    Exit Access.
6)    Restart Access, and log on as Admin.
7)    Create a New, blank Database, and import all the secured Database's Objects using the File ==> Get External Data ==> Import command.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PerfishentAuthor Commented:
We need the user-level security on the database, so I'm going to leave it in .mdb format.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
yep ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.