Tables in one Database and forms in another????

[pryest]

Hi,
I was looking at a database that had been professionally designed for a department here in my company. The designer put all the tables (tables only) in one database and then all the forms, queries, etc. in another and used linked tables. I was curious if anyone had an idea why this would have been designed this way? Wasn't sure if there was some pattern that I should be following. Thanks

 

[PHV]

This is a very common way called FrontEnd/BackEnd (aka FE/BE) designed for multi user.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[misscrf]

Try this forum post. It is how I learned from the ground up normalizing to spliting a database properly:

http://www.utteraccess.com/forums/showflat.php?Cat=&Board=accessfaq&Number=373096

Do it right the first time, and you will never regret it!

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[pryest]

Great! Thanks again!