I am not sure about 7 but in 2000 you can "link" to a server of a different
type like Access. This is from help file:
HTH
The Microsoft® OLE DB Provider for Jet provides an OLE DB interface to
Microsoft Access databases, and allows Microsoft SQL ServerT 2000
distributed queries to query Access databases.
To create a linked server to access an Access database
1.. Execute sp_addlinkedserver to create the linked server, specifying
Microsoft.Jet.OLEDB.4.0 as provider_name, and the full path name of the
Access .mdb database file as data_source. The .mdb database file must reside
on the server. data_source is evaluated on the server, not the client, and
the path must be valid on the server.
For example, to create a linked server named Nwind that operates against
the Access database named Nwind.mdb in the C:\Mydata directory, execute:
sp_addlinkedserver 'Nwind', 'Access 97', 'Microsoft.Jet.OLEDB.4.0',
'c:\mydata\Nwind.mdb'
2.. To access an unsecured Access database, SQL Server logins attempting
to access an Access database should have a login mapping defined to the
username Admin with no password.
This example enables access for the local user Joe to the linked server
named Nwind.
sp_addlinkedsrvlogin 'Nwind', false, 'Joe', 'Admin', NULL
To access a secured Access database, configure the registry (using the
Registry Editor) to use the correct Workgroup Information file used by
Access. Use the Registry Editor to add the full path name of the Workgroup
Information file used by Access to this registry entry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\SystemDB
After the registry entry is configured, use sp_addlinkedsrvlogin to create
login mappings from local logins to Access logins:
sp_addlinkedsrvlogin 'Nwind', false, 'Joe',
'AccessUser', 'AccessPwd'
Access databases do not have catalog and schema names. Therefore, tables in
an Access-based linked server can be referenced in distributed queries using
a four-part name of the form linked_server...table_name.
This example retrieves all rows from the Employees table in the linked
server named Nwind.
SELECT *
FROM Nwind...Employees
----- Original Message -----
From: "Jerry Staple" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, July 29, 2001 1:21 AM
Subject: Cancel: SQL 7.0 linking Tables to Access
> Sorted!
>
> -----Original Message-----
> From: Jerry Staple
> Sent: 29 July 2001 07:57
> To: CF-Talk
> Subject: SQL 7.0 linking Tables to Access
>
>
> Hi
> Can any one inform me of a way to link from a SQL Db to an
> access db table?The access table in future will be transfered to SQL
> 7,but not yet. I know about the import etc but i would like the SQL
> database to be linked to a live Access Table.
>
>
> Any Ideas??????
>
> Jerry Staple
>
> Web Applications Developer
> BizNet Solutions
> 133 - 137 Lisburn Rd
> Belfast
> BT9 7AG
>
> Tel: +44 (0)28 9022 3224
> Fax: +44 (0)28 9022 3223
> www.biznet-solutions.com
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
