Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / March 2005

Tip: Looking for answers? Try searching our database.

Compile with VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bnielsen - 22 Mar 2005 18:23 GMT
I've designed an updating application to deliver object updates to clients
using my databases. The application gets launched it does the following:

Verifies file locations
Verifies version numbers
Backs up client master / back end containers
Pushes modified objects to client master
Modifies tables in backend
Launches action queries if necessary.

The only thing I'm having trouble doing is compiling the modules in the
client master. When you add new modules / forms / etc. it leaves the DB in an
uncompiled state. I've got a routine in the open event of the main form that
checks for the iscompiled flag.

If currentdb.iscompiled = false
      runcommand accmdcompileallmodules
endif

Unfortunately, this is causing problems on some machines....

Does anyone know a way to force a compile on a remote DB and set compile
options for 2K?

Thanks in advance.

bnielsen
Damiaan - 23 Mar 2005 04:05 GMT
Not a real solution.  But can't you use MDE 's instead of mdb's?  These are
always compiled.

Signature

Kind Regards
Damiaan
info @t dampee d0t be

> I've designed an updating application to deliver object updates to clients
> using my databases. The application gets launched it does the following:
[quoted text clipped - 25 lines]
>
> bnielsen
Steven Trencher - 24 Mar 2005 14:58 GMT
The undocumented function (though acknowledge by Microsoft and noted in
technotes on their website) to recompile the current DB is:

Call SysCmd(504, 16483)

Then you must run Application.IsCompiled to see if it was successful.

Since this is only for the current DB, perhaps there is a way to open the
remote DB and call a function there that recompiles its VBA code. Also, I
believe there is another SysCmd function that creates an MDE if desired.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.