croy formulated the question :
I have a "family photos" database that I put together years ago, under
Access 2000. The main form shows a view of the photo, in addition to other >> photo metadata. The photos are all .jpg, and stored in a separate
directory.
I had been running Windows 7 Pro until yesterday, and the database was
working perfectly. Then I "upgraded" to Windows 10, and now the database
won't show the photos on the main form. Everything else seems to work fine, >> even the button for opening the image in Irfanview. But it won't show the >> photo on the main form.
If I open my filtering form, and put in something for criteria, I then get: >>
"Run-time error '2114':
Microsoft Access doesn't support the format of the file
'D:\Docs\Family\LFP_Quick\Small\2871-2.jpg,' or tile is too large. Try
converting the file to BMP or GIF format."
I don't think I buy that explanation.
I also have a laptop that came with Windows 10 Home, and I put the db on
there, and it shows the photos fine. The one difference between the two
machines was that the desktop was running Access 2002, while the laptop is >> running Access 2000.
So I uninstalled Access 2002 from the desktop, and installed 2000. No
help!
So I copied the db from the laptop to the desktop--no help.
I thought the Windows build difference might be showing its hand, so I
brought the laptop up to the same build as the desktop, 2004, tried the db >> and it still works great on the laptop!
Internet searching hasn't helped (so far).
Has anyone here figured this out before me?
-- croy
Hi Croy
Sounds like a premissions thing to me. Win 10 is more fussy about security than was Win 1. The fact that an Admin user can use the app without error is a big Hint Hint - Winkie Winkie. Either start your app with admin privileges every time you use it or relax the privilege level for the folder that contains the filer(s) you want to change.
Rdub
I have a "family photos" database that I put together years ago, under Access 2000. The main form shows a view of the photo, in addition to other photo metadata. The photos are all .jpg, and stored in a separate directory.
I had been running Windows 7 Pro until yesterday, and the database was working perfectly. Then I "upgraded" to Windows 10, and now the database won't show the photos on the main form. Everything else seems to work fine, even the button for opening the image in Irfanview. But it won't show the photo on the main form.
If I open my filtering form, and put in something for criteria, I then get:
"Run-time error '2114':
Microsoft Access doesn't support the format of the file 'D:\Docs\Family\LFP_Quick\Small\2871-2.jpg,' or tile is too large. Try converting the file to BMP or GIF format."
I don't think I buy that explanation.
I also have a laptop that came with Windows 10 Home, and I put the db on there, and it shows the photos fine. The one difference between the two machines was that the desktop was running Access 2002, while the laptop is running Access 2000.
So I uninstalled Access 2002 from the desktop, and installed 2000. No help!
So I copied the db from the laptop to the desktop--no help.
I thought the Windows build difference might be showing its hand, so I brought the laptop up to the same build as the desktop, 2004, tried the db and it still works great on the laptop!
Internet searching hasn't helped (so far).
Has anyone here figured this out before me?
--
croy
Either start your
app with admin privileges every time you use it
or relax the privilege
level for the folder that contains the filer(s) you want to change.
On Fri, 16 Oct 2020 09:34:22 -0400, Ron Weiner <rw@domain.com> wrote:
Thanks for the response.
Either start your
app with admin privileges every time you use it
That doesn't work--the images still don't show.
or relax the privilege
level for the folder that contains the filer(s) you want to change.
If I understand you properly, that doesn't work. I've gone into the properties|Security for
the directory, selected "Users", and given "Full control", and applied it to everything
including "sub forlders", but it doesn't help.
But switching into my admin account does work. I'm back to Hmmm.
I agree with Ron's idea that this has to do with permissions, but I
think you may be looking at it differently.
Your original post suggests that the picture file is located on drive >"D:\...", but if this is different on the laptop, that could be why you
can access the pictures from the account you're using.
What I would suggest is that you install both the database and pictures
in "USERS\PUBLIC\xxx" folder(s) on the Windows 10 desktop and see if
that works.
On Fri, 16 Oct 2020 12:00:16 -0400, Neil <neil@myplaceofwork.com> wrote:
I agree with Ron's idea that this has to do with permissions, but I
think you may be looking at it differently.
Your original post suggests that the picture file is located on drive
"D:\...", but if this is different on the laptop, that could be why you
can access the pictures from the account you're using.
What I would suggest is that you install both the database and pictures
in "USERS\PUBLIC\xxx" folder(s) on the Windows 10 desktop and see if
that works.
Thanks. I did that, and loaded from there, but it made no difference--the photos still don't
show on the form.
Hmmm.
Did you try the repair option in Access?
On Fri, 16 Oct 2020 14:12:16 -0400, Neil <neil@myplaceofwork.com> wrote:
Did you try the repair option in Access?
Yes, twice, actually. I've even uninstalled Access 2002, and installed Access 2000, but no
joy. Now I have installed Access 2002 again, and still no photos unless I'm logged in to my
admin account.
Since I don't use the laptop, I don't have a luser account set up, but I'm tempted to add one
just to see if it balks on the photos like on the desktop machine.
I have a "family photos" database that I put together years ago, under Access 2000. The main
form shows a view of the photo, in addition to other photo metadata. The photos are all .jpg,
and stored in a separate directory.
I had been running Windows 7 Pro until yesterday, and the database was working perfectly. Then
I "upgraded" to Windows 10, and now the database won't show the photos on the main form.
Everything else seems to work fine, even the button for opening the image in Irfanview. But it
won't show the photo on the main form.
If I open my filtering form, and put in something for criteria, I then get:
"Run-time error '2114':
Microsoft Access doesn't support the format of the file 'D:\Docs\Family\LFP_Quick\Small\2871-2.jpg,' or tile is too large. Try converting the file to BMP or GIF format."
I don't think I buy that explanation.
I also have a laptop that came with Windows 10 Home, and I put the db on there, and it shows
the photos fine. The one difference between the two machines was that the desktop was running
Access 2002, while the laptop is running Access 2000.
So I uninstalled Access 2002 from the desktop, and installed 2000. No help!
So I copied the db from the laptop to the desktop--no help.
I thought the Windows build difference might be showing its hand, so I brought the laptop up to
the same build as the desktop, 2004, tried the db and it still works great on the laptop!
Internet searching hasn't helped (so far).
Has anyone here figured this out before me?
--
croy
On Thursday, October 15, 2020 at 9:08:34 PM UTC-5, croy wrote:
I have a "family photos" database that I put together years ago, under Access 2000. The main
form shows a view of the photo, in addition to other photo metadata. The photos are all .jpg,
and stored in a separate directory.
I had been running Windows 7 Pro until yesterday, and the database was working perfectly. Then
I "upgraded" to Windows 10, and now the database won't show the photos on the main form.
Everything else seems to work fine, even the button for opening the image in Irfanview. But it
won't show the photo on the main form.
If I open my filtering form, and put in something for criteria, I then get: >>
"Run-time error '2114':
Microsoft Access doesn't support the format of the file
'D:\Docs\Family\LFP_Quick\Small\2871-2.jpg,' or tile is too large. Try
converting the file to BMP or GIF format."
I don't think I buy that explanation.
I also have a laptop that came with Windows 10 Home, and I put the db on there, and it shows
the photos fine. The one difference between the two machines was that the desktop was running
Access 2002, while the laptop is running Access 2000.
So I uninstalled Access 2002 from the desktop, and installed 2000. No help! >>
So I copied the db from the laptop to the desktop--no help.
I thought the Windows build difference might be showing its hand, so I brought the laptop up to
the same build as the desktop, 2004, tried the db and it still works great on the laptop!
Internet searching hasn't helped (so far).
Has anyone here figured this out before me?
--
croy
Is the default jpg viewer the same on both computers?
On Mon, 19 Oct 2020 04:57:24 -0700 (PDT), Ron Paii <ron8...@gmail.com> wrote:
On Thursday, October 15, 2020 at 9:08:34 PM UTC-5, croy wrote:
I have a "family photos" database that I put together years ago, under Access 2000. The main
form shows a view of the photo, in addition to other photo metadata. The photos are all .jpg,
and stored in a separate directory.
I had been running Windows 7 Pro until yesterday, and the database was working perfectly. Then
I "upgraded" to Windows 10, and now the database won't show the photos on the main form.
Everything else seems to work fine, even the button for opening the image in Irfanview. But it
won't show the photo on the main form.
If I open my filtering form, and put in something for criteria, I then get:
"Run-time error '2114':
Microsoft Access doesn't support the format of the file
'D:\Docs\Family\LFP_Quick\Small\2871-2.jpg,' or tile is too large. Try
converting the file to BMP or GIF format."
I don't think I buy that explanation.
I also have a laptop that came with Windows 10 Home, and I put the db on there, and it shows
the photos fine. The one difference between the two machines was that the desktop was running
Access 2002, while the laptop is running Access 2000.
So I uninstalled Access 2002 from the desktop, and installed 2000. No help!
So I copied the db from the laptop to the desktop--no help.
I thought the Windows build difference might be showing its hand, so I brought the laptop up to
the same build as the desktop, 2004, tried the db and it still works great on the laptop!
Internet searching hasn't helped (so far).
Has anyone here figured this out before me?
--
croy
Is the default jpg viewer the same on both computers?Yes, but I'm not sure why you asked that. The button to open the photo in Irfanview works in
either config. It's the photo image on the main form in Access that' not working under Windows
10 luser account, even tho it works on the same machine, but with my admin account.
Unless you're saying/thinking that Access is using the default jpg viewer to display the image
on the form. I always thought it was something built into Access.
For now, I've retreated from Windows 10, back to Windows 7. There were a couple of other
block-walls with 10, and the sum was too much.
--
croy
On Friday, October 23, 2020 at 6:31:26 PM UTC-5, croy wrote:
On Mon, 19 Oct 2020 04:57:24 -0700 (PDT), Ron Paii <ron8...@gmail.com> wrote:
On Thursday, October 15, 2020 at 9:08:34 PM UTC-5, croy wrote:Yes, but I'm not sure why you asked that. The button to open the photo in Irfanview works in
I have a "family photos" database that I put together years ago, under Access 2000. The main
form shows a view of the photo, in addition to other photo metadata. The photos are all .jpg,
and stored in a separate directory.
I had been running Windows 7 Pro until yesterday, and the database was working perfectly. Then
I "upgraded" to Windows 10, and now the database won't show the photos on the main form.
Everything else seems to work fine, even the button for opening the image in Irfanview. But it
won't show the photo on the main form.
If I open my filtering form, and put in something for criteria, I then get:
"Run-time error '2114':
Microsoft Access doesn't support the format of the file
'D:\Docs\Family\LFP_Quick\Small\2871-2.jpg,' or tile is too large. Try
converting the file to BMP or GIF format."
I don't think I buy that explanation.
I also have a laptop that came with Windows 10 Home, and I put the db on there, and it shows
the photos fine. The one difference between the two machines was that the desktop was running
Access 2002, while the laptop is running Access 2000.
So I uninstalled Access 2002 from the desktop, and installed 2000. No help!
So I copied the db from the laptop to the desktop--no help.
I thought the Windows build difference might be showing its hand, so I brought the laptop up to
the same build as the desktop, 2004, tried the db and it still works great on the laptop!
Internet searching hasn't helped (so far).
Has anyone here figured this out before me?
--
croy
Is the default jpg viewer the same on both computers?
either config. It's the photo image on the main form in Access that' not working under Windows
10 luser account, even tho it works on the same machine, but with my admin account.
Unless you're saying/thinking that Access is using the default jpg viewer to display the image
on the form. I always thought it was something built into Access.
For now, I've retreated from Windows 10, back to Windows 7. There were a couple of other
block-walls with 10, and the sum was too much.
--
croy
Access uses the default program for each file time to display images. Changing the default program may allow you to see the image. A clean install of Windows 10 may also solve your problem.
PS: Don't know if this would matter, but I was working on a new computer last weekend which only show icons not thumbnails in Windows Explorer. Found a view setting in folder options "Always show icons, never thumbnails" was checked. Un-checking solvedthe problem.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 72:47:22 |
Calls: | 6,657 |
Calls today: | 3 |
Files: | 12,203 |
Messages: | 5,332,378 |
Posted today: | 1 |