Access 2000 file size limit

[GrandadUK]

Is there any way I can increase the file size limit in Access 2000 above the current limit of 2gb?

 

[mkov]

Why would you want to??

If you are pushing 2GB in Access, you really need to look at migrating to something other than Access for the backend. Take a look at one of these.....

MSDE
My SQL
SQL Server

 

[mkov]

Also, try a compact and repair on the database. It could be severely bloated.

Beware that the compact and repair could take quite a while on a database of that size though.

 

[MallardVHS]

is this the same as a front end vurses back end question?

does seperating front/back small up the file size?

thanks
don

 

[mkov]

Even still, that shouldn't make that big of a difference.

I have an entire sub accounting system front end that is only about 10mb. It has graphics, and images to make more "pretty" and 10K+ lines of code as well as numerous forms, lots of queries and reports.

The backend is in SQL 2000, and the backend database is about 4gb right now, and growing daily.

Sorry to ramble, but I don't see how splitting the database would help the size a whole lot. Although I would agree that if it is not split, it should be done.