Hi
Does anyone have a good easy sugestion on how to distribute a db with access runtime in a package to users without access 2003?
I have tried setup2go and it makes a fine .exe file.
But I can't make the package with access runtime.
Thanks
Mikael
Is it possible to distribute updates from the frontend to an access runtime version?
View 1 Replies View RelatedHi,
I want to distribute an Access database to users, some of whom may not have Access installed on their computers.
The database has been developed using Access 2003 and I was wondering how I can distribute the database as a runtime version to my users.
Any help will be much appreciated.
Thanks,
Harmonic
All -
I have just about finished up a Split DB that I plan on deploying in a LAN environment. The goal of course is to turn what looks like an Access Application now into a non-access looking application where the Front End can be distributed and run on any computer within the LAN.
I have several questions that I may need some help on.
How does one go about hiding the Access Shell and/or Ribbon/Nav in 2007?
How would I add a form that allows for a user to navigate to and connect to the back-end without having them check all of the appropiate tables and then browse to the back-end file if they have a different drive letter mapped to the location of the back-end files for example?
Any tips on how to sign the DB so the pesky Trust Center question can be bypassed?
Any other tips on how to simply distribute this for a LAN environment and/or make it look NOT like an Access DB with access to view the Forms, Tables, Queries, etc. This is my first Access DB project, let alone a LAN distributable one.
Thanks!
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.
We have two computers in a work group. On computer1 I have the back-end and front-end database files in the shared folder and 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the error message "Microsoft Access can't Find The Database 'C:Documents and SettingsAll UsersDocumentsdb.mdb' Make sure you entered the correct path and filename" On computer2 I have the front-end database files in the shared folder and pointing to the same back-end database on computer1. Again 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the same error described above.
I expect that this is some sort of windows permissions issue?
There are some clues to this fact ..
The two users that can't access the database are limited accounts, but I tried making them administrators and this had no affect.
Their shared documents folder does not have a hand underneath it?
Any help on this appreciated as it's really starting to annoy me now!
Thanks.
Hi,
I saw many posts in here. Most of the posts are said that we need to use Access Developer Edition to distribute the Access Runtime for our clients.
Can we just buy/use the Access RunTime Modules and unlimited licenses without using Access Developer Edition?
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
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.
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?
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?
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?
Hi my friends...
I need help..
I have program compiled in Access 97 runtime installed on my Windows XP computer.
When I installed this program on account TOM (Administrator) then program run and work great.
When i changed privileges for TOM (not be admin anymore) to restriction account then i have problem witch this program
URL
Program still working, but if I want to use some function in this program i have this error:
URL
I don't know why ?
In installation folder, and c:program filesMicrosoft Office Runtime 97 and c:windowssystem32 user TOM have ALL rights.
Can anybody help me ?
Sorry for my English,, i still learn it.
Best regards for all
I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server situation as it impacts on the various links I have set up within the database to files etc that are part of the program but are external such as Excel, Word files. The current links are all set up as C:MainFolderNameFilename. Of course these all stop working when I place it on a server and link the users up via shortcuts. On our own installation I changed the links to the \MyServerMainFolderNameFilename format and everythings fine but due to the number of links this is a fairly lengthy process and I wouldn't want to have to repeat it at every clients installation.
Can any one please advise me if there is a way to set it up so that I could say enter the clients server name in a field. Then insert that field's contents into the pathway details for the links so that they all update automatically.
Your assistance would be greatly appreciated.
Hi, I have a large database containing information that people all over the country want to access. I've designed a main form that contains 3 subforms that queries information from raw data. Now that the database is complete, i'm looking for the best way to distribute it. I've tried to put it on the network drive, but it has been rediculoursly slow. Could somebody tell me what would be the best way to do this? Thanks!
View 1 Replies View RelatedI am developing an application in access xp (2002) and want to distribute it as a runtime application. I do not have the Office xp Developer version and thus need to buy the MS Office Developer. It is still available and if so, where can I buy it? Or can the Visual Studio Tools for the MS Office System make a runtime version from access 2002?
Any help would be appreciated.
Niels
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,
Hello all,
I have recently finished developing a Complaints Database for my company and we carried out some testing on machines that use runtime only and guess what? Good old runtime errors!
I aksed the IT department to give me a brand new blank login profile and when I used this, the database worked perfectly under the runtime environment. This tells me that the runtime on users machines that have worked here for some time, something has changed with the way in which runtime works.
What I would like to try and do is for these machines, when the database loads up, to re-install or re-configure Access runtime so it is effectively a clean Runtime slate for want of a better expression.
Does anyone know how I could do this or possibly even offer any assistance in another way. My understanding of runtime is that it has most of the Access capabilities but obviously without design, build, debug functions etc and is purely a 'cloak' to allow the mdb file to be viewed/executed.
Thanks folks.
Gareth
We are considering rolling out a number of access reports to users within our organisation who currently do not have access installed, nor do we want them to. Run time seems the obvious route.
I see the runtime module is included in Access 2003 but I cant see if you have to install Access on the users PC in a "Runtime mode only" way or if the Developer tools have to be purchased to get the package wizard so you can send the package out with run time.
Basically we want users to be able to access the database from the server but we do not want them to have the ability to do any thing else in access . i know read only rights will enable that to be done in the particular database but we don't want them building their own db's and the bothering IT when they come across something difficult....
Thanks
I created an Access Runtime Database Download on Windows XP. One of my clients downloaded the db to Windows Vista. The installation went fine and he was able to populate the database with no problem. However, now he needs to send me back the data and we cannot seem to access any data files. The backend.mdb file appears to be blank, even know the data appears on the front end. We have tried searching the computer to find any hidden files it might be saving the data to and there doesn't appear to be any. I have tried copying the entire folder containing both the frontend and the backend to a jump drive and looking at the data on a different computer and it appears to be blank. This doesn't seem to happen on any other OS. Since it is a runtime version of Access, I am not able to export any files or even view anything of administrative value within the DB. When I look at the backend.mdb in Explorer, the modified date is old, so it doesn't seem to be adding the data to the backend, even though it is theoretically linked to it. Does anyone know where this data might reside or of a workaround of how to extract this data???
Thanks,
Shelley
I created the database on my computer. I added security and split the database to put the tables on the the server. Everything works just fine on my computer. However, when I try to copy the 3 files for the front end of the database to other computers on the network, it won't work.
Perhaps I'm confused as to what files need to be migrated to each additional computer or I don't have the security setup properly.
Right now, I move 3 files. The main database file with the front end. The shortcut file that is created when you add security and the security file that is created when you add security to the database.
I'm stumped.
I have a Query with many part numbers in column A and their inventory location(s) listed in column B. However, some part numbers are listed 2 or 3 times because the item is located in multiple inventory locations. How can I take these items and put list their inventory locations in multiple columns across one row?
What I have:
ITEM# Quantity INVENTORYLOCATION
A1 5 Warehouse 1
A2 3 Warehouse 1
A2 6 Warehouse 2
A3 2 Warehouse 1
What I want:
ITEM# INVENTORYLOCATION Quantity 1 INVENTORYLOCATION 2 Quantity 2
A1 Warehouse 1 5
A2 Warehouse 1 3 Warehouse 2 6
A3 Warehouse 1 2
Hello to everyone.
I am reading this forum for a while now and I learned here almost everything I know. But, now i am having problem and I really don't know how to solve it. I am trying to test some little program which I made fo my company. It is Access 2000 database and I made it with Access 2003. Everything is working 100% in Access 2003. BUT, problem is that this database will be run on several mashines in two of our companies and in that other company they have a lot of computers with Win98 installed. I have Access 2003 Developer and I managed to make deployment for computers in my resident company, but, as you probably know, Access 2003 is not working on Win98 computers.
So, I tried to install Access 2000 Runtime on those computers and I am still trying because stupid installation won't finish! It just stops when it comes almost to the end of instalation and nothing happens. I tried to wait for some time but instalation is dead. I also tried to make clean instalation of Win98, but nothing changed. There is no Access on those computers of any kind.
I tried to search forum for solution, but I didn't find it.
Please, help me!
Gile2004
Access 2003
I have been writing databases for several years now, so I know my way around access pretty good. I have come upon a strange error though. which is confusing me to now end. I wrote a Database on my work machine which has the latest version of MS Access and SP2 for Office. I just tried to send it to another employee for them to test. Now they do not have the full version of MS Access installed on their machine, they only have the runtime version which only runs the Database. The load works fine and the first screen uses ADO to lookup some value and display them in a list box, nothing crazy, everything works fine. Now using this form, when they click a button the info in the list box is used to set the Fields a new Unbound form. And this is where the error happens. The on_load event of the form fails for some reason, and gives a msgbox which says, "Runtime error occured and the App needs to close", but the prog works fine on my machine. I am baffled. The file is a MS Access 2000 format, I tried changing it to MS Access 2002/2003 Format, and when I do that they cannot open the file because it says they do not have thje latest MS Access version. I have no idea what, why the error occurs, any ideas??
View 1 Replies View Relatedhttp://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
Hi,
I have packaged my Access 2000 program using SageKey. When I open the installed runtime version of the database, and click on a menu button that performs a databse backup, there is no error, yet the file does not copy (note that I am using a function that utilises apiCopyFile). It does not do this in the full Access version where I have developed the program. Does anyone have any idea why it is doing this? And any suggestions to how I could fix this or change my approach?
Cheers
Tania