Microsoft Outlook & Ms-Access

[preethi]

Hi All,

I would like to ask 2 doubts.

I have created a Time Sheet Application for my compnay. I have 2 requirements

1) I want to send reminder mail to employees who doesn't create Time Sheet for each month. Is there any tool to connect MS-Access with Microsoft Outlook?

2) I want to put the application in the server? Is there any limit for how many person can use the Time Sheet at the same time?

Regards
Preethi

 

[pbaldy]

1) Sure, simplest method is SendObject in VBA

2) The formal limit is 255 concurrent users, the practical limit is much fewer, but it depends on a number of factors. In any case, it should be split:

http://allenbrowne.com/ser-01.html