Hi All,

Here's my situation: I have an Access database for one specific program at my school. I have two other programs that I would like to enter information for into this database. To complicate this, the data has to be kept seperate sometimes, and sometimes it doesn't. It all depends on what type of report is needed.

What I'm wondering is, could I make three seperate databases for each program and connect them when I have to. Sometimes I have to detatch the main database and send it off to be evaluated, so that's why I can't really blend the three together. The information would be mixed. Also if I had three seperate linked databases, could I access them all from buttons on the start form, and combine data from them into one query when necessary? Or is there a simpler approach? As always, thank you!