Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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…

16-11-2003 10:07PM

#1

Sniipe

Registered Users, Registered Users 2 Posts: 2,933 ✭✭✭

Join Date: September 2000

Posts: 2573

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

#2 18-11-2003 07: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