[AccessD] Future of Access?

Thanks for your ideas Charles!

I was guessing at a major upgrade/rewrite of the database about once every
five years, which is nicely within your estimate.

I'm starting with an A97 db 'cause I've already got one that could (with a
few changes) pressed into service in a few months. I've got a working A2k
version already (I use 97 at work and 2k at home).

Ok with SQLServer. Maybe I'll specify this. You never know, I may get some
training out of this? ;-)

Thanks again for you input Charles!
Chris Foote 

> -----Original Message-----
> From: Wortz, Charles [mailto:CWortz at tea.state.tx.us]
> Sent: Wednesday, July 16, 2003 1:51 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Future of Access?
> 
> 
> Chris,
> 
> All I would say about a 30 software project is that it will need to be
> converted between 3 and 10 times over its lifetime.  Trying 
> to say what
> those conversions will entail is pure guesswork beyond the 
> conversion of
> A97 to whatever is the latest version of Access at the time.
> 
> But why even start with A97?  You are already two generations 
> behind the
> curve, and may be three behind by the time the contract 
> starts.  If the
> contract specifies industrial-strength security, then Access of any
> existing version is not the place to start.  SQLServer is the minimum
> starting point in this case.
> 
> Charles Wortz