Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

pryest

Programmer
Joined
Dec 26, 2006
Messages
24
Location
US
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
 
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
 
Try this forum post. It is how I learned from the ground up normalizing to spliting a database properly:


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
 
Great! Thanks again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top