Hi Guys.

If there is any space on the sheets, can we code the word processing there?

GOODBYE Office, Hello EXCEL! Finally I have the sense that, with you help,
we are making real PRGORESS!

BTW We can wait to Tuesday to unload all the copies of Word, although,
really would like to unload Access AND word in one go.

Can I use the same vbs Kill routine I have?

TIA!

KJ



"Bob Phillips" wrote:

Hey Eddie.

"Eddie" wrote in message
...
KJ,

I've got to agree with the other posts so far - Access is a fantastic
tool.

Well I think we start to differe here. I think it is a severely limited
tool, but it will manage thousands of data records better than Excel, has
built-in functionality to make data maintenance relatively simple.

Have you considered bringing the different tables from each database into
one consolidated location? That alone might make your life easier.

Doesn't that defeat the object of a relational database?

If that's not enough, you might try using linked data in Excel. Excel can
import data through a database query <Data - Get External Data - change
it
in Excel and it changes the linked Access file, and vice versa.

That's the way to go. Use Excel as a front-end to the database. Maintain the
data simply in Access, do you basic reports in Access, use Excel to add the
value for scenario testing etc.

You might want to play around with one of these ideas before wiping out
the
old databases. Most managers don't like change, especially when they
aren't
involved. Make copies of the databases before you play, just in case you
click the wrong button!

If he worked for me and wiped out Access databases to load all that data in
Excel, I would fire him immediately <bg