Microsoft Access 2007 ACCDE and ACCDB file is split and locked

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.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

danishaniCommented:
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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Thanks for the help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.