Question Locked

MS Access Exchange works once then fails

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am using seven workstations connected to an SBS 2007 and running MS access frontend to a MSSQL database The mail system uses Outlook on the workstations connected to the MS excahnge server wich is part of the Small Business Server. Code is written in MS Access VB to manage the DB and send emails (this is a booking agency and they send confirmations by email). On five workstations it works fine. On two workstations it works once then fails with an error message that simply indicates Access could not send the email.Workstations all run windows XP PRO (I think with same updates and revisions) Most strange and very perplexing. Any suggestions welcomed.
TIA
Sandy

4 replies

by pshiflet-24

What version of Access is being used for the front end on each of the workstations? Is it different, or different Office service pack, on the two that are failing? Also, what version of the .NET framework is installed on each of the client PCs and is there anything in the event viewer on both the client machines and the server?

Please let me know if this points you in the right direction, is unclear, or you have further questions. Thanks.

by sandy

I am pretty sure the same version of Office is running - but not sure about version of .net - didn't realise this could be involved - will follow up and thanks

by maevinn

Get into the MS Visual Basic for Access and open Tools: References. Verify that all of the checked references are present. I've had similar usless error messages pop up when a reference was missing. If any of them say (Missing), uncheck that reference, and it most likely will run fine. If not, then you'll need to locate and install that reference to the machine in question.

This discussion is closed to new replies.