I had problem in creating linked server between secured access 97 mdb file
and SQL 2000. There is an article on MSDN(OLE DB Provider for Jet) explained
how to setup such a link and it works. But it requires modification to
system registry on SQL Server which affect all Access mdb operations in the
I had both secure and unsecured mdb file need to link to SQL. The solution
above affect all mdb in that box. I need a solution per connection. Any help
is appreciated. Thanks.