asked on

When I try to open my .accdb file in Access Runtime it won't load....

Hello, When I run my .accdb file with Access Runtime it doesn't do anything. The Runtime will open but nothing happens it just sits there without the file opening. I've tried it on three computers now. I'm using the trial version of MS Office but I'm only using it to find out if I can do what I need to with just the Access Runtime and I'll buy the software. Anyways, I'm not sure if that's it or not.

ASKER CERTIFIED SOLUTION

Kelvin Sparks

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

brihol44

ASKER

Hello,

The form I'm trying to setup was intended for Non-Savvy Computer people in remote areas who don't own Access. It looks like they will have to do several things in Regedit. I just wanted them to click on the form and enter information. Geez if I knew this I wouldn't have used Access :( ... Oh well... I guess I'm back to the drawing board.

B

Kelvin Sparks

In that case, I assume you'll be packaging it. I'd strongly recommend you look at Sagekey's packaging products for Access (www.Sagekey.com). Their's will deal with that for you as part of the install, I'm not sure (but doubt it) that the MS installer package will.

Kelvin

peter57r

Please bear in mind that all of Office2007 is based on Trusted folders, not just Access.

Code in anything you distribute to an Office2007 user will not run automatically unless the security aspects are dealt with in one way or another.

brihol44

ASKER

I believe OpenOffice might be a better choice then. It looks like I won't have to deal with any of this with it. Please keep in mind. These users using this form are basic computer users. I can't have them going through 10 steps or editing the RegEdit file or whatever I saw as a solution to get the form going. The SageKey software will cost 650.00 it looks like. My project estimate is only 275.00 for a form.

So I wouldn't be able to create a UserForm in excel as well? I can't simply have a VB form created and it just feeds the information into the .XLS file? The user would probably have to have Excel I take it?

Thanks,

B

peter57r

Are you sure you have the latest service release for the run-time?
I haven't used it myself, but I thought that MS had said that the run-time installer now set up the required trusted folder.

brihol44

ASKER

Thanks Peter,

This is where I downloaded the run-time...

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

I believe it's the latest run-time installer.

Thanks again,

B

Kelvin Sparks

You need to look at the developer extensions
http://www.microsoft.com/downloads/details.aspx?FamilyID=D96A8358-ECE4-4BEE-A844-F81856DCEB67&displaylang=en#Overview
These include an installer package which, as Peter said, may well manage the trusted location setup. I haven't used the 2007 version, so cannot say for sure.

Kelvin