2007 Runtime Installation
Oct 26, 2007
I have packaged a 2007 db on a 2003 server. The db contains autoexec macro which:
a. opens a query,
b. opens a form with cmd button that returns a msgbox
c. Runcode a function that calls a subroutine to return a msgbox.
Everything runs fine on server since that's where the real 2007 install is.
On my pc I have xp2 and one install of access 97( don't ask) along with office 2003 installs(excel etc, etc).
I installed access 2007 runtime on my pc.
I copied the package from the server to my pc and did install. When db finally opens the query runs, the form opens but fails on the runcode. The code behind the cmd button returns nothing. This tells me that on vb was included with the db when it was packaged or I don't have rights to run it? Either why how can I resolve this issue as info on subject is nill.
View Replies
ADVERTISEMENT
Apr 12, 2006
Hello,
I have a question about Access runtime. We have some users at work who don't have Access on their machines, but we would like them to be able to use databases we have created. My suggestion was to purchase Visual Studio Tools for Office, which will give us Access Developer Extensions and allow us to distribute runtime versions of our databases.
However, the pcs here at work are pretty well tied down in terms of installing anything. E.g. no registry changes are allowed, unless you are an administrator.
So my question is - what is actually involved in installing the Access Runtime. Can it be achieved simply by copying the relevant files (ACCESSRT.* ?) into the office directory, or is there more to it than that. Will I be able to get my databases up and running myself, or is it likely that I will need the help of the Technology Department to get the Runtime installed ?
Thanks for any advice,
View 3 Replies
View Related
Jul 23, 2007
I was hoping all the errors had been addressed in the current Runtime release..... But no. If you have a previous version of Access ...2002 for example... And load the 2007 Runtime, your applications developed in 2002 will run fine in 2007 runtime. BUT.... If you open them in 2002 you receive many errors. "onClick" errors that don't exist. So if you do not have the full version of 2007 on the computer you would need to uninstall the runtime to be able to make any changes in your app.In short.... your going to screw up anyones ability to work with a previous version if you install 2007 runtime.I will try this on another computer with Access 2003 to see if it gives the same errors after runtime install. I'll post results.OK.... After trying the Runtime on another computer with Access 2003 it appears to be OK. The problem still persist with Access XP (2002). They simply do not play well together. I guess Microsoft did not feel this was important enough of a problem to address. So, if you load a Runtime of 2007 on a machine running Access 2002 you will no longer be able to use 2002.
View 1 Replies
View Related
Feb 7, 2007
http://blogs.msdn.com/clintcovington/archive/2007/01/30/the-runtime-and-developer-extensions-will-be-free.aspx
According to Clint Covington, Microsoft intends to release the runtime and developer extensions for free.
My opinion is that it should ALWAYS have been free instead of slapping us Access developers with an extra cost so our users don't need to pay hundreds of dollars more to use our applications. I can't think of ANY other development environment that has this drawback.
SHADOW
View 2 Replies
View Related
Jun 25, 2007
Access 2007 Download: Access Developer Extensions:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D96A8358-ECE4-4BEE-A844-F81856DCEB67&displaylang=en
Access 2007 Download: Access Runtime:
http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en
Enjoy!
:)
--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
View 11 Replies
View Related
Oct 2, 2007
How in the world do I add a trusted location with only the Runtime version of Access 2007 installed on the PC?
I am in the process of distributing some new runtime-only applications; how do I stop the irritating "potential security risk" warning from coming up everytime the user logs in??? I can't figure out how to get to the "trust center" with only Access Runtime installed. Users don't have any other 2007 applications like Word or Excel either, and are running Windows XP, NOT Vista.
View 14 Replies
View Related
Nov 26, 2007
I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features.
Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing!
Help!
I do have Runtime 2002 (XP) on the same PC, is that relevant?
View 10 Replies
View Related
Feb 20, 2008
I am having a problem running Access 2007 runtime on a workstation. I have set up the 2007 database (.accdb) on our server and am able to connect to it and open it from the pc that has Access 2007 full version installed and it works fine.
I also installed Access 2007 runtime on another PC and was able to open the database using the runtime version just fine.
However, on this other PC, I installed the runtime version, and when I use the command line (msaccess.exe /runtime \serverdirectorydatabase.accdb) to open the database in runtime mode, Access opens for a split second and then closes immediately.
When I just run msaccess.exe, it opens the runtime version and says that I have not specified a database, as expected. So, I am wondering why it is not opening the database when i DO specifiy the database.
If i specify an incorrect directory for the database, it opens the runtime version and a dialog appears telling me that a database was not found, and upon clicking OK, the program closes.
I can say, that when I run it off the computer that works through the runtime version, I get a security warning telling me that there are potentially unsafe elements in the database, but i just have to click OPEN and it still opens it fine.
Perhaps the non-working PC is denying it access due to these security issues?
I can't seem to figure this out, and any help is appreciated.
View 8 Replies
View Related
Jan 8, 2013
I am making my very first tentative steps to convert my most complex Access 2003 app to run under Access 2007. There are no obvious problems when simply opening my original MDB file in Access 2007 or running it after conversion to an ACCDB file. However, when I try to run the ACCDB file under the Access 2007 Runtime I get a "You can't carry out this action at the present time..." error. This is then followed by the "Execution of this application has stopped due to a runtime error..."
To be more specific, I only get that error when I deliberately hide the back end database and thus invoke code triggered via Autoexec to allow the user to browse for the missing database. This code works fine when running under normal Access 2007 so it appears to be a Runtime issue.
View 3 Replies
View Related
Jan 29, 2007
Hello,
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.
How can I do to solve this?
Thanks.
View 1 Replies
View Related
Oct 8, 2004
Is there an aplication like "Install Shield" that I can use to install my application for installation on the users computer?
Thanks in advance - John
View 1 Replies
View Related
Nov 21, 2007
Hi,
a colleague of mine has Office 2000 installed on her work PC in order to carry out Access datadase responsibilities (amongst other things) as part of her job.
I think (though I cannot be sure) that someone has 'locked down' the copy of Access to such a point that shift bypass no longer works, F11 does not display the database window etc. This is strange because our company generally does a default install of Office and leaves most everything configured as standard.
In short, I need to access the Tools menu to set startup screen options and customize some of other options for her. Obviously I can't.
Will this problem require a complete Office re-install or is there a way to undo someone elses changes and set Access back to 'wide-open' ??
Thanks
Sausagefingers
View 5 Replies
View Related
Jul 8, 2005
I am using the Packaging Wizard of the MS Office Access 2003 Developer Extensions. I would like to change the Root Installation folder to a customer Folder. However, I am limited to the list given (Program Files, Documents & Settings, etc..). I even tried to see if I could change the INI files produced by the package, but could not find any reference to the root installation folder. Does anyone know how to change this, either through the wizard or manually.
I know I can have the user move the folder once the install is complete, but I do not with to do this.
View 4 Replies
View Related
Feb 8, 2006
I have a db with more than 100 forms, reports - objects. My backend tables are linked sybase tables. What is the best way to hand this over to the users?
1. I want to create a mde version (which is not working, here's my problem :mad: Failure In Creating MDE File (http://www.access-programmers.co.uk/forums/showthread.php?t=94465)
2. I want a way to send this application to the user, in order that is installs on their desktop or a location i specify on the user's drive. I have no clue how to accomplish this, but i know that when i download some applications they do end up on my desktop :rolleyes: , so they must have done it somehow. Please help?
3. I want to have a master mdb hidden on the network somewhere, and when i make changes to that (e.g. my form or reports). And the next time the user goes into the version installed on their drive, it checks for the last version of the front end, and if that's not it, it erases the old one they have and installs my new version for them automatically. I know this can be done. Can you help me?
I'd really appreciate if anyone can help me please in any way. Advice, links, tutorial, whatever. Many blessings will come to you!
Ghudson! Before you attack me, i've done a search on the forum and though i've seen some posts, i can't seem to find one best for my means :) Thanks!
View 3 Replies
View Related
Mar 21, 2008
On trying to import an Excel 2007 file into Access 2007 I get the following:
1) Choose "External Data," Import, Exce
2) Select small file in MS Excel 2007 format.
3) Click on Import the source data into a new table ...
4) Choose OK
Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.
Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.
Event Viewer gives following message, which is of no help:
"ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."
Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.
I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.
I have turned off DEP.
How can I get MS Access 2007 to import Excel?
Thanks
Ken
View 6 Replies
View Related
Aug 11, 2007
Hi,
The company have MS Access 2003, Office XP Professional with Front Page, and Office XP Developer. But, we don't have license on Office XP Professional with front page, others have license.
I installed MS Access 2003, and Office Xp Developer on my company machine,
when I use Office XP Developer to create the package/access runtime for my clients, it must refer to Office XP Professional with front page to create Access Runtime. But, I don't have license for Office XP with front page, whereas I have license for Office XP Developer.
So, after I finished creating the package,
Is the Access Runtime legal in rules distribute to my clients using?
View 1 Replies
View Related
Jul 13, 2005
Hi All,
Just a quick one.
I have access 2003 installed, which I use to make systems ( doh )
Anyway, I have just installed Access Runtime on the same machine so that I can test my databases on the runtime version to make sure that all works ok.
However, I have installed several times now, but I can not find runtime anywhere to run it...
Can you not use runtime if you have full blown access installed ?
Or am i just having a blonde moment ???
Thanks in advance.
Max
View 3 Replies
View Related
Jul 30, 2005
Hi there,
I'm using the FILECOPY command to copy a specific file on the C drive to a CD.
I have been testing this for ages and it's been working fine. All of a sudden, I am getting a runtime 75 error. WHY???
Thanks in advance,
Paul.
View 1 Replies
View Related
Sep 19, 2005
How and Where can I get the Access Runtime ? (as I want to distribute my application to other users who do not have Access installed). :confused:
I'm using Access 2003.
Thanks.
View 1 Replies
View Related
Mar 30, 2006
I have an application developed in Access 2000. Can anybody help with my search for the access runtime licence so that I can distribute to many users (who may not have access)? I have been told I need Visual Tool Extensions for Office but cant get an evaluation to check it works with my app.
OR, does anybody know a source (cheap obviously) of MS Access 2000 - users who dont have access only need 2000 to run this app.
Any help greatly appreciated!
View 1 Replies
View Related
Oct 18, 2006
Hi all.
I have problem with form for viewing pictures. If I use apllication using full MS Access I haven't any problem. I can see BMP, JPG, GIF ... But if I open appllication using runtime I cannot open JPG file. Runtime show error to transfer picture to GIF or BMP. Where is the problem?
View 3 Replies
View Related
Feb 4, 2007
I have MS Access 2002 version, I create one mdb file and then put it on the sharing drive, I install Access RunTime on my client machines, they can run the mdb file on the sharing drive.
Another way,
I used Office XP Developer Edtion to create package and then install the package on my client machines, they can run the mdb file.
Here is a question,
Why do we need Office XP Developer Edition to create the package? Because we just install Access Runtime on the client machines, then they can run the mdb files.
What is advantage of creating the package?
View 1 Replies
View Related
Feb 13, 2007
Hi Everyone
Ive created a database using the file system object that creates folders, moves files from one folder to another, etc.
This works perfectly on my home pc, but when i try to install it on the server at work I get the following error message:-
Runtime Error 429
Active X component can't create object
I've had a look on the net and appears that it only happens on certain computers and I wondered if anyone had any quick fixes that they had come across over the years.
Thanks in anticipation
Kindest regards
Tony
View 2 Replies
View Related
Feb 16, 2007
So I made a little db using A2k3 to use @ work. We have OpenOffice.org 2.0 @ work and not MS Office. Since I knew Access better than OO's db program, I used it and was going to just take it in and use it after it was finished. Well, I didn't realize that unlike OO's Word, PowerPoint and Excel versions, it's Access version does NOT open it's MS equivalent - Access db's. It'll link to them and use data, but all tables, forms, reports, etc have to be designed in the OO environment. Geez!! So I looked @ getting the Access Runtime. It's a bit expensive from what I read (about $200 if I read correctly). I have a couple questions. First, is it really that expensive? Second, is there another solution to this problem? Third, I read that the 2007 runtime may be free. Is that so? If so, will it work backwards - with a 2003 db? Thank you, thank you, thank you.
View 1 Replies
View Related
Mar 6, 2007
Hi,
if I don't buy office Developer software, I just download Access Runtime 2002 from the Microsoft website, and then install it on the client machines. Do I commit the company rules? Do I need to buy unlimited license for Access Runtime before installing?
View 1 Replies
View Related
Apr 4, 2007
Hi,
I have full version MS Access, and Office Developer Edition to disribute the Access RunTime for my clients.
I don't want to create the package (adp file), I just want to create the package for Access RunTime, and then install it into my client machines, we want to run the same adp file on the network sharing drive. Then, it's fine. But, how do I install the supported files into my client machines? Because the supported files attached to the package (adp file), if we install adp file into the client machine, it will install adp file and the supported files, but we don't want to install adp file, we just want to install supported files.
How should I do?
View 1 Replies
View Related
