Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4049
  • Last Modified:

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.
0
brihol44
Asked:
brihol44
  • 3
  • 3
  • 2
1 Solution
 
Kelvin SparksCommented:
I'm guessing here, but I suspect you have code that runs on startup. You need to tell the runtime that the folder it is in is a trusted location before that code will run. I'm not sure however, how you do that for a runtime. This EE article may help
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22900290.html?sfQueryTermInfo=1+2007+locat+runtim+trust
 
Kelvin
0
 
brihol44Author Commented:
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
0
 
Kelvin SparksCommented:
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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
peter57rCommented:
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.
0
 
brihol44Author Commented:
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
0
 
peter57rCommented:
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.
0
 
brihol44Author Commented:
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
0
 
Kelvin SparksCommented:
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
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now