Access & The Internet

[BeanBob]

I would very much appreciate someones help on this (Hence why I'm writting a new thread I suppose!)

I am currently creating a website which involves having customers accounts etc. What I am looking for is a way for the website to automatically update a database in terms of how much they have bought.

For example, Shelly has an account with us. She buys 4 slices of cheese. When the order is sent off, a database (preferably on my computer due to security reasons) is updated with the invoice of that order.

Many Thanks and lots of chocolate (theoretically) for the person who helps me with this!

Paul

 

[danvlas]

You can do it in ASP and your database will be updated in real time. But the database has to reside on a web server and you need the permissions to execute scripts.

Or you can have the database update by 'inspecting' new email messages in an Outlook folder. In this way, the database will be stored on the same workstation as Outlook. But it will take some time to update the records and you'll need to design the email messages in such a way that you can read them easily...

Regards,

Dan

 

[BeanBob]

That's fantastic.

How would I go about making Access to be able to read an email message in Outlook?? I've never heard of this and it would be fantastic if it could work!!

Thanks again

Paul

 

[danvlas]

"If it could work?"
It does work

Check thread702-340662, it's almost the answer to your question...

Good luck,
Dan