>Access and SQL Server are two separate different products. Yes and no... Separate products, but one can interface with the other. I use access as an interface to our SQL server ALL the time... If you have it configured correctly it works quite nicely. It certainly loads a lot faster than enterprise manager.
Create a new project (existing database), save it.. that will bring about the connection dialog box. In server name, enter the ip address of your SQL server. Enter all the login and password information, and then find the database, hit OK, and you're done. Works very similar to working with an actual Access database, however the design view is different - it is SQL Server-ish (different datatypes, etc.) -Bill brainbox ----- Original Message ----- From: "Fregas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 2:30 PM Subject: Re: SQL server > Laurent, > > I'm not sure if I fully understood your question. It sounds like you are > tyring to get into SQL Server through Access or at least conscturct a SQL > Server database. To really do anything with SQL Server, you must install > the SQL Server 2000 software on your machine or the server you are working > on. I know access will let you "upgrade" your access database to a SQL > Server database, but you must actually connect to a machine that is running > the SQL Server software. Access and SQL Server are two seperate different > products. > > -Craig > > > ----- Original Message ----- > From: "laurent hsld" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, December 09, 2001 11:00 AM > Subject: SQL server > > > > Hey everyone, > > > > This is my first post in this list. > > > > I Know that maybe it's not the right list to ask such a question but as > > long as i know that some of you may have encountered the same problem. > > > > I have installed office XP (at first to work with access) and i find out > > that some sql server possibilities are in, the installation work fine but > i > > don't know how to get into, i mean construct a sql server db, i tried to > > get into by the osql utility but each time a password is required. After i > > have entered the password i always got the same error message : the user > is > > not associated with a secured connection... > > > > What can i do ? is there any other way to get into SQL server ? > > > > thanks for your help and once again sorry for this out of subject message. > > > > Laurent > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists