Prev: How To Change Form RecordSet
Next: Is it possible to snd SMS's in a group from an access appl.?*
From: J.Alladien on 4 Jul 2008 09:32
Dear Stefan,

Who is "my friend"?

"Stefan Hoffmann" wrote:

> hi J.,
>
> J.Alladien wrote:
> > Maybe a strange question, but with sms-ing so popular now adays, is it
> > possible to snd SMS's in a group from an access application just as you can
> > send e-mails to a group of people who are in your database?
> Yes, you just need to use a SMS to e-mail gateway or interface with a
> SMS Service directly.
>
> Some web hosters provide such functionality. Also some telephone systems
> provide such interfaces.
>
> Or you can communicate with a cell phone directly to post SMS.
>
> So lots of possibilites, you just have to evaluate it. Ask your friend.
>
>
> mfG
> --> stefan <--
>
From: J.Alladien on 4 Jul 2008 13:52
Dear Aaron,

I don't understand, can u please explain!What is xp_sendmail exactly?

Thanks

"a a r o n . k e m p f @ g m a i l . c o" wrote:

> yes xp_sendmail - it works reliably.
>
> ClientSide email spamming is a security hole; any way you look at it.
>
>
>
>
> On Jul 4, 5:03 am, J.Alladien <JAllad...(a)discussions.microsoft.com>
> wrote:
> > Dear all,
> >
> > Maybe a strange question, but with sms-ing so popular now adays, is it
> > possible to snd SMS's in a group from an access application just as you can
> > send e-mails to a group of people who are in your database?
> >
> > Thanks in advance!
>
>
From: a a r o n . k e m p f on 4 Jul 2008 14:05
it is a stored procedure.

Anyone doing anything with MS Access should be using SQL Server. Most
of the people around here don't believe that-- it's because most of
the real SQL people move on.. you know?

But SQL Server is like heaven-- things just work.. they work fast,
reliably-- and you get real tools.

And you still get to use all the same forms and reports-- but even
better, because you've got stored procedures.
Sprocs-- as I like to call them.


Sprocs _SLAUGHTER_ queries regarding code reuse.

It's like a vb procedure.. but it's on the database side.

-------------------------------------
CREATE PROCEDURE spGetEmployee
(
@EmployeeID INT
)
As

Select * From Employees Where EmployeeID = @EmployeeID.

DECLARE @EMAIL VARCHAR(50)
SET @EMAIL = (Select Email From Employees Where EmployeeID =
@EmployeeID)

XP_SENDMAIL @EMAIL, 'someone is snooping on your employee record'
-------------------------------------

in other words-- you can have a simple query-- whenever someone runs
it; it will email that person and notify them.
XP_SENDMAIL is a great tool, there are newer tools using SQL 2005--
but I just think that it is a much more reliable tool than using
Docmd.SendObject and asking people to hit "YES" when they get prompted
for email.

I wish you luck-- let me know what else I can do to point you in the
correct direction.

I would just start with an Access 2000-2003 version.. and run the
upsizing wizard. Choose 'Create SQL Server Application' is how it is
called I think.. or just choose the 'Access Data Project (ADP)'
format.

It's called the 21st century. Sending email --- through the db
server-- is a fact of life.










On Jul 4, 10:52 am, J.Alladien <JAllad...(a)discussions.microsoft.com>
wrote:
> Dear Aaron,
>
> I don't understand, can u please explain!What is xp_sendmail exactly?
>
> Thanks
>
> "a a r o n . k e m p f @ g m a i l . c o" wrote:
>
>
>
> > yes xp_sendmail - it works reliably.
>
> > ClientSide email spamming is a security hole; any way you look at it.
>
> > On Jul 4, 5:03 am, J.Alladien <JAllad...(a)discussions.microsoft.com>
> > wrote:
> > > Dear all,
>
> > > Maybe a strange question, but with sms-ing so popular now adays, is it
> > > possible to snd SMS's in a group from an access application just as you can
> > > send e-mails to a group of people who are in your database?
>
> > > Thanks in advance!- Hide quoted text -
>
> - Show quoted text -

From: So Sorry For Poor Aaron on 6 Jul 2008 18:43
"a a r o n . k e m p f @ g m a i l . c o" wrote:

> Sprocs-- as I like to call them.

aaron -- dumb butt as we have to call him (we don't like to, but we gotta
tell da truth)
 | 
Pages: 1
Prev: How To Change Form RecordSet
Next: Is it possible to snd SMS's in a group from an access appl.?*