Yeah it's actually pretty cool. You need MDAC 2.6 and sp1 I believe for Access 2000 to connect to a SQL Server. Access 2002 is ready to go out of the box. Just create a new project and type in the name or ip of the sql server, and login.
jon ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 1:52 PM Subject: MS SQL Server / Managing in Access > I have heard that MS Access 2000 has the ability to act as the Enterprise > manager within MS SQL Server .. (or at least something close). > > I have tried to find information in the help, but can't .. could someone > explain how to go about accessing my SQL Server remotely through MS Access > > I need to run queries and copy and create tables. > > Thanks > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector - Commerce Builder > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
