DB management

[meenctg]

I make a simple database in access 2003. In this database everyday input a lot of data. I know the max file capacity of access 2003 is 2gb. Actually what i'll do when it reach 2gb file size.

How to i manage this database?

 

[boblarson]

You will have to decide quite a ways before it his 2Gb as you probably wouldn't be able to get the data back out at that point.

If you have lots of data, I would suggest moving to SQL Server Express 2008 if you can and you don't have full SQL Server available to you. The Express version of 2008 will hold 10 Gb of data. And, it won't be inaccessible if it actually filled up.

 

[meenctg]

If you have lots of data, I would suggest moving to SQL Server Express 2008 if you can and you don't have full SQL Server available to you. The Express version of 2008 will hold 10 Gb of data. And, it won't be inaccessible if it actually filled up.

You mean to say that, if i put the database file in SQL server the file capacity will extend?

 

[boblarson]

You mean to say that, if i put the database file in SQL server the file capacity will extend?

If you install SQL Server Express or if you have a SQL Server you can add a database to, then you can "upsize" the database using the upsizing wizard. But there is data that can't be upsized so do a search and read about moving an Access database to SQL server (some of the things that can't be moved are multi-value fields, attachment fields, any queries with Access functions in them).

But yes, you can move your data to SQL Server but it isn't just a "move the data" and go on with life. It takes some learning on how to work with it and how to best use it. It doesn't just solve all of your problems.

 

[mdlueck]

You mean to say that, if i put the database file in SQL server the file capacity will extend?

Yes if you migrate from desktop database code to Client/Server code with SQL Server (or some other SQL database) as the back end database and have Access be only the front end application, yes you may have HUGE database files as the data stays in the SQL back end most of the time and only the bits and pieces the FE needs to touch actually come down to the FE.

And merely moving the data to an SQL back end and continuing to use desktop database techniques will not deliver the full benefits possible.

Client/Server Architecture
http://www.access-programmers.co.uk/forums/showpost.php?p=1110794&postcount=5