> Now that development has been ported to SQL, I dread the > command-line data entry of ISQL 6.5. Is there an easier > way to do what I got used to doing with Access? A recent > article, I believe it was in CFDJ, talked about interfacing > the Access front-end to an SQL database thru ODBC. Have you > actually tried it? Any tips/tricks?
Yes, it's easy enough to connect Access to an ODBC datasource pointing to a SQL Server database, and if you really want to do data entry directly against the database, it'll work fine for that. There aren't really any tricks that I can recall. You need to configure an ODBC datasource, then open an existing Access database or create a new, empty database, and use the "link tables" option to select tables from your SQL Server ODBC datasource. Alternatively, you can create an Access Project, if you're using Access 2000. I'm not sure exactly what this buys you from a data entry perspective; you'd typically do this if you wanted to manage the data schema itself, I think. However, in general, I'd recommend against getting in the habit of manually digging around in your database, if possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
