Solved

Microsoft Access 2007 ACCDE and ACCDB file is split and locked

Posted on 2012-03-25
3
2,206 Views
Last Modified: 2012-04-07
mlmcc and I are working on a database we split and we have changes on a clients machine that has the most recent updates on it. From what we have read we have not seen any evidence that we can unlock this file to add to the code in the ACCDE. Are we stuck in this or is there some way we can access the most up to date version on the clients machine and make it our working copy so that we can continue to update it. Your thoughts are appreciated. thank you very much.
0
Comment
Question by:ruavol2
3 Comments
 
LVL 12

Assisted Solution

by:danishani
danishani earned 250 total points
ID: 37764155
If your database contains VBA code, saving your application as an .accde file compiles all modules, removes all editable source code, and compacts the database. Your code continues to run, but it cannot be viewed or edited. Saving your database as an .mde file also protects the intellectual property contained in your source code. Your database continues to function as it did—you can still update data and run reports.

So basicly you have to have a Developer version (ACCDB) at hand to continue developing. When you are ready to deploy a new version, you compile your VBA code again and create a new ACCDE file and distribute this amongst your users.

For handy tools on deploying FE amongst your users, check below thread on Deploying:
http://hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=65&Itemid=30
 
Hope this helps,
Daniel
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 37765766
<<From what we have read we have not seen any evidence that we can unlock this file to add to the code in the ACCDE.>>

 That is more or less correct.  Nothing you can do on your own really, but there is one company offering DE to DB service.   It's a last resort though.

Look for old backups of the ACCDB and search the server(s) first.

Company BTW is:   http://www.everythingaccess.com/mdeconversion.htm

Jim.
0
 

Author Closing Comment

by:ruavol2
ID: 37819106
Thanks for the help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

867 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now