big database

  • Thread starter Thread starter bev
  • Start date Start date
B

bev

can i run a big database using access 2003? 5 users, maybe 1 millions
records?

if not, what else could i use? someone mentioned MSDE, but i dont know what
this is.
 
Access 2003 can handle a file size of up to 2GB. There is no explicit limit
on number of records, but 1 million can certainly be done. Just make sure
your indexes are set up properly....

MSDE is a scaled down version of SQL Server that comes with Office/Access.
I have heard that the file size limitation is alsoG, but have not been able
to confirm this on Microsoft's site. If anyone has link either way, I'd
love to see it.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
so you would recommend proceeding with Access rather that going down the
MSDE route?

thanks
 
Kevin3NF said:
My personal recommendation when all else is equal is to use MSDE. It is
more stable, has builtin security, online backups, etc. But that's just me.
Click to expand...

For a million records I'd agree with you. It's a bit more work but
definitely stabler.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top