You can find the information on configuring the workgroup
file and linked server at:
HOWTO: Use a SQL Server 7.0 Distributed Query with a Linked
Server to Secured Access Databases (Q246255)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246255
SQL Server 2000 has the information in books online under
linked servers, access an access database
-Sue
On Tue, 9 Jul 2002 08:52:34 +0300, "Pascal Michael Haddad"
>Dear All
>I want to link to an access database c:\database.mdb using a specific
>workgroup c:\system.mdw and a specific access user pascal with a password
>passo.
>can anybody give me the command that I should use or how to add the linked
>server through the linked servers in the entreprise manager?
>thx
>PAscal