Access 2000 ADP: More than one DATABASE?

  • Thread starter Thread starter Jonathan Roberts
  • Start date Start date
J

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
 
You can use CurrentProject.OpenConnection()/CloseConnection() to connect APD
project to different datasource (SQL Server/MSED only, of course).
 
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
 
J. Clay said:
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
Click to expand...

Thank you all for the great tips!

Jonathan
 
Back
Top