RE: [CF-Database] MS Access ODBC SQL 2000

["Mike Connolly" <mike.connolly@onenortheast.co.uk>]

Paul 

Try creating link tables in MS Access to the ODBC pointing SQL 2000.

* Open an MS Access database.
* Right-click on Tables list and select 'Link Tables'
* Select 'ODBC Databases' from the Files of Type.
* Select your relevant ODBC for the SQL 2000.
* Select table(s) you want to link.

Hope this helps

Regards

Mike


-----Original Message-----
From: Paul Swingewood [mailto:paul_swingewood@hotmail.com]
Sent: 13 October 2004 09:38
To: database@list.cfdeveloper.co.uk
Subject: [CF-Database] MS Access ODBC SQL 2000


>- see footer for list info
Hi,

I have to connect a MS Access frontend to an SQL 2000 database.
Having never done this before I am somewhat lost.

Can anyone point me in the right direction as to how I create the ODBC 
connection.

Regards - Paul


_______________________________________________
For info on all lists and to join/leave go to http://list.cfdeveloper.co.uk/mailman/listinfo
--

CFDeveloper is hosted by CFMXhosting.co.uk and managed/supported by Russ Michaels
Thanks also to the following for their support:- * www.fusetalk.com *  www.gradwell.com * www.proworkflow.com * www.helmguru.com * www.APYCOM.com * 
_______________________________________________

These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/




_______________________________________________________________________
Confidentiality:  This e-mail and its attachments are intended for the above named only and may be confidential.  If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error.

Security Warning:  Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium.  We advise that you understand and observe this lack of security when e-mailing us.

Viruses:  Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
________________________________________________________________________