DB Size??

[Guest]

To what size can a Access DB grow? Is there limitations? Can this be overcome?

 

[Guest]

I noticed that the Access limit is 2Gb. Is this 2Gb the Access App itself or
included data added to the DB?

 

[Douglas J. Steele]

An MDB file cannot exceed 2 Gb.

In normal usage, your application should be split into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end (containing the tables and relationships). That gives you 2 Gb for
the application (the front-end), and 2 Gb for the back-end. Of course, if
you're coming close to that limit, you might want to consider moving your
data to SQL Server or Oracle.

 

[Guest]

Thanks for that. On SQL Server. I have access to a SQL server Via the IT
department. Will the Tables be recreated in the SQL Server or can i use the
existing tables as well?

 

[Douglas J. Steele]

You'll have to create the tables in SQL Server, and transfer existing data
to those tables.

 

[Bill Mosca, MS Access MVP]

You can use the upsize wizard (Tools>Database Utilities>upsize wizard) to
convert your tables to SQL Seerver database tables.

You don't have to convert all of them if you have a need to keep some of the
tables in Access format, but you certainly do not want to have the same
table in both access and SQL Server. The SQL Server tables should be linked
to your Access database.