Solved

Microsoft Access 2007 ACCDE and ACCDB file is split and locked

Posted on 2012-03-25
3
2,269 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

828 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