SQL,Access database integration

[joelm]

Hello,

I have a client running multiple access databases as well as a couple
SQL databases on SQL 2000.

Their goal is to be more efficient by reducing redundant data entry and
increase the ease at which they can retrieve all information about a
specific entry which may be present in 2 or more of these databases.
And if possible link to MS Exchange for email history.
What solution(s) would you suggest to such client?

[Tom van Stiphout]

On 12 Jan 2005 11:27:42 -0800, jo***@bmpsales. com wrote:

Heterogenous joins (where Access data and SQL data is joined) are
typically very slow. It works, and you should be happy for that, but
it's not efficient.
SQL is a better storage place for data. Less chance of corruption.
Potentially more secure and more speed.
Referential integrity can only be preserved efficiently if all data is
in the same data store.

I would suggest to start with a good data analysis. Most likely I
would end up with a single DB in SQL Server. Then adjust the
applications to the new data store. Perhaps I would use MDBs with
linked SQL tables to get them going quickly, but I would keep a
rewrite using ADP as an option.

-Tom.

Hello,

I have a client running multiple access databases as well as a couple
SQL databases on SQL 2000.

Their goal is to be more efficient by reducing redundant data entry and
increase the ease at which they can retrieve all information about a
specific entry which may be present in 2 or more of these databases.
And if possible link to MS Exchange for email history.
What solution(s) would you suggest to such client?