Hi Ruben, Yeah I understand that it's really the Jet engine doing the work but tend to call it Access for simplicity. The mdb was created with Access 2000 and the app runs on Windows XP so from what you say the limitation is probably not Access/Jet yet. I implemented a daily compact and repair a few months ago which reduces the mdb by about 3Mb each time and it has helped a little.
The number of weekly transactions is a bit scary so I've been planning a move to SQL Server long term. Thankfully there's only 1 user so I don't have to worry about conflicts. Thanks for the links it looks like there's some useful info there. Thanks, Dave. Dave Murray Delphi-En Moderator Glasgow, UK [EMAIL PROTECTED] --- In [email protected], Ruben and Yvonne Baumann <[EMAIL PROTECTED]> wrote: > > HI Dave! > > Depends on the version of JET. BTW, Access itself is not a > database, It's a frontend whose default db engine is JET(the MDE > file). Access can be used also as a frontend to ODBC compliant > databases, such as Firebird/Interbase, SQL Server, MySQL, etc. > > The version of JET that came with Access97 could handle up to 1GB > of data; Access 2000-2003 up to 2 GB. So 600,000 records don't > really sound like a lot to me. Since you said there are a lot of > queries run against the db, the MDE file itself is used as a > workplace, and that cruft doesn't get automatically cleared out. > Probably what you need to do periodically is run a Compact and > Repair. You'll have to look that up. Full Access has a menu > selection to do that. Be SURE you back you data up first! This > will reduce the size of your db and probably speed things up a bit. > > Long term, however, 12,000 to 15,000 transactions per week is a > little scary. If you're running that many transactions and have > more than 15-20 users at a time updating the db, it's probably time > to upgrade to SQL Server, Firebird/Interbase(should have come with > your Delphi?), MySQL, or some other db engine. Just upgrading to > Delphi 6 and ADO is only going to be a short term solution if you > don't replace your db engine. > > Take a look at comp.databases.ms-access in google groups. Lots of > good info there, and you can find some links and FAQ's on this > website http://www.granite.ab.ca/accsmstr.htm that cover your > predicament. Also check out > http://www.mvps.org/access/resources/index.html > Granted this is all Access, and you're a Delphi user, but there's > a LOT of info about JET, and how to upgrade/upsize from a JET db to > other SQL db's. > HTH > Ruben Baumann > ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
