converting accdb (access 2007 application) to accde block the vba code

Is the accde located in a trusted location (remember these are unique to the user).


Kelvin

I try it on my computer were I always did and still it doesn't work

OK, so probably not that. Did you get any error when creating the accde? Have you done this before without problems?

Kelvin

I didn't have any error
and I do it almost everyday successfuly,
another application on another dolder works fine,
I tried to import the appication to another new accdb but still, un  the accde the vba doesn't work

ehat can it be?

Sounds a bit odd.

Can I confirm that you are definitely saying that if you put the accdb and the accde in the same folder on your machine, then the accdb file works ok but the accde doesn't?

exectly

can you define what you mean by "doesn't work"?

does the accde actually open?

If it does, can you then open any forms?

If you can open forms, can you navigate records?

etc etc

The accde is opened, the forms are opened but no code behind (vba) is executed, no evet (onopen, onclick...) is executed

If you put the accde in an folder which is NOT trusted, do you get a dialog asking whether you want to allow the code to run, when you start the application by double clicking the file?

If so, and you say yes, does it work correctly?

putting the accde in another folder didn't help.
My conclusion was that the file was corrupted and I restarted from the backup, it's the second time that this file is being corruped with no clear reson, have any idea why?
can it be it's size? 15,196kb..

thanks,  

Thats what I already did, I hoped to be able to resolve the problem in the current copy but...
I see that many backups is a good solusion for many problems...

Thanks

CHances are that a form, report, code module corrupted, but finding which one can be a mission.If the code has corrupted, then it is backup time.


Kelvin

Splitting the database is also something I always do for many resons including the one you said. If I could only know what was the corrupted part I could restore only it.
but I understand its not possible

Most likely, but not necessarily the case, it will be an object that you recently worked on.

Biggest problem is that after Access 97, all code is stored in one great big "blob", rather than with each individual object. If that goes... it's all gone (unless MS changed that with Access 2007).

You could try deleting and reimporting any suspicious objects, but in the long run I suspect you'll be faster recreating.

Kelvin

I agree

Thanks allot

thnak you very much

How did you resolve this issue? Did any Expert suggestions assist you in doing this?

Yes, Master did help me suggesting the database was corrupted, thats what is was

My point is that if one or more of the Experts assisted you in resolving this, then you should award some or all of the points to those experts. If no one from EE assisted you, then you would of course just close this question. Also, your followup question "any idea why it corrupted" was also answered by both myself and Kelvin.

No, that just marks a comment as "helpful". There are many ways to close a question; in this case, since you've already started the close process someone will have to Object to the closure, which will stop that proces. I'll do so, which will give you an opportunity to correctly close the question.

Here's a link that may help:
https://www.experts-exchange.com/help.jsp?hi=407

The Moderators will process this shortly, and will provide you with more insight regarding closing questions.

Author intended to close question differently.