Database Design Question (1 Viewer)

[JamesJoey]

My database currently uses 7 different data table ranging from a movie library, auto maintenance, reminders, home inventory...

Is it good practice to have all this data (which is a backend database) being accessed in one front end database?

Or should I create separate front ends for each specific type of data?

Any help will be appreciated,
James

 

[GohDiamond]

A single front end can handle it. If you want to keep the data in separate visual views then link it to different forms using tabbed documents and open all the forms at once. You'd have 7 tabs each with the table names on the tab that is its record source.

With the front end linked, you could place a copy of the FE on any computer on your LAN that has access to the BE and View the same data simultaneously (although editing the same record is by default locked).

Question is then, what are you going to do with this data? just store it so that its not forgotten?

CHeers!
Goh

 

[JamesJoey]

Ok.
Thanks much,
james