Susan Zeller
szeller at cce.umn.edu
Wed Mar 12 09:34:00 CST 2003
Tom, I think you are asking where others create views and sprocs? I mostly use Query Analyzer for this. Sometimes I do some preliminary SQL building by using EM to design a view, but I always use QA in the end. One of the reasons for this is that I have found that EM doesn't allow complicated structures whereas QA does. Some of my views are pages long with complicated case statements, etc. The ohther thing I like about QA is that I can document my code better. I created a custom template in QA that allows me to document basic things like who I am ,when I built the object, what it does in a consistent format. All my apps are ADP's, but I never create my views or sprocs there. Never really thought about doing it until recently. Questions on that appear in another post on the Access-SQL list. --Susan -----Original Message----- From: Tom Adams [mailto:tomadatn at bellsouth.net] Sent: Wednesday, March 12, 2003 9:30 AM To: accessd at databaseadvisors.com Subject: [AccessD] Access 2000 ADP's, Sql Server 7 and VB6 Just a note to pass on my experiences with the above combination. I use Access 2000 ADP's whenever I can because I think they're much more flexible and easy to use. I especially need to be able to sort tables and views to analize and check data. I use both Enterprise Manager and Access 2000 to modify tables and views and Stored procedures and to move tables between the production database and the development database. However I've recently had some problems and think Access might be the cause. I've had several corrupt views and when I copied a small report menu table from Production to Development and back to Production, I found an added chr(10) at the beginning of an nText field. This broke some code that used that field and after I finally figured out what the problem was I coded around it. I've decided to use Enterprise Manager to do all modifications and to copy objects from the Production to the Development database and back. I will also use Enterprise Manager to run all stored procedures. I'll just use the Access ADP's to check data. If anyone has any comments I'd love to hear them. Thanks - Tom _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com