Report datasource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tanweer - 30 Nov 2005 16:39 GMT

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

Reply to this Message

fredg - 30 Nov 2005 18:25 GMT

> 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
[quoted text clipped - 6 lines]
> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message