fast query

[John L. Viescas]

If you create a referential integrity relationship between the two tables
(which you can only do between tables in a single MDB), Access will
automatically build a "hidden" key for you on the foreign key -- which will
make queries run faster. If you put the tables in two separate mdb files,
you'll get the same performance only if you remember to build an index on
the foreign key in the "child" table. If the indexes are built correctly,
performance may actually be a bit faster in the separate file case if the
two files are on different drives on the server.

HTH...
--
John Viescas
author, "Running Microsoft Access 97"
http://mspress.microsoft.com/mspress/books/bio/64.htm

Yonax <yo...@ibm.net> wrote in article <33F4DE...@ibm.net>...
> Hello
>
> I wold like to know, dose two attach in one .mdb table will work
>
> faster then in two .mdb's?
>

[Yonax]