If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

database update question

Sniipe · 2003-11-16 21:07:35

ok, I've an access file (call it file.mdb) and an update file (call it update.mdb). I'd like to do a querie (I think). there is a table in both databases that I want to focus on called "people". in file.mdb the people table has a field called "member" (which is either a 1 or a 0, ie a member or not a member) there also is…

Options

16-11-2003 10:07pm

#1

Sniipe

Registered Users Posts: 2,932 ✭✭✭

Join Date: September 2000

Posts: 2572

ok, I've an access file (call it file.mdb) and an update file (call it update.mdb).
I'd like to do a querie (I think).

there is a table in both databases that I want to focus on called "people".

in file.mdb the people table has a field called "member" (which is either a 1 or a 0, ie a member or not a member) there also is a field called "date created"

Basically the update.mdb file has all its members as 0. all names are to be brought over to file.mdb but I want the file.mdb's members not to edit (just perhaps update there details, I can use date created here, I guess)

I'm clueless how to put it into access as a query(I've only done a bit of access, a couple of eons ago).

Any help would be appreciated.

0

Comments

Options
#2 18-11-2003 7:14pm
lucian

Closed Accounts Posts: 40 ✭

Join Date: September 2003

Posts: 37

Why exactly are you using two database, when one is more then enough?

0