MsAcess Query

[bhagya79]

Hello,

Can I have 2 Databases(i.e. 2 .mdb files) open at a time? and can I access 2 tables one from each, in a single query?

how many records a table can have?


please guide.
Regards,
Bhagya

[hellomadhu]

yes, u can have 2 db's open at a time. but u cant open 2 tables one from each in a single query.

and there is no limitation for no of records in a table.

[chanti]

Hi,

We can do that in SQL Server., but I am not sure if it can be done in MS-Access.

Cheers.

[nmarun]

Dear Gurus,

can any one give me an example of how such a sql statement would look?

I guess it would look like:
select * from db1.table1, db2.table2 where ...
is this right??

what would be the difference in MS Access and SQL Server query structures??

tia
Arun

[hellomadhu]

u should make a small change in your query

db1..table1 and db2..table2

i.e put two dots after db name

[nmarun]

thank you madhu

[nmarun]

Hi hellomadhu..

I'm not able to get the query you've given to work. I've attached the zip file which contains 2 access db files. Both have 1 table and db1 has the query. Kindly check it and see what's wrong.

[hellomadhu]

sorry ya, u can do that only in sql server.

chanti had earler said that in his msg, so i thougt u have taken that into consideration.