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/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
