Report datasource

[Guest]

I split my database into two part one for application and one for database.
How I can make my reports to be based on a table from another database. I
tried to use recordset however it is giving me error "this feature is not
available in mdb" I am using ms access 2003 however my application is saying
(access 2000 file format).

I don't want to use link table

Thanks
Tanwerr

 

[fredg]

I split my database into two part one for application and one for database.
How I can make my reports to be based on a table from another database. I
tried to use recordset however it is giving me error "this feature is not
available in mdb" I am using ms access 2003 however my application is saying
(access 2000 file format).

I don't want to use link table

Thanks
Tanwerr

By default, Access 2003 does not set up a reference to the DAO library
(it defaults to ADO).
Add the reference to the Microsoft DAO 3.x library and then use
DIM db as DAO.Database
DIM rs as DAO.Recordset
etc.

Alternatively, use the TransferDatabase method to import the data into
a Temp table and use that table as recordsource for the report.