Question Making ACCDE file from ACCDB file

[teja]

Hi all,

I have query regarding the "make accde" functionality in the Access 2007 database.

My Db size is 100MB. I want to hide the VBA code from the users by converting my accdb file to accde file. But when I use the Database Tools-> Make ACCDE option, I am getting the following error.

When I imported only one main form in the current DB to a new Db, i am still getting the above error. But when I import all the tables and queries and perform the conversion, it is successful.

Can anyone help me to know whether it is possible to convert the DB into accde with forms?

Thanks in adavnce.

 

[Mr. B]

Can anyone help me to know whether it is possible to convert the DB into accde with forms?

The simple answer is: "Yes". There should be no problem with creating an accde file just because the application as forms. Forms are "THE" way to have users interface with any database.

I would suggest that you try two things before you try to create the .accde file:

First, if you have VBA code in your application, go to the VBA window and compile your code. (Debug/compile from the menu). Resolve any issues encountered during the compile.

Next, do a compact and repair on your database to try to reduce it's size as much as possible.

 

[teja]

First, if you have VBA code in your application, go to the VBA window and compile your code. (Debug/compile from the menu). Resolve any issues encountered during the compile.

Next, do a compact and repair on your database to try to reduce it's size as much as possible.

I will let u know once i have compiled

 

[SKJ]

I will let u know once i have compiled

Any luck? I am getting similar error and can not resolve it.

-SJ

 

[teja]

No ... I did not get any result out of that method... we had SQL server as back end and we made the sql authorization method to hide our code.

 

[speakers_86]

I would try making a new shell. Open a new blank database and import all of your objects. Then, decompile, then compile, then make accde.

 

[SKJ]

Let me try that. I have alot of forms and reports. I hope it will be a smooth process.

 

[SKJ]

No ... I did not get any result out of that method... we had SQL server as back end and we made the sql authorization method to hide our code.

So instead of creating a new database I compiled my VBA code by fixing errors as Mr. B mentioned. Then compacted application and converted that into .accde format. It worked

 

[stergio33]

Dear Mr. B, thank you for the advice. I had the same message. I tried to compile as u suggested and I found many bugs cowling around. I start to fix them. I hope it will be ok

 

[Pat Hartman]

teja - we had SQL server as back end and we made the sql authorization method to hide our code

That doesn't make any sense. Are you talking about A2013?