RE: Access

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. 
============================================================================