Unable to make ACCDE
Can anybody help me to resolved this issue..
I am using Access 2007.
file type .accdb
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I checked the trust. I compiled, compacted and repaired.
Any other ideas on what happened and how to fix?
I went to another folder where I have sample databases applications, made a accde out of them and they worked fine
I may do another 50 revisions this month, isn't there a way of updating the accde file back to the original whenever I make a change?
So I need to add code (if possible) to create a 32-bit ACCDE from a 64-bit system.
Here is the code that creates the 64-bit ACCDE:
Set AccessApplication = New Access.Application
.AutomationSecurity = 1 'MsoAutomationSecurityLow
.UserControl = True
.SysCmd 603, sourcedb, targetdb 'this makes the ACCDE file
Is there a way to change this code to create a 32-bit ACCDE as well as the 64-bit one?
Yesterday, I made a ACCDE and works well.
Today, I made a ACCDE from access application and does not appears a ODBC connect box.
Why ACCDE does not linke to ODBC? are there something I make changes?
The 1st database was imported from a AC2003 db. The accde size is around 30mb and once I publish as accde it is around 27mb. Both DB are split to FE/BE.
The 2nd database was created from AC2010. The accde size is 29mb and once I publish to accde it is around 9mb(!)
The thing is the 2nd DB has more reports, forms and queries and yet once I publish it to accde the size is much smaller compared to the 1st.
I am stumped at this and there doesn't seem to be a way to check component filesizes. Can anyone explain why? I do have 2 image files I use as form background in db1 but they are shared an only around 150kb in size each. even with their original size (2MB) I still shouldnt get such a big file after publishing as accde
Am I missing something or could there be another reason?
However, when I create the ACCDE I hit a problem. On opening the ACCDE file, I click the button to open the form and all works well. However, I can press F4 and it shows the Property Sheet where I can change values to allow editing.
Is there any way to disable the property sheet in the ACCDE file
Can someone provide a code to do it?