Error 2114 Under Windows 10

[croy]

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

[croy]

On Thu, 15 Oct 2020 19:08:24 -0700, croy <cr...@spam.invalid.net> wrote:

One more experiment:

On the desktop machine, if I boot into my admin account, the db works great.

If I boot into my luser account, and start Access with admin permissions, and then open the db,
it doesn't display the photos.

Hmmm.

--
croy

[Ron Weiner]

croy formulated the question :

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

--
This email has been checked for viruses by AVG.
https://www.avg.com

[Ron Weiner]

After serious thinking Ron Weiner wrote :

Wow Many typos in my reply. I ment Win 7 and Files(s)

[croy]

On Fri, 16 Oct 2020 09:34:22 -0400, Ron Weiner <r...@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.

--
croy

[Neil]

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.

--
best regards,

Neil

[croy]

On Fri, 16 Oct 2020 12:00:16 -0400, Neil <ne...@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.

--
croy

[Neil]

Did you try the repair option in Access?

--
best regards,

Neil

[croy]

On Fri, 16 Oct 2020 14:12:16 -0400, Neil <ne...@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.

--
croy

[Neil]

Even more curious...how did you set up your laptop on Win10 without a
user account (even admin accounts are "users")? That would imply that
your laptop's account is an administrative account.

Does the laptop have a "D:\..." drive? You probably took a close look at
the form in design mode to see where it looks for the photos, but if
not, try it.

--
best regards,

Neil

[Ron Paii]

Is the default jpg viewer the same on both computers?

[croy]

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

[Ron Paii]

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 solved the problem.

[croy]

Thanks Ron, I didn't know that. That's even for images on an Access form, right?

>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 solved the problem.

I've never allowed any of my various Windows versions to show thumbnails, so I don't think
that's a factor in this problem.

--
croy