Decompile 1

[cimoli]

A friend called me to look at his Access 2003 database next week. He has a canned program written by a fellow who retired and is unwilling to upgrade the programming to Access 2010. My friend needs to buy new computers and has been told that the old Access program will not run on the windows 8.

I image the file is compiled. If so, is there a way to decompile all the code? So that the qry, forms, etc are simple that can use the basic Access 2010 and no longer protected? He wants to his newer Access to be plain and not with hidden codes etc.

If this is not possible, can we at least have full access to all the tables when moving to Access 2010 ?

 

[lameid]

What you want is the mdb source file for the application... If the guy is retired he may be willing to part with the source if he won't maintain it, assuming you have an mde and not mdb.

That being said the only thing that is really compiled is the VBA code. So unless security was used to protect the design of the objects, it should be easy enough to import everything. Code won't work but as to how much is done by code or not will be the issue to deal with.

If security was used, then things become more difficult. But again this is a similar situation.... if the guy is retired maybe he'll part with the unsecured source or at least give you developer credentials so you can strip them off.

Also it is a well known fact that Access security is not all that strong.... I've never looked into breaking it, but that would be a course of last resort.