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

Huge Database Advice

P: n/a
My office of 6 folks want to put together a large database (over a
million records) and hit it often with querries. Can someone offer up
some advice on how to go about this? These are options I've thought of.

(1) Set aside a dedicated computer to house the MS-ACCESS database.
When someone wants to use it they go over and do so, perhaps exporting
a querry result to Excel, putting it on the network and going back to
their computer to retrieve it.

(2) Put the MS-ACCESS database on the network's server. People open the
database file and goal. (Is this feasable with a million plus records?)

(3) Use another database. I've read some on MySQL as a possible route.
But I'm not sure what this would entail. In my readings there was a
bunch of talk about configuring a server... So I got the feeling this
isn't exactly a similar solution to MS-ACCESS, is it? (i.e. we're no
longer talking about a file sitting somewhere that users double click
to launch - mySQL we're talking about a front/end back/end type thing
requring extensive programming?)

Also, related... is there any shareware program that helps in the
design and layout of a large database? We've got a bunch of papers with
lines connecting them and notes and...
Thanks for your time and advice,
Paul./

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.