Unable to create .accde

[JohnPapa]

I have a .accdb which is 92Mb and lately it is difficult to create a .accde. It is telling me that the .accdb is still in use.

Does this have to do with the TableIDs that are created during the .accde creation process?

Any ideas?

 

[JohnPapa]

I have a .accdb which is 92Mb and lately it is difficult to create a .accde. It is telling me that the .accdb is still in use.

Does this have to do with the TableIDs that are created during the .accde creation process?

Any ideas?

I forgot to mention that I am using A2013

 

[arnelgp]

goto vba and Compile your code.
you need to resolved any errors encounter before you can create an .accde

 

[JohnPapa]

goto vba and Compile your code.
you need to resolved any errors encounter before you can create an .accde

I have compiled the code ... 1000 times

 

[arnelgp]

I have compiled the code ... 1000 times

Then, open the db Exclusively and try to convert it.

 

[AHeyne]

'Decompile/Compact' the accdb first can help too.

 

[JohnPapa]

Then, open the db Exclusively and try to convert it.

It is telling me that it cannot open the .accdb for exclusive use because another user has the database open or because I do not have permission to open exclusively.

 

[arnelgp]

on the Task Manager(Ctrl-Shft-ESC key), kill all instance of MS Access.
is the db on the root (C:\) folder?
try moving it to your Documents folder and try to Open it in Access Exclusively again.
if you succeed without error, you can then convert it to an .accde

 

[JohnPapa]

on the Task Manager(Ctrl-Shft-ESC key), kill all instance of MS Access.
is the db on the root (C:\) folder?
try moving it to your Documents folder and try to Open it in Access Exclusively again.
if you succeed without error, you can then convert it to an .accde

DB FE is linked to DB BE. Both are in a folder under the root folder.

Still it will not let me open exclusively

 

[arnelgp]

it might be that you have "limited" write access to the root folder, so my suggestion is to move/copty your db (FE) in your Document folder (where you have all Rights) and make .accde on that folder.

 

[JohnPapa]

DB FE is linked to DB BE. Both are in a folder under the root folder.

Still it will not let me open exclusively

I created a simple one table DB and I can open it exclusively and create the .accde

 

[Gasman]

Are you using it via Excel at all, or some other app?

how to find out what program is using a file windows 10 - Google Search

Find out which process is locking a file or folder in Windows

How can I find out which process is locking a file or folder in Windows? For instance, when trying to delete a folder, Windows reports this: The action can't be completed because the folder is ...

superuser.com

 

[JohnPapa]

Are you using it via Excel at all, or some other app?

how to find out what program is using a file windows 10 - Google Search

Find out which process is locking a file or folder in Windows

How can I find out which process is locking a file or folder in Windows? For instance, when trying to delete a folder, Windows reports this: The action can't be completed because the folder is ...

superuser.com

Only Access. FE and BE

 

[Minty]

Can you import the db into a fresh new database, then try.
Rebooting will/should release any lock. Is there a lock file showing?

 

[arnelgp]

or you can try zipping the fe and someone will convert it for you.

 

[CJ_London]

@JohnPapa - I don't see this having been suggested or tried - have you tried rebooting your computer? If not, suggest you do

 

[JohnPapa]

Can you import the db into a fresh new database, then try.
Rebooting will/should release any lock. Is there a lock file showing?

Rebooted several times. No lock file.

 

[JohnPapa]

or you can try zipping the fe and someone will convert it for you.

What would zipping achieve?

 

[Gasman]

What would zipping achieve?

It makes it smaller for the upload.

 

[LarryE]

I have a .accdb which is 92Mb and lately it is difficult to create a .accde. It is telling me that the .accdb is still in use.

Does this have to do with the TableIDs that are created during the .accde creation process?

Any ideas?

It is my understanding that when you create a .accde, ACCESS copies the original .accdb file and converts the copy to .accde. Therefore, if you attempt to open the new .accde file without first closing the original .accdb file, you will get that message. Is that what happened?