How much can Access do?

[kcddoorman]

At what point does one need to use another DB software. I noticed access has a 255 field limitation in its tables and queries. Is this something you find in most Db software?
I new to this access stuff but I've had some training in writing VB, C+, Java, perl, and using windows applications. I'm going to school for a bachelors in Information Systems Security so this isn't exactly my cup of tea. I like Linux/Unix sql much better than Microsoft stuff. It may be hard to set up but once it works, its a beautiful thing.

[AricC]

At what point does one need to use another DB software. I noticed access has a 255 field limitation in its tables and queries. Is this something you find in most Db software?
I new to this access stuff but I've had some training in writing VB, C+, Java, perl, and using windows applications. I'm going to school for a bachelors in Information Systems Security so this isn't exactly my cup of tea. I like Linux/Unix sql much better than Microsoft stuff. It may be hard to set up but once it works, its a beautiful thing.

This can be a rough decision. The beauty of Access is in the cost. SQL Server & others cost ~4,000 and up. One of the reasons to upgrade is if you have a lot of people making transactions on the database at the same time. Are you looking at doing this for school purposes? If so download the free trial of SQL 2000/SQL 2005.

[ADezii]

This can be a rough decision. The beauty of Access is in the cost. SQL Server & others cost ~4,000 and up. One of the reasons to upgrade is if you have a lot of people making transactions on the database at the same time. Are you looking at doing this for school purposes? If so download the free trial of SQL 2000/SQL 2005.

'To find a complete listing of Access Specifications:
1) Help
2) Microsoft Office Access Help
3) Access Specifications

[MMcCarthy]

At what point does one need to use another DB software. I noticed access has a 255 field limitation in its tables and queries. Is this something you find in most Db software?
I new to this access stuff but I've had some training in writing VB, C+, Java, perl, and using windows applications. I'm going to school for a bachelors in Information Systems Security so this isn't exactly my cup of tea. I like Linux/Unix sql much better than Microsoft stuff. It may be hard to set up but once it works, its a beautiful thing.

I know there can be reasons why large tables and queries are required but as a rule they should be avoided regardless of what system you are coding in.

Mary