Access 2007 database multiple files splitting

[joker197cinque]

How can I do to split accdb files in more than only 2 (front-end and
back-end) files?

I read on this page:

http://office.microsoft.com/en-us/access/HA100307391033.aspx

that "A front-end database file can point to thousands of back-end
database files, each of which could be as large as 2GB"

so I read also this:

http://office.microsoft.com/en-us/access/HA102400961033.aspx

and I cannot see any way to split in more than 2 files....

Any help appreciated.

Best regards.

 

[Tom van Stiphout]

On Fri, 7 Mar 2008 02:19:07 -0800 (PST), joker197cinque

There is nothing built-in, but you can export one table to backend A
and another to backend B. Then delete the two tables from your
frontend, and link to the two tables.

What are you really trying to accomplish?

-Tom.

 

[eric94]

Hello,

I have the same question. How can we split an access database in more than two files ?

I did a test by filling an access database with images to reach the limit of 2 gbs and I get the message 'unable to etc...".

I did the test on a split database (with two files). I hoped the splitting would be automatic.

In fact not.