How to access another database in my application

[prasad joshi]

i want to access values of another database in my vba application

how to use it

can anybody give me sample code....

[twinnyfo]

The easiest way is to link the tables of the other database with your current database.

[zmbd]

Prasad:
Twinny for is correct. You will need to link to the tables witin the other database in as much as you would to any backend database. You use the linked tables in the same way you any such set of datatables.


-z

[ariful alam]

@joshi,

create linked table to other database file to access the tables of that database file.

[TheSmileyCoder]

Linked tables are a fine solution if your always connecting to the same database. However there might be cases where you need to access information from a file selected by the user. In such cases you can either use OpenDatabase from your VBA environment, and then open recordsets from that database.

If you simply need to lookup data or even edit data, you can also open a recordset directly against another database from within the query syntax.

SELECT * FROM tbl_Example in 'C:\TestFolder\TestDatabase.mdb'

I believe that is the correct syntax but otherwise it should be a simple matter to look it up.