| | |
|
|
|
big database |
|---|
| message from bev on 7 May 2004 |
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.
|
| Kevin3NF replied to bev on 7 May 2004 |
Access 2003 can handle a file size of up to 2GB. There is no explicit limit
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.
|
| Kevin3NF replied to bev on 7 May 2004 |
Cool...thanks!
|
| bev replied to Kevin3NF on 9 May 2004 |
so you would recommend proceeding with Access rather that going down the
MSDE route?
thanks
"Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OjpREuENEHA.2532@TK2MSFTNGP10.phx.gbl...
|
| Kevin3NF replied to bev on 9 May 2004 |
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.
|
| Tony Toews replied to Kevin3NF on 10 May 2004 |
For a million records I'd agree with you. It's a bit more work but
definitely stabler.
Tony
|
|
Archived message: big database (Microsoft Access Error Message)
