Split Databases

[Bruce]

Hi

I decided I'd split my database. I noticed after it was
split that my forms opened up very slowly compared to when
it wasn't split. Is this normal? If not normal what can
I do about it? Also after the database is split can I
apply separate file level security to the two files? I
would make the backend file read only. I don't use "user
level security" yet as I'm still learning this. Thanks.

 

[GVaught]

If you make your backend read only, then you can't add new data. The
database must have read/write/change permissions as well as the users. You
control what they can do within the User level security. If you apply
security properly, the backend end will also be protected.

What can make forms run slower is being directly connected to the tables
rather than through a query. You must make sure all fields are in the query
before attaching to your forms or they may become non updateable. It also
depends on how fast your computers are; a Pentium II 400 will run much
slower than a Pentium IV 1.4 GHz. Also, what affects speed is your memory;
the higher the better and lastly the OS that is running on each computer.

 

[Ozzone]

First of all you didn't say how you split it. I'm
assuming you put all the tables in a separate database
from the forms, reports, etc.

I'm also assuming by "backend" that you are referring to
a network drive of some type. Anytime you have to travel
through a network to get to the data from a form, it will
run slower depending on the speed and configuration of
your network. If you have a slow network, it will load
the data much slower on the forms.

Sure you can lock security on the tables for read-only
access or simply change the form to be read-only.

 

[Immanuel Sibero]

Hi Bruce

If you havent already, have a look at:

http://www.granite.ab.ca/access/

Lots of good info on split database and performance.

You should not apply different file level security. Access is a file level
database system, so all users must have all rights and privileges to the
folder/share/drive where the files reside.

HTH,
Immanuel Sibero