Access linked server with a specific workgroup

Access linked server with a specific workgroup

Post by Pascal Michael Hadda » Wed, 10 Jul 2002 14:52:34



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

 
 
 

Access linked server with a specific workgroup

Post by Sue Hoegemeie » Thu, 11 Jul 2002 00:13:43


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


 
 
 

1. Linked Server - Access 97 Workgroup Access

I have some access databases set up as Linked Servers.  One of the databases
is secured, using a MS Access Workgroup account.
Problem is that we can't seem to run any queries on the linked
server/database.  Books Online instructed us to insert a
HKEY_LOCAL_MACHINE\software\microsoft\jet\4\SystemDB registry setting
pointing to the Access Workgroup .mdw file we use to access the database.
Still no reults.

Also, specifying the workgroup usernames and passwords in the security
properties dialog gets us nowhere.

What am I missing or doing wrong?

2. Retrieving Field descriptions from Access table using ADO

3. Linked Server Microsoft.Jet.OLEDB.4.0 to Access MDB with Workgroup/Security

4. Exists Tupel Queries ?

5. send specific oracle 8i table data to specific sql server 2000 table at specific times

6. Insert info to .txt document?

7. Link problems installing workgroup server on SCO

8. Where is master DB

9. ip specific server link

10. Provider Specific Properties on Linked Servers

11. linked server, DTC, SQLOLEDB, Access, linked tables = HEADACHE!

12. Accessing SQL Server from Workgroup ?

13. Problem Replicating SQL Server 2000 Database With Access 2000 Database With Workgroup