Handsome
asked on
Runtime error 2220
I have a table in Access containing a field with an image name i.e. pen.jpg. All the images are held in a folder called Medium in Program Files.
I have created a form to display this information along with the picture that the file path points to.
PicProduct.Picture = "C:\Program Files\Medium\" & txtProduct.Text
My problem is that different machines get different error messages when the form is opened but on some other machines it work OK.
I'm running Windows 2000 and Access 2000
1st error message
Runtime error '2220':
Microsoft Access can't open the file
2nd error message
The expression OnCurrent you entered as the event property setting produced the following error: Privilege 2005 doesn't support the format of the file c:\program files\medium\pen.jpg
Can anyone explain how this is happening and how to avoid it?
Thanks
I have created a form to display this information along with the picture that the file path points to.
PicProduct.Picture = "C:\Program Files\Medium\" & txtProduct.Text
My problem is that different machines get different error messages when the form is opened but on some other machines it work OK.
I'm running Windows 2000 and Access 2000
1st error message
Runtime error '2220':
Microsoft Access can't open the file
2nd error message
The expression OnCurrent you entered as the event property setting produced the following error: Privilege 2005 doesn't support the format of the file c:\program files\medium\pen.jpg
Can anyone explain how this is happening and how to avoid it?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try
me.PicProduct.Picture = "C:\Program Files\Medium\" & me.txtProduct
me.PicProduct.Picture = "C:\Program Files\Medium\" & me.txtProduct
ASKER
Steve the machines this happens on only have the Access Runtime that it installed with the programme This comes from Office Developers tools with which I package the programme.
ASKER
Dave
Will this download work if only a runtime version of access is installed
Will this download work if only a runtime version of access is installed
I assume so, though i have never tried... and the documentation doesnt specifiy...
ASKER
I'll give it a go and let you know soon
I would read the EULA on the ConverterPack very carefully to make sure that you can install this as part of your ODE on a machine that does not have Office installed.
Steve
Steve
ASKER
Will do - will come back as soon as it's done
ASKER
Well done Flavo - works a treat
Steve