Yes, it's possible and fairly painless.
- Go to your Data Sources (ODBC) Control Panel
- Make a new System DSN
- Select the driver for MS SQL Server
- Follow the wizard's instructions. You'll have to click "Client
Configuration" and tell it to use TCP/IP (or whatever protocol you use).
- In Access, make a new database.
- File -> Get External Data -> Link tables
- Change the "Files of Type" to be ODBC Datasources()
- Choose your DSN under "Machine Datasources"
- Access will walk you through which tables you need
You can view and work with data through Access, but you normally can't
change the structure of the tables (i.e. Design Mode).
Reply to the forum if something doesn't work!
Norman Elton
Information Technology
College of William & Mary
-----Original Message-----
From: avex [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 24, 2000 9:59 PM
To: CF-Talk
Subject: access front-end for SQL
Hi guys...
I think it has been briefly mentioned......
but does anyone know how to use access 2000 as a front-end for an SQL
database?
any info would be great...
thanks
chad
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
