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.
brihol44Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
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
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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.
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
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.
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
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.