Trouble sending a e-mail to update tables, what's the best way to link tables

Trouble sending a e-mail to update tables, what's the best way to link tables

Post by GIL-PT via » Fri, 23 Mar 2007 07:44:43


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
any trouble.
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?

Thank You.

--
Message posted via AccessMonster.com
http://www.yqcomputer.com/
 
 
 

Trouble sending a e-mail to update tables, what's the best way to link tables

Post by Jason W. M » Mon, 26 Mar 2007 20:34:36

Access is capable of replication/sychronization (minus the new Access 2007
format) which sounds like what you need to do having multiple copies in
multiple locations. You can check out the Help within Access or here's a
link to an article http://www.yqcomputer.com/ :
Replication.

For sending e-mail without the security prompt from the Outlook security
update, I recommend using CDO for Windows 2000 and a remote SMTP service -
check out http://www.yqcomputer.com/
perfectly for me and no prompts!

Hope this helps.

-Jason

 
 
 

Trouble sending a e-mail to update tables, what's the best way to link tables

Post by GIL-PT via » Fri, 30 Mar 2007 06:51:48

Thank you for your tips i'd like specially using CDO for Windows 2000, the
seems the only problem with that is always have to know the smtp server from
who is using my database, i guess i have to create a field where i will be
asking the user for his smtp server.

so if i just could bypass the warning from outlook that was a easier way.
But anyway thanks for you help, and sorry for my english. :)



--
Message posted via AccessMonster.com
http://www.yqcomputer.com/
 
 
 

Trouble sending a e-mail to update tables, what's the best way to link tables

Post by GIL-PT via » Fri, 30 Mar 2007 08:06:25

Folowing the tips from Jason
I researched little more about Microsoft CDO for Windows 2000
and i found it someone saying this code worked for him without any trouble,
didn't had to define is smtp server , so I tried it.

Private Sub Command0_Click()

Dim ObjMail As Object

' Create CDO object
Set ObjMail = CreateObject("CDO.Message")
' Config email
ObjMail.To = "<receiver adress>"
ObjMail.From = "<my address>"
ObjMail.Subject = "The subject"
ObjMail.HTMLBody = "I'm the body of the <i>E-Mail</i>"
'ObjMail.AttachFile "C:\temp\test.txt"
' Sending mail "here is where I'm getting the error"
ObjetoMail.Send

' Closing CDO object
Set ObjetoMail = Nothing

End Sub

But I'm getting this error and I'm not understanding

The "SendUsing" configuration value is invalid

Is Something missing here? maybe the smtp server?
Anyone can Help me?




--
Message posted via AccessMonster.com
http://www.yqcomputer.com/