Access size limit , Any options to prevent reaching its file size limits?

[fluffyvampirekitten]

I created a form whereby it will show a few graphs to show the analysis of the data.
1.) Analyse 3 years of record to see the trend.
2.) User have to load in the data every month by uploading excel which is around 30.0 to 50mp per file.
I think the constraints is that access only holds in 2gb , if user keep loading in the data.


There's a possibility that it will exceed the limit.

What are the options to improve this system ?
I'm lacking out of ideas.

[June7]

Is the db split? A frontend can link to multiple backends.

Migrate to SQLServer or Oracle - both mean big money investment.

[fluffyvampirekitten]

Is the db split? A frontend can link to multiple backends.

Migrate to SQLServer or Oracle - both mean big money investment.

Anyway to migrate without those servers ?
DB split ? All my forms , queries , reports and tables are in one access file.

[ranman256]

everything in 1 Front end file, except tables.
the tables can be in separate dbs feeding the FE. (each individual gets their own FE)

[CJ_London]

Migrate to SQLServer or Oracle - both mean big money investment

or sql server express (10gb) or MySQL, both free

[fluffyvampirekitten]

or sql server express (10gb) or MySQL, both free

Can Sql Server express import excel files?

[June7]

It's a MS product so I am guessing yes. Did you Bing or Google?

[fluffyvampirekitten]

It's a MS product so I am guessing yes. Did you Bing or Google?

Im using both. What is FE means ?

the tables can be in separate dbs feeding the FE. (each individual gets their own FE)

I'm still quite new to access and the access vba

[June7]

FE = frontend
BE = backend

[fluffyvampirekitten]

FE = frontend
BE = backend

Okay ! Thanks. I guess I'll try out the split database

[CJ_London]

Can Sql Server express import excel files?

Access provides a front end and back end solutions, SQL Server/Express, Oracle etc only provide the back end, you will still need a front end, which could be access or it could be something else. SSE is not a 'bigger' Access, just as Access is not a 'bigger' excel. So to import data you could still use the access front end, or there are other routines you can use

[fluffyvampirekitten]

Oh. Okay I get it Thanks ^^ I learn alot

[kgj]

thanks ill try to do it