|
Kate, If you want an Access-style tool that will directly crunch, toss, and tumble your 400 tables, large and small, with the greatest of ease might I recommend Visual FoxPro. We use it via ODBC connectors and can make whatever front end out of it we want. If you're familiar with Access the Fox is basically it on steroids so the learning curve won't be too bad! Good for reports too. Alan Kincer - MCSE, A+ IT Section Manager - KI(USA) 501 Mayde Rd. Berea, Ky. 40403 "Insanity: Doing the same thing over and over again and expecting different results." -- Albert Einstein http://www.universalthread.com/ http://msdn.microsoft.com/vfoxpro/ -----Original Message----- From: Kate Healy [mailto:Kate.Healy@xxxxxxxx] Sent: Monday, July 07, 2003 11:33 AM To: 'system21@xxxxxxxxxxxx' Subject: [SYSTEM21] Access We are just considering using Access - we are considering copying the data from the AS400 to a data warehouse nightly and using Access both for adhoc queries and for reports. Has anyone any experience of this/any recommendations? We had been using Objects but find it cumbersome at times. Regards, Kate Healy EI Electronics Sent: 07 July 2003 14:18 To: 'System 21 Users' Subject: RE: [SYSTEM21] JBA Reporting === [ KI (USA) Corporation - http://www.kiusa.com ] ====================================== Tel. 859.986.1420 -- Fax. 859.986.1485 This e-mail, including any attachments, contains information from KI (USA) Corporation that may be confidential or privileged. Mail is intended only for those to whom it is addressed. If you are not the intended recipient do not copy, distribute, or take any action in reliance on the contents of this message. If you have received this e-mail in error notify the sender immediately then delete or destroy all electronic and hard copies of this communication, including attachments. KI (USA) Corporation's anti-virus system checks for known viruses. However you are advised to run your own virus check before opening any attachments received. KI (USA) Corporation will not accept any liability once an e-mail and/or any attachment is received. Views expressed in the e-mail are those of the author and not necessarily those of KI (USA) Corporation. ============================================================================
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.