sql size and access database size when full what do you do

[Dapper]

1. sql what is the max size of the data it can hold?
2. access what is the max size that it can hold?

when access gets to its max size as in no more data can be added what is the way round this. Do u you manualy delete or run aa code to delete the data or run some code to remake the tables.

Please advise as soon as

thanks

 

[Golom]

Answered most of this on thread222-788204.

Your options for dealing with hitting the limit are (not a complete list)

[li]Archive some of your data to another database (or databases) and remove it from the one that's full.[/li]

[li]Just delete old data if you no longer have a business reason for keeping it.[/li]

[li]Migrate your data to a more potent system such as SQL Server, Oracle, DB2, etc.[/li]

[li]Split large tables to separate databases and then link them back into your production database. Each separate database (i.e. *.mdb file) has its own 2 GB limit.[/li]

 

[BNPMike]

Do you mean:

1) What is the maximum size of a Microsoft SQL Server Desktop Edition database

2) What is the maximum size of a Microsoft Jet database

If so I think the answers are 2Gb and 1Gb but you best check on Google.

What happens when you fill up databases depends on a whole host of things. I doubt you'll have a problem unless you've just got a contract to write a system for Citibank.

 

[Dapper]

many thnaks for your replies, i suspected that i would have to transfer or delete the data.

many thanks

Dave