Database Problem
-
Hello all, I am having a bit of a problem with databases. Right now I have an application that stores data into an access database. But when the database goes over 2 gigs the application crashes out and it starts over writting the header file. Please give me some suggestions with using other database collectors, that would be a great help. Thanks:)
-
Hello all, I am having a bit of a problem with databases. Right now I have an application that stores data into an access database. But when the database goes over 2 gigs the application crashes out and it starts over writting the header file. Please give me some suggestions with using other database collectors, that would be a great help. Thanks:)
DO you use Access or SQL?I think Access has some limitation for size of database.SQLServer is more trustable for large database. Mazy **"If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"**Kryptonite-3 Doors Down
-
Hello all, I am having a bit of a problem with databases. Right now I have an application that stores data into an access database. But when the database goes over 2 gigs the application crashes out and it starts over writting the header file. Please give me some suggestions with using other database collectors, that would be a great help. Thanks:)
This is happening because Access limits the database size to 2 gigs. You might try archiving, I don't know if thats easy in access or even possible in your application. The long term solution is to migrate to SQL server. It's relativly I easy I think(I have not done this in a production setting so I am not sure how well this works). Steve Not all who wander are lost...