Call function in a different .mdb file on same folder

I

Imran J Khan

Can I keep my functions in a .mdb file (library.mdb) and call them from
different Access databases/.mdb files on the same folder as the library.mdb.
I hope to simplfy maintainance this way.
Imran
 
M

Marshall Barton

Imran said:
Can I keep my functions in a .mdb file (library.mdb) and call them from
different Access databases/.mdb files on the same folder as the library.mdb.
I hope to simplfy maintainance this way.
Click to expand...


Yes. Make sure the library mdb compiles cleanly and copy it
to the desired folder. Then you can use the VBA Tools -
References menu item to add it to your project.
 
I

Imran J Khan

Thank you Marshall, that solved the problem (also restarting both .mdb files
helped).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pointing to a pointer to an .mdb 1
WHat is the sintax to make a call to an external mdb file. 1
Call a report in another .mdb-file from a .mde-file 4
close mdb database from calling mdb 4
Zipping a mdb-file 2
Having trouble formulating TransferDatabase command in VBA. 4
What's the best way to open another mdb file using VBA? 5
Vista - XP Compatibility for Access 2003 MDB / MDE 3

Top