Question Running Access as a Server

[Cedarguy]

Hi,

This may sound as a dumb question but I need to have Access 2010 running as a live process where actions are taken (e.g. email sent) when events occur (e.g. date reached).

The application I have in mind is a simple Customer Relationship Management (CRM) application which is perpetually running on my computer.

Would this be the same as how Access runs anyway but for a single user or do I have to acquire additional software/solution?

Thanks,

 

[CJ_London]

No, you can leave it running on your machine or another server. No additional software is required as regards Access.

Obviously your machine needs to be switched on, logged in and Access running. You will need to use timer events to trigger actions when events occur. There will be times when you will need to reboot - for example when windows updates require a reboot. And there will be other times when you may need to stop Access, for example to compact the back end.

I've developed a number of applications which are left running on a spare machine - for example to check for new emails and then import the data, but not normally so it is running all the time, tho' I guess there is no reason why they couldn't.

 

[Cedarguy]

Thank you; so I guess its status quo; just leave it running and thats it.