How to create queries using EXTERNAL ACCDB file?

[IgorOV]

I tested everything and it is working great


Main ACCDB (MADE: ACCDE)
- Forms
---- Using VBA code to access the DB file with the DATA TABLES

- Reports
---- Using VBA code in the ON OPEN event to run a query and fill the empty tables with data from DB file
---- Using VBA code in the ON CLOSE event to empty the local tables

- Empty Copy of Tables and one table which has the DB location, for example: //server/db/db.accdb

DB Accdb file (Password protected)
- TABLES with all the data and also username / password


"ItsMe", you said something about creating executable file for my main file... you mean using another language, like VB Studio?

Regards,

[ItsMe]

......"ItsMe", you said something about creating executable file for my main file... you mean using another language, like VB Studio?

When I mentioned executible, I was refering to an accde extension. I am not sure what, exactly, you are trying to accomplish or what you have tried so far.

For me, creating an executible would be the final stage of securing the DB before distribution. This prevents individuals from accessing the VBA modules and from opening Reports or Forms in design or layout view. I don't know of any advantage to having a BE file as an accde extension.

My approach to this may be different from yours. When I begin building an application, I am working towards developing an app that will function in a runtime environment. I use the techniques I described earlier. I create special menus and hide control interfaces. I hide things like the nav pane in cases the User has a full version of Access installed. After everything is tested in the RT environment, it is safe to compile your FE as an accde or ade for project files.

You can store master copies of the FE that are still in accdb file format in a secure location on the server. I would do the same thing for the BE files. Store these files using Windows AD, if available.