Whew, sounds like you stepped in a pile of SQL Server. Let me try and help
you out here.
Why would you want to access the old database after all of the data is in
SQL Server? All of the tables that were in the Access db will be in the SQL
db...
As for the second question, when you say link. Do you mean the ability to
synchronize to remote databases or do you just want to perform queries
against both databases from a cold fusion template?
jon
----- Original Message -----
From: "Steven Dworman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 9:32 AM
Subject: SQL server question
> I'm not sure if this is the right list to post for this question, but here
it
> goes.
>
> We have a database that we're converting from Access to SQL server 7, and
> since I'm new to this there are 2 issues as of now.
>
> 1. Can you set up a link (or alias I guess) that would link the old table
> name from Access to the new one in SQL server? How do you do it?
>
> 2. How do you link a database on one machine with a database on another
> machine (both are SQL server databases)?
>
> Any help is appreciated.
>
>
> Steve
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
