|
If you separate the Forms from the Tables you can work
with the elephants on the workstation, and link to the Tables on the
server. This is one more step in Normalizing the database.
When you began with the Table definitions, you separated like with
like. Each Table was a unique collection. The Movie Table contains
movie data, not customer phone numbers.
The goal is to create two databases that are linked together.
One database will contain nothing but Tables. This database
will be placed on the Server.
The other database will have everything but the tables. This
can be your user's application and it can run on their own hard
drive.
Where should you put the Tables?
The best location would be a Server. All of the computers would
connect to the Server to run the database. The Server’s job is
network storage, backups, and user management, so your database
would be in good hands. Example of a
database that has been split into two files: Data and Forms |
|
| |
