RE: FN-FORUM working with 2 databases in Access

date posted 1st October 2001 14:13

> I am trying to work with two databases in MS Access
> 2000 - actually i have to pass data from one database
> to other ...any suggestions

Hi Kashif,

It really depends on what your requirements are but
Access does allow you to pass parameters from one database
to a function in another database.

How? Have the function as a Public Function and attach it
as a reference to the first database. Call the function
from the first database using .

Ie dbFunctions.CalcValues

dbFunctions. will give a list of all public variables,
Functions and subroutines plus allow you to open forms/
reports saved in the referenced database.

HTH

Regards

NJ Smith AMIAP
Associate Member of the Institute of Analysts and Programmers

http://www.iap.org.uk
http://redtop.freelancers.net