• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1038
  • Last Modified:

Created .aacde file is not working while .accdb is perfectly working

I have created .accde file in access 2007, but the file is not working while the access application (accdb) is perfectly. I set the trusted location, complied the VBA code and then created the .accde file. But still it is not working. Any Solution??
0
vikasbapat
Asked:
vikasbapat
  • 6
  • 3
  • 3
  • +2
1 Solution
 
mlmccCommented:
What isn't working?

Does it open the first screen or just doesn't work from the start?

mlmcc
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Is this on the same machine? That is, are you trying to run the .accde on the same machine as you're running the .accdb?

If not, then  you may very well have a reference issue.
0
 
mlmccCommented:
Is the data included in the accde file?

mlmcc
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
vikasbapatAuthor Commented:
I have been running .accde file on the same machine.
It opens the first screen...that is login screen..but on click of login button after given login information, it does not work.
Added access zone means????
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you included error handling in your accde file? This is critical to the proper operation of your app:

http://msdn.microsoft.com/en-us/library/aa172288%28v=office.11%29.aspx

This is for 2003, but the same techniques apply to newer (and older) versions as well.

MZ Tools is a free VBA addin that can help you to add error handling to your code:

www.mztools.com

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<It opens the first screen...that is login screen..but on click of login button after given login information, it does not work.>>

  When you create the accde, did you ensure that the code compiled cleanly first?  If not, go back and do that.  If it still fails, then I would:

1. Create a new DB.
2. Import eventhing into it from the original DB.
3. Compile and save
4. Create a new .accde and test again.

  If that still fails, then it's most likely something in the coding of the app itself as LSM suggested (ie. no error handling).

JimD.
0
 
vikasbapatAuthor Commented:
I added error handling to my code and complied it. But when i click to create accde, it is not allowing me to create .accde file instead throwing an error.

Error description is:-
 "This error is usually associated with compiling a large database into an MDE file.  Because of the method used to compile the database, a considerable number of TableID references are created for each table.  The Access database engine can only create a maximum of 2048 open TableIDs at one time.  Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.  However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."

My application have 5 form, 4 reports, it is a small application.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

 Create a new DB container and import everything into it.  Then make sure it compiles without errors.

 After that, try the MDE conversion again.

JimD.
0
 
vikasbapatAuthor Commented:
Thanks a lot....
I created the new DB imported everything into that...complied the application and then created the exe....It is perfectly running.
I have a question in my mind..... why the accde created from the original one in not working, while the new one(imported everything from the original one with no changes made) is perfectly working??? Any specific reason, just for my knowledge.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<I created the new DB imported everything into that...complied the application and then created the exe....It is perfectly running.
I have a question in my mind..... why the accde created from the original one in not working, while the new one(imported everything from the original one with no changes made) is perfectly working??? Any specific reason, just for my knowledge. >>

  The VBA project, which Access uses and is stored in the DB as a BLOB, carries the code in two basic forms; source and "compiled" p-code or pseudo code.

  Every once in a while, the two will get out of synch because of bugs or DB corruption.  One the app is "compiled", VBA won't refresh the stored p-code.  You have two choices at that point:

1. Use /decompile, which I coved in an article:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_2043-Decompile-What-it-is-what-it-does-and-how-to-use-it.html

2. Or importing into a fresh DB, which copies only the source, so it leaves all the p-code behind.

  I prefer #2 myself, because the action of reading/writing all the objects gives you an additional sanity check over just using /decompile.  Although with that said, many use it and in many cases it does the trick.

JimD.
0
 
vikasbapatAuthor Commented:
best solutions
0
 
vikasbapatAuthor Commented:
this comment was really helpful
0
 
vikasbapatAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for vikasbapat's comment http:/Q_26986708.html#35872390

for the following reason:

good solutions
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You wrote "good solutions", yet you have not awarded points to any of the Expert comments. Did you intend on doing so? It seems that Jim Dettman's comment here: http:#a35504709 should have been accepted.
0
 
_alias99Commented:
All,
 
Following an 'Objection' by LSMConsulting (at http://www.experts-exchange.com/Q_27070041.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
 
At this point I am going to re-start the auto-close procedure.
 
Thank you,
 
_alias99
Community Support Moderator
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now