?
Solved

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

Posted on 2009-04-28
25
Medium Priority
?
758 Views
Last Modified: 2013-11-29
I am used to convert my accdb application to accde before sending to client but suddenly after converting the vba code doesn't work on accde application,

please help!
0
Comment
Question by:nuritat
  • 11
  • 6
  • 5
  • +1
24 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 24249539
Is the accde located in a trusted location (remember these are unique to the user).


Kelvin
0
 

Author Comment

by:nuritat
ID: 24249555
I try it on my computer were I always did and still it doesn't work
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 24249574
OK, so probably not that. Did you get any error when creating the accde? Have you done this before without problems?

Kelvin
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

Author Comment

by:nuritat
ID: 24249676
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?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 24249686
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?
0
 

Author Comment

by:nuritat
ID: 24249726
exectly
0
 
LVL 85
ID: 24249752
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
0
 

Author Comment

by:nuritat
ID: 24249775
The accde is opened, the forms are opened but no code behind (vba) is executed, no evet (onopen, onclick...) is executed
0
 
LVL 77

Expert Comment

by:peter57r
ID: 24257940
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?
0
 

Author Comment

by:nuritat
ID: 24267216
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,  
0
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 200 total points
ID: 24267664
Sounds like the Database "container" has corrupted.

Create a new blank database, then from a good copy that works, import all your objects (tables, queries forms......). Make sure you get any hidden and system objects that you have used.

Then try again. I haven't seen it with Access 2007 before, but have found that to be a problem in earlier versions.


Kelvin
0
 

Author Comment

by:nuritat
ID: 24267904
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
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 24267958
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
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 200 total points
ID: 24268308
As Kelvin said, sometimes your container becomes corrupted, and there's nothing that can be done except swap containers, as Kelvin suggested. It's a common and accepted practice, and should be no cause for concern. Frequent backups are, of course, very important, especially if you are doing development work. Also, splitting the database into Backend (tables only) and Frontend (everything else) helps quite a bit, as forms and reports tend to corrupt much more easily than do tables, and with a single file setup you stand a much greater chance of data loss.
0
 

Author Comment

by:nuritat
ID: 24268387
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
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 24268433
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
0
 

Author Comment

by:nuritat
ID: 24268475
I agree

Thanks allot
0
 

Author Comment

by:nuritat
ID: 25681965
thnak you very much
0
 
LVL 85
ID: 25682378
How did you resolve this issue? Did any Expert suggestions assist you in doing this?
0
 

Author Comment

by:nuritat
ID: 25682732
Yes, Master did help me suggesting the database was corrupted, thats what is was
0
 
LVL 85
ID: 25682763
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.
0
 

Accepted Solution

by:
nuritat earned 0 total points
ID: 25683107
Yes, you both helped me, how do I give you the points?
I did click the "Yes" on the "did this comment helped you", should I do anyrhing else?
0
 
LVL 85
ID: 25683679
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:
http://www.experts-exchange.com/help.jsp?hi=407

The Moderators will process this shortly, and will provide you with more insight regarding closing questions.
0
 
LVL 85
ID: 25683684
Author intended to close question differently.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question