Database Design Question (1 Viewer)

JamesJoey

Registered User.
Local time
Today, 16:21
Joined
Dec 6, 2010
Messages
510
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

"Access- Imagineer that!"
Local time
Today, 16:21
Joined
Nov 1, 2006
Messages
549
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
 
Last edited:

JamesJoey

Registered User.
Local time
Today, 16:21
Joined
Dec 6, 2010
Messages
510
Ok.
Thanks much,
james
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom