Well I have been able to connect and load up tables, but how do you run queries?
Paul > 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 sq l > 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 some one > > 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 > > > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
