access offline and emailing reports

[Guest]

I have 2 questions on access
1. I want to use access offline and then be able to update the master db
when i'm back online , other people may be inputting data whilst i'm offline
also i'm using auto generate number for my key fields.

2. I want to input an email address from a field when i use the sentto email
line in a macro, i know there is some code out there that does this but
unsure what it is.

many thanks

 

[Douglas J. Steele]

1. I want to use access offline and then be able to update the master db
when i'm back online , other people may be inputting data whilst i'm
offline
also i'm using auto generate number for my key fields.

Look into Replication. What you're describing is exactly what it's intended
for.