Question about MIcrosoft Access

[radiaz]

Hello Guys,
I have a problem. I already have a database with data in it. There about 1800
records.
I have to go through every record and see if it meets certain requirements.
Check boxes will need to be checked if "X" record meets that requirement. I
have a few friends who are willing to help out on this. Is it possible to
make copies of the database. In this case it will be two databases plus mine
and have my friends help me with this, then, when we are all done, import
those two databases into mine? I'm afraid that is not possible to do. Is it?
I've never done it. Please advice.

Thanks,

Rita Diaz

 

[FredFred]

You can try the sophisticated method of using synchronization, but since I'm
unsophisticated, I'd do it a low tech method.

If you're all networked, just have them all work on the same database.

If not, back it up, then split the table into pieces (with "make-table"
queries) for different people to work on and then use append queries to put
them back together when finished.

Are the requirements something that you need a human to decide, or something
that you can automate with update queries? The latter could do all 1800
records in 1 second vs 1 week.

 

[Larry Daugherty]

If you can determine whether a box in a form on a record needs to be
checked by evaluating the record then you most likely don't need the
checkbox.

What you do instead is perform a calculation on the record every time
you would have displayed a checkbox.

If you are trying to do all of this directly in the tables then
*don't*. Tables are for holding the data. Forms are used to display
and manage the data and Reports are used to display and Print the
data.

If this all seems confusing then please post back explaining in detail
what real-world things you are trying to accomplish. Also, please
describe your existing tables and fields in detail so that we can best
help you.

HTH

 

[Kelly Cox]

Copy/paste works well also if you have a shared drive for the office. If you
don't a flash drive will also accept the database. Emails are hit and miss
for reliability. I also agree with the other two responses that identifying
the criteria and creating a query would probably work better. What exactly
you need would help determine if you need a query or to modify your form or
report. Hope this helps.

If you can determine whether a box in a form on a record needs to be
checked by evaluating the record then you most likely don't need the
checkbox.

What you do instead is perform a calculation on the record every time
you would have displayed a checkbox.

If you are trying to do all of this directly in the tables then
*don't*. Tables are for holding the data. Forms are used to display
and manage the data and Reports are used to display and Print the
data.

If this all seems confusing then please post back explaining in detail
what real-world things you are trying to accomplish. Also, please
describe your existing tables and fields in detail so that we can best
help you.

HTH