If you are going to use an access data project to connect to the SQL tables, the SQL table must have a primary key - or access won't let you edit data in the table (the PK can be composite)
Alex > -----Original Message----- > From: Jeff [mailto:[EMAIL PROTECTED]] > Sent: 07 October 2002 02:44 > To: CF-Talk > Subject: RE: OT? Easy data entry util for SQL? > > > In addition to what Dave mentioned, you can create an Access Data > Project (.adp) file that gives you access to views and stored > procedures > as well. > > HTH, > > Jeff > > -----Original Message----- > From: Ed Gordon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 03, 2002 5:52 PM > To: CF-Talk > Subject: OT? Easy data entry util for SQL? > > > We have been using Access for so long now I got used to being able to > enter/edit data with a few mouse clicks, just opened up the table and > started typing or making corrections (to users, parameters files, or > erroneous transactions during development). > > 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? > > Thanks In Advance > > Ed Gordon > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm