Decomposed > That doesn't change the fact that I have no idea what the differences are between Access 2000 (the version I used long ago) and Access 2007. I need a good book. Maybe two.
I vaguely remembering when we went from Access 2000 to Access 2007.
I think the most significant thing I had to put up with was the
new methodology for linking to tables external to ones 'database'.
A preferred way (at least for my company) to do things, was to have
one database containing most of the data. Then a second database
with the queries, forms, reports, etc. etc. Then link the data table
to the 'program' database.
And then there is using Visual Basic within Access. That gets to be a lot of
fun.
And, it is possible to get away without using SQL at all. (Though some
pretty nifty things are possible for an SQL guru.)
By the way, if you have and use Sequel Server . . . Access can be used as
a 'front end' to access the data in SQL Server.
(And my Access is pretty rusty . . . I'm more a User of Access databases I
created a decade or more ago.)
Zim.
Mad Poet Strikes Again.
| 
