new to access

[anthony.montalvo]

i am fairly new to access 2003, i have created several database, very
basic ones, and i am trying to learn how i can enter information in
one data base and have it distributed into the rest of them. i manage
4 buildings for a school, ihave one database for each building and i
have to enter what rooms i put students in, ihave another database for
new arrivals, once there entered in new arrival data base, i then have
to enter them in to the proper building, i have one for students
checking out, once enterd in the checkout database i have to go into
that buildings database and remove them. this is time consuming, i
know that there is a way to make one entry and have it go to the other
databases or remove one and have it removed from the others.
I'd like to thank you inadvance for all any help

 

[Jeff Boyce]

Anthony

Do your databases exist independently of each other? Do the schools have a
LAN or a WAN connecting them?

You might want to take a look at the newsgroup dedicated to replication.

If your schools co-exist on a LAN, you could split the database (front-end,
with screens, queries, etc.; back-end with tables-only) and put a copy of
the front-end at each school and a single back-end somewhere on the LAN.


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

--
msnews.microsoft.com

 

[Tom Wickerath MDB]

if you're new to Acecss then you should be using Access Data Projects

you need to download MSDE (microsoft desktop engine) which doesn't work on
Vista-- I don't know which PM came to that decision; but I mean jeez..

MDB is not reccomended any longer

you just need to use SQL Server

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.