I'm asking this, because i tried to divide the database in three mdb files, the result: It turned too slow.
When before the division, a simple query was instantanily opned, with the three backends toke an eternety.
Is there a reason for that?
The first thing it depend upon the records that stored in your table and secondly on the traffic of your network.
I am handleing 35 tables on the network that are coming from almost 7-8 different database. Each of them are containing not less than 30-35 records with 11 users. Rarely users access to the same record or same table that produces write conflict (I already have Edited Record from form's property that avoids this). So it do not distrub its speed.
If it comes to me, I would say better to keep more than ONE back end. This would help a lot not to rush in accessing tables and help to reduce traffic which I am doing.