Capacity in Access

[David W. Fenton]

The
various resources listed should help you through the process, but
- if you design your forms correctly - it really is very little
different from a .mdb backend for your tables.

Huh. You see, I have been designing all my my Jet-based apps with
upsizing in mind since, oh, 1998, so really, there's very little
that needs to be changed.

The point is: designing for efficiency in SQL Server is also very
efficient with a Jet back end.

 

[Arvin Meyer [MVP]]

I missed the part of the 10-year plan.

MySQL with InnoDB tables is much, much better than with MYISAM
tables. The only major thing you lose is full-text indexing, which
is very seldom an issue in non-web-based apps (i.e., the kind you'd
be developing with an Access front end).

Another free alternative that is better than MySQL is PostgreSQL.

 

[Arvin Meyer [MVP]]

I missed the part of the 10-year plan.

Turns out that he already is using full SQL-Server, so he needs to stay
where he's at, until the SQL-Server version he has requires upgrading.