Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, From a mdb-file, is it po 1

Status
Not open for further replies.

tsetse

Programmer
Sep 7, 2001
10
BE

Hi,

From a mdb-file, is it possible the run a function of other MDB ?

thanks for all responses
jeff
 

If your function is in DB_1.mdb and you want to call it from DB_2.mdb, open any code module in DB_2. Select Tools | References from the menu. Add a reference to DB_1.mdb. You'll need to browse to DB_1 in order to add it.

See the on-line help for "library databases". Help cautions that the DB_1 should contain only code so use this method cautiously if DB_1 contains data, reports, forms, etc. I've added a reference to an MDB that contains many objects in addition to the code modules and thus far haven't encountered any problems. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Terry,

The "caution" is a reminder that the REFERENCE only gives you access to the MODULES, and does not open the forms / reports / tables to the referencing user.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over
 

Thanks Michael. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top