By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,425 Members | 2,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,425 IT Pros & Developers. It's quick & easy.

How much can Access do?

P: 76
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.
Dec 29 '06 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,892
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.
Dec 29 '06 #2

ADezii
Expert 5K+
P: 8,638
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
Dec 30 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jan 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.