Size Limit to Database

[weeze2]

Hi
I need some help. The database I am running has reached maximum size around 1GB. I read that one can link to a table instead. I tried this and it still complains. Must one divide the table into more than one. And if so how do you then use them as one table?.

 

[beetee]

Some thoughts:

1) Try reducing field sizes if possible
2) See if normalization of the data is possible (i.e. redundant data that can be stored in another table, and refered to by ID in the parent table)
3) Split the table design in 1/2; preferably using some sort of functional guidelines. Use an ID field to link the two tables together.