Hi, I have a database that so far is working fine. Now I got a new challenge
I have to put this database in 2 other locations, these locations will have
the database running with their data, but I need to have access to the data
from their databases in my database.
Now I was thinking of placing a copy of the database in a shared drive
(network) from which they will work and I will make a link from my tables to
the tables in this database to update mine. I think this should work without
Is this right, or should I take another approach???
Now for the other location it's a little bit more complicated (I think) they
don't have access to the shared drive,(network) so what i'm trying to do is
at the end of the day, the database creates a report and sends it to me so I
can upload the info into my database. So far it seems ok , but I have a
problem when the database sends the email, there is a pop up message (it
seems a protection from outlook)
"A program is trying to automatically send a e-mail on your behalf.
Do you want to allow this? ...etc..."
and if there is nobody to press the yes button, the message wont be sent. So
how can I bypass this message?
I tried to use the sendkeys function but they dont seem to work?
Can anybody help me with this?
Message posted via AccessMonster.com