Search results

I think Access is your problem. In my experience Access is a great tool but when you have 30 concurrent users you are stretching the limits a bit. :( I think you would be better using SQL server as a back-end to Access front-ends for your users.

No problem! Glad it's working.

The .Attachments.Add "FileName" can be used many times. I use this method in some code I wrote to transfer data from our AS400 and add it as a csv attachment in Outlook. I don't use the olByReference though.

Try this. With objmailitems .To = strTo .Subject = strSubject .Body = strBody .Importance = strImportance 'olImportanceHigh .Attachments.Add(strAttachment, olByReference) .Attachments.Add(strAttachment2, olByReference) .Display

If you have problems with the above then this works also. .Attachments.Add "C:\Your File1" .Attachments.Add "C:\Your File2" .Attachments.Add "C:\Your File3" etc geraldcor, This would probably have solved your problem also.

.Attachments = "C:\Your File1" .Attachments = "C:\Your File2" .Attachments = "C:\Your File3" etc

Kodo, That quote should go down in the hall of fame :p And it's true....

Try using .Display to see if it will at least display the email. I've not tried Kodo's method so I can't comment.

Have you tried stepping through the code to see where the problem is?

A logon script will run when user first logs onto the network. It can be used to run software, synchronize time, map drives etc. This would save you the hassle of going an installing the MDAC update on every pc. You should be able to download the required MDAC version from Microsoft. I would...

Make sure you have set reference to the outlook library.

I'm not sure if I'm right but if you have say Photo Editor at work the ole object will use Photo Editor as the sort of underlying software for the image. If you then take you database home and you don't have Photo Editor then it will package the object rather than display it. I havn't explained...

The problem is the ole object is being displayed as a package rather than the image. I have had this problem before but unfortunately cannot remember what I did to fix it. I have a feeling it may be something to do with imaging software on your pc. Do you have the same software at home as at work?

With Office, run the setup again and select Add & Remove Features. Then go to Converters & Filters > Graphic Filters>Jpeg Interchange Format. Select Run from my computer. Not too sure if this is the same for standalone Access. If I remember right Office installs it automatically but with SA...

JPegs are compatible with Access. Are you using Office or stand alone Access? Have you added the Jpg Interchage Filter ?

Access Developer has a package and deployment wizard you can use. There are plenty of posts here about this. You could also try some free software like inno setup.

Sorry I thought this forum was about helping people and not putting people down because they don't live up to your own self inflated ego :mad:

This has happened to me on 3 occasions. Only once was I able to get around it and that was because I could open the form in design view. The other 2 occasions I was like you, stuck. The only option was to restore from a backup copy or recreate the form again which cost me a days work. I always...

Dave, I use MyDB Converter to transfer data from Access To MySQL and vice versa. It cost me about £20 at the time but I think it has gone up a bit now. http://www.softguru.net/

This is an example. The code was just thrown in for this purpose.