Reaching 2GB limit

[bbmak]

What to do when you reach 2GB limit data? Can I make another database with the same structure and link them together?


The front-end is okay, but only the back-end.

For example,

Database 1(reaching 2gb limit)
ID, Name, Address...


Can I add a database called Database 2
and then have the same fields and tables, and combining them?
ID, Name, Address...

[June7]

Have you run Compact & Repair on the backend?

Splitting up the backend is one solution. Is there more than one table?

I've never had to do this but I think it would be better not to split tables. Depends if autonumber is used in PK/FK relations.

Another might be migrating to different app for the backend, like MySQL.

[bbmak]

How do you split table? I want to know about how that method work. I have heard about the others.
I mean I want to split them horizontally.

[June7]

Split the fields to multiple tables?

Need a PK/FK relationship.

Is the PK an autonumber field?