.accdr won't open

[JoeM]

I can download it tonight, if no one solves it before then.

[merlin777]

magic - thanks!

[ItsMe]

magic - thanks!

Joe said he would take a look at your DB for you. Did you already resolve the issue?

[merlin777]

no - still stumped

[JoeM]

I downloaded it to my computer, changed the extension to accdr, and tried opening it, and it opened up fine without any issues.

The odd thing is when I open the accdb, I get a message that certain content may be disabled (the standard warning we get with VBA or macros), but I do not see any macros or VBA anywhere in the project.

[alansidman]

I downloaded your file. Changed it to an .accdr file and was able to open with out issue. I could not replicate your problem. Prior to changing the name, I opened it as an Access File. There was no VBA nor macros associated with the file. It opened normally.

[merlin777]

hmmnn. Do i need runtime installed? I thought .accdrs still opened in full access but in runtime mode.

[merlin777]

i opened it on a different pc (w7, 2007) as an accdb and it opened with a security warning. Then i tried as an accdr and it also opened with a security warning.

I can't say why i don't get the warning on my vista machine in runtime mode but it might explain why it opens and immediately closes again.

As I dont have any code or vba in it I'm still stumped.

[JoeM]

FWIW, I do not have the run-time app on my machine, and it runs fine.

I see you mentioned "Vista", and I grimaced a bit. That was a notoriously buggy release, and it is a bit old and out-dated at this point, so I wonder if that is where your problem lies.

[merlin777]

i think i might also suspect vista but i spent a lot of time using access successfully on this machine about 6 months ago.

[ItsMe]

It seems reasonable to suspect Vista is not handling a "Trusted Location" thing properly. FWIW, I use accdr with full versions of Access to test Run Time environment all of the time.

[merlin777]

sorted! Turned out to need 'trusted locations' set.

[alansidman]

For future reference Boyd has a good tutorial. Look here.

http://www.hitechcoach.com/ and scroll down.

[merlin777]

setting a trusted location works for local files but when i try to set a network location on my nas (where i want to keep the file) i get an error: "The path you have entered cannot be used as a Trusted Location for security reasons."
any ideas what i need to do?

[ItsMe]

What I do is edit the registry of the client. You can incorporate the code within your application or run the code separately via the attached example (from the client machine). If you use the attached example to include subfolders, use the trailing \ in your description of the path. The instructions say not to include it, but do include it if you are using the subfolder option. At least I remember this to be a bug because I sometimes use the example, as is.