Can access send data to mobile phones?

[Groundrush]

Access is a fantastic product & I've been using it for a good few years now.
Sadly for various reasons we will be moving onto another non access product.

This process has taken us two years so far & there has always been a comparison between this new software & Access.

There are so many faults with this new system & when we complain & state what we can do in Access but not on the new system they claim that Access can’t send data to mobile phones, implying that that's the main reason why we are binning Access.


You see, we are going to start using what is called "Mobile Solution"
We will be getting rid of paper systems & have everything sent through to mobile phones using windows mobile 6.1


Basically a job is logged on the system with a job no etc & and then a message is sent to a mobile phone account similar to a text message but used in an application designed to work on windows Mobile.


Surely this can be down using Access. Has anyone ever heard of this or even tried to do it themselves?

 

[DCrake]

You can get Access to send SMS to mobile phones? Is that all you need to do?

I do it for sending out reminders to patients about appointments.Do it also from VB.

David

 

[Fifty2One]

Office mobile also has Excel and Word. Sadly when decisions are made to change some things the end users are not neccessarily considered... the decision makers were probably guaranteed that any issue raised is "not a problem" by sales staff, but the marketing people rarely are the same persons who have to come up with the fixes.

 

[Groundrush]

You can get Access to send SMS to mobile phones? Is that all you need to do?

I do it for sending out reminders to patients about appointments.Do it also from VB.

David

That is very interesting?

We won't be using sms because of the cost invlolved but it's done by sending bursts of data every few minutes (not sure of the technical terms)


I don't suppose you can give an example of some basic code that I can use to show them.


I have the mobile no of the person making all these false claims & wish to send him a nice little text message....

 

[Groundrush]

Just quickly googled it & found that I may need to get sms servers installed

 

[music_al]

you need to configure an SMS Gateway. There are a number of providers out there.

Here's one Ive used in the past.

http://aql.com/

 

[Fifty2One]

SMS stands for "Short Message Service" and uses mobile phones to transmit short messages to and from mobile phones.

That is very interesting?
We won't be using sms because of the cost invlolved but it's done by sending bursts of data every few minutes (not sure of the technical terms)

I don't suppose you can give an example of some basic code that I can use to show them.

I have the mobile no of the person making all these false claims & wish to send him a nice little text message....

 

[DCrake]

Here is some sample code for sending sms

 

[Groundrush]

Here is some sample code for sending sms

Hi Drake, thanks for that


I downloaded a trial message server software that allows you to send sms messages via access

It does look promising however I do not have the correct lead to attach the phone to my PC to completly test it

 

[DCrake]

I would have thought that it would work wirelessly?

 

[Groundrush]

The sample I found allows you to use

phone-to-pc data cable or Infrared

 

[Mr. B]

Take a look at this thread in another forum.

http://www.tutorialized.com/view/tutorial/Send-SMS-from-PC-to-mobile-phones-using-VB/9535

It talks about using regular email to send the sms message to the phone.

I have not tried it, but I do know that you can send a text message to a phone using email.

 

[Boro]

I could just agree with You about MS Access. Very good, very complete product and just these who don't know to project data base well tell for MS Access that it is to small for their large data. You could put about 20 mil. of records about 100 characters long. Is it small? Yes it is if You put pictures, grafic and if You don't know to organize tables in a right way .

 

[Groundrush]

The main reason why software developers & IT departments are against access is because they don't like the loss of control they get when people realize the potential to create databases themselves.
They prefer to restrict their users with hard coded software that is designed for more than one customer & ends up becoming more difficult to use.

Jack of all trades master of none.

 

[Mike375]

Take a look at this thread in another forum.

http://www.tutorialized.com/view/tutorial/Send-SMS-from-PC-to-mobile-phones-using-VB/9535

It talks about using regular email to send the sms message to the phone.

I have not tried it, but I do know that you can send a text message to a phone using email.

When I started reading this thread my first thoughts were Access to Email to Mobile.