Re: MS Access usefulness and size restrictions

"dave" <usted_at_cyberspace.org> wrote in message news:e2c00ae.0106080623.63ea0926_at_posting.google.com...
> Hi,
> I am developing a series of scripts that will tie into a database
> system that will be used to automatically update certain data and run
> queries on it. The database system will also be used for manual
> updates (i.e. used like Excel) for some non-automated tasks. I am
> thinking of using Access since it is fairly easy to use, but am
> wondering about its robustness, scalability, and other restrictions.
> For example, is it true that a record in Access can only be 2K?
> Really? I am also worried about access since it is a m$ product.
> Serious bugs or problems? Just wondering of the size restrictions and
> what you think about the product as a whole (97 or 2000 or any other
> version). Does anyone know of other database packages that can handle
> a lot of data but you can still update manually if needed?
>
> Thanks for any advice,
>
> dave

Yes the record length is limited but if you use a normalised design for tables the chances of it being a problem are remote. Put it this way there are many people on this NG who develop in Access for a living and this is not one of their complaints.

Robustness and scalability are relative terms, you give us no idea of the amount of data or number of concurrent users you will have or how they will connect to the database. As for bugs it depends on version. You say "a lot" of data, do you have any sort of ballpark figure in mind?

David Received on Fri Jun 08 2001 - 19:38:15 CDT