Re: access front-end for SQL
On 9/25/00, avex penned: 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? Yep. Piece of cake. Design your database in Access, then choose Tools:Database Utilities:Upsizing Wizard. Choose create new database, then it will ask you a couple questions as you go, the server to connect to, the login and name of the database, whether you want to use Triggers or DRI, and you're done. I choose Triggers and let Access decide whether to add a timestamp. Once to database is done, you can change table properties through the .adp file that's created by using design mode just like with a .mdb file. Also, you can right click on a table to show the triggers and edit them if any end up not being what you expect. They usually end up being right on the money. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: access front-end for SQL
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/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.