Unable to create .accde (1 Viewer)

JohnPapa

Registered User.
Local time
Today, 04:23
Joined
Aug 15, 2010
Messages
1,036
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 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
 
goto vba and Compile your code.
you need to resolved any errors encounter before you can create an .accde
 
'Decompile/Compact' the accdb first can help too.
 
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.
 
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
 
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
 
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.
 
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
 
Last edited:
Can you import the db into a fresh new database, then try.
Rebooting will/should release any lock. Is there a lock file showing?
 
or you can try zipping the fe and someone will convert it for you.
 
@JohnPapa - I don't see this having been suggested or tried - have you tried rebooting your computer? If not, suggest you do
 
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.
 
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?
 

Users who are viewing this thread

Back
Top Bottom