Access 2000 ADP: More than one DATABASE?

[Jonathan Roberts]

Hello!

Is it possible to access more than Database (same server) from a
single ADP? We have an Access database using linked tables right now.
I would like to enhance its speed by converting it to an ADP.

Thank you!

Jonathan

 

[Norman Yuan]

You can use CurrentProject.OpenConnection()/CloseConnection() to connect APD
project to different datasource (SQL Server/MSED only, of course).

 

[Sylvain Lafontaine]

Much of the slow speed of linked tables comes from the performing of Join
over the network; so you can greatly enhance the speed of recordset based on
Join statement by using views.

Don't forget to take a look at http://support.microsoft.com/?kbid=209123 .

S. L.

 

[J. Clay]

This is fairly easy. Set up a view to the other database and use the view
as if you were a table. In our case, we have an in house Access ADP that is
integrated with Goldmine. I have a view set up to each Goldmine table. The
select statement is something like:

SELECT * FROM OtherDataBase.dbo.TableName

HTH,
Jim

 

[Jonathan Roberts]

This is fairly easy. Set up a view to the other database and use the view
as if you were a table. In our case, we have an in house Access ADP that is
integrated with Goldmine. I have a view set up to each Goldmine table. The
select statement is something like:

SELECT * FROM OtherDataBase.dbo.TableName

HTH,
Jim

Thank you all for the great tips!

Jonathan