Ms Access Deployment All Versions- "mission Accomplished!"
Nov 7, 2007
my post at www.thescripts.com was deleted. It seems they don't really want a true deployment solution help to all ms access developer.
Ms access is a true king RAD DB frontend dev't. tool but the deployment of the finish apps are very unstable.
Sagekey is almost there, but I want to make a single EXE on my Access Apps that run even on the usb flash disk.
I have already found the solution, perfectly done! using one of the tools available in the web. but I will not post it again, I'm afraid this post will be deleted again... I hope this forum truly helps.
View Replies
ADVERTISEMENT
Aug 30, 2006
Hello everybody,
Some time ago I saw a presentation of access 2007. It got me very enthousiastic.
But before I start working with it I want to know if it is possible to deploy Stand alone applications I am gonna build in Access 2007?
And how???
Thanks for your help guys.
View 2 Replies
View Related
Aug 28, 2006
Hi all
Built an Access database using A2k3 but using the A2k format.
Having more or less completed the Database, I have tried it on several PC's that I have round the office here.
All works fine except for one form.
It works perfectly well on Access 2003 and also on Access 2000 version, but for some reason it wont work on on Access 2002.
I have added the screen shots. Anyone with any ideas?
View 1 Replies
View Related
Apr 2, 2007
Hi all, I have created a database for work in Access2003. I have two questions. The first is, many people at the work place use AC97 and some use AC2000. In order for everyone to use the database, i have saved it in AC97 format. It seems to open fine in Ver2000 and 2003, but i get this nag screen on load up with these versions saying "do you wish to convert the database". As I'm working off a shared drive, i don't really want anyone converting the dbase. Is there a way to disable this nag screen when loading in AC2000 and AC2003??
Second question, is it possible to have more than one instance of the database open at anytime? . If I've got the database open, my colleague can't open it. Its a simple database that writes records directly to a table. Thanks for any advice.
View 4 Replies
View Related
Mar 5, 2008
A few months ago I installed Office 2007 on my home PC and uninstalled Office 2003.
I am contemplating the re-installation of ACCESS 2003 on my home PC, but don't want to disturb my Office 2007 install.
QUESTION: Is it possible to have both versions of ACCESS (2003 & 2007) on my PC without creating problems for myself?
NOTE: I have two hard drives on my PC (C drive, the newer one; and E drive from my last PC). Perhaps I should install ACCESS 2003 on the E drive?
View 6 Replies
View Related
Dec 28, 2005
Hello,
I have two questions related to deplying an Access project I have been working on.
1. I started developing the project in Access 2000, but midway upgraded to Office 2003 and so the remainder of the project has been developed in Access 2003. Things seem to be fine, except that in the top most title bar, after the project name, there appears the following text:
xxxxx: Database (Access 2000 file format)
where xxxx is the name of the .mdb file.
Why is this appearing and should I have done something or do something to make it a Access 2003 format?
2. I am at the point of deplying the db to a small group of users (about 5). Some of them may have Access 2000 or Access 2002. Should I be doing something in particular to make sure things work in their machines.
Any pointers to what may be problems or what I should do will be much appreciated.
Thank you.
View 2 Replies
View Related
Jun 29, 2005
Hey Everone.
In the middle of building a DB system obviously for someone else. Is it possible to generate an email with the subject box & body filled in automatically.
e.g The button will say "Send Email", when clicked will generate an email with the subject box filled in with "Turmic Records....." and the body of the email filled in with "Thanks you for joining us...balblabla". You know what I mean.
Is this possible at all with Access. Has anyone ever generated any kind of emails from Access.
Please Help
Shane
View 1 Replies
View Related
Sep 18, 2005
Hello,
Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database.
Is this possible? and if so how?
Thanks--any help will be much appreciated.
View 6 Replies
View Related
Nov 28, 2006
Would having Microsoft Access 2002 and 2003 on my hard drive cause me to have error with my code?
View 4 Replies
View Related
Mar 7, 2008
Hi,
My office has updated to Microsoft Access 2007, but one of the third party softwares used requires a previous version of Access. A result of switching between the 3rd party software and Access 2007, is that 2007 installs every time.
Is there any work around to over come this problem?
Thanks,
Chander
View 2 Replies
View Related
Sep 18, 2005
Hello,
Is it possible to install two versions of MS Access on the same O.S. I already have Access97 installed. Now I want to install access 2003 without it up removing my previous access 97. If it removes/upgardes access 97 to access 2003 I will not be able to open my access 97 database.
Is this possible? and if so how?
Thanks--any help will be much appreciated.
View 1 Replies
View Related
Aug 26, 2005
I've been hired to clean up and convert a flat filemaker database into access 2003 and I've spent the last two weeks learning the ins and outs of access and doing preparations. Well, today some high up database guy in another department told me not to use access because in the future when a new version of access comes out we will have to recreate the database from scratch because there are lots of problems converting between versions. I'm aware there might be some hiccups but I don't really agree with him. Plus once the database is up and functioning I don't see why we'd even have to upgrade it to a new version. It's just a small health centre patient database with info about patients and their treatments. Does anyone have any opinions about this. Thanks.
View 3 Replies
View Related
Mar 16, 2006
Hi, this problem came out of nowhere but looks like it's here to stay.
Our Access app generates various Access Reports.
Recently we installed a new version of our access app and since that version onwards, all pc's with Office XP/2003 print reports in black & white. Printing to PDF works fine though.
We can't find the reason for this. Which mean we had to go to all our clients to downgrade them from office XP/2003 to 2000!
We use mainly Xerox and HP printers.
Thanks!
View 2 Replies
View Related
Dec 4, 2014
Is there a way to make access be able to store software versions and product keys automatically? Programs I am most interested in is like Microsoft Office suites and Adobe Acrobat and Photoshop and whatnot like that. I am not sure if this is even possible but I am trying to get my database fully functional with all the data and efficiency I can for at least 5 people so that I can try to sell access as a better tool than the service they are using now.
View 4 Replies
View Related
Jan 11, 2005
so i buckled down and bought the developer extensions. this has been very good, but there have been a few drawbacks.
drawback number 1:
when the user opens the program, they receive all sorts of security warnings. i can't turn this off from inside the deployed program, and i can't figure out how to turn it off on the development end. i know i just need to go into security and set the macro warning level to low, but it won't let me. the program has worked from here, but this is highly annoying.
drawback number 2:
i don't know how to have the users update the program without having them completely uninstall their current one and reinstall the new one. i know there's some kind of update key and product key (both of which i wrote down), but i don't know how to make an executable "update" program (kind of like the way video games update, with patches and whatnot).
drawback number 3:
in order to have the program connect to the server, i need to load the program first onto the server as an mdb, then use the developer extensions on there once i've relinked all the tables (i don't have an S: drive). is there any way that this can be done automatically (link to a drive that isn't on your local machine)?
feedback/suggestions to any of these are greatly appreciated.
View 14 Replies
View Related
Jul 4, 2005
Hi everyone,
I will have to deploy my access application that I have built with Access 2003 english version on an Access 2003 French version. I wondered whether there could be a problem because of the difference of the language?
Thanks for your response.
View 1 Replies
View Related
Nov 3, 2005
Greetings all,
I have a problem with my DB once it gets deployed. I include the Access runtime using the Deployment Wizard but when we install it and open the DB it give us "May contain harmfull Macron. Please install Jet engine 8.0" Then it continues on to say "the application may contain harmful macros do you wish to continue?" we say yes but still no luck. We updated the jet engine but no luck there either. The DB opens but some of the code that brings up pictures on the "on load" event, isn't working. It works on computers that have access installed but not on the Run-time installations. Any suggestions. You guys have helped so much in the past to get me this far in my Access career and this one needs answered quick.
Thanks,
Eric
View 5 Replies
View Related
Jul 31, 2006
Hi guys, I hope somebody can give me a quick step-by-step.
I've nearly completed a program written in Access and have started to venture into marketing the program to a local company. When asked what other modifications they would like to see i was sent an email stating;
"A major item would be to deploy in MS SQL. You should be able to do that free of charge with the low tier version of SQL."
I had a feeling this would come up, but I don't want to sound like a total idot when talking to these folks... I really have no true understanding of what they are asking, but I suspect it refers to conversion from jet. Question: Is this a reasonably easy modification? What do I need to purchase? Would I be better off telling them the program is 'as-is'? Can this be easily done by someone who has never done it before? I'm sure other threads addressed this issued but I would truly appreciate a full understanding of my specific problem. Thanks, Scott.
View 10 Replies
View Related
Jul 13, 2007
Hello,
I have finished a program with ACCESS 2007 (VBA) at work. Now, my boss wants his employees to use it from different computers. What would I have to do to make this work?? I suppose ACCESS has a runtime version or executable that I can install on every computer of the company? Or do I have to install ACCESS 2007 on every terminal (which would be very bad by the way)?? I would appreciate it if somebody would give me a hand on this since I have never done this before.
Thank you very much
PS: All the computers are on a network
View 1 Replies
View Related
Nov 2, 2005
I have Office 2000 Developer installed on my workstation at work and need to create an executable to deploy to other workstations that do not have MS Access. I'm using Access 2000 and the few that have the runtime installed already have Access 97 runtime.
When I execute the Package and Deployment Wizard I click on the checkbox for "Include Access Runtime". When it creates the package, however, the runtime is not included. I have verified that the runtime is on my hard drive. The CAB file is only about 10 Mb - the same size it was before I tried to create an executable that included the runtime module.
Any suggestions on what I am doing wrong? The size of the module created by including the runtime is not a concern at this time. I just need to get this application deployed for a mission-critical analysis task.
View 1 Replies
View Related
Dec 30, 2005
Hello,
I have followed the very informative postings here on security and deploying a multi user access application and have started doing that myself. A lot has worked but there are a few things that are not working out right and I just wanted to get some clarification on that. Hopefully this will benefit others in my situation as well.
1. First, I put security into the database by creating multiple users some with Admin and some with user priviledges.
2. I created a different workgroup file (product.mdw)
3. I then split the db to front and backend. I used UNC to nk tables from FE to BE
4. I put the BE on a shared network folder along with product.mdw. The reason is I am still developing the app and may also need to tweak the user permission settings, so thought of putting teh .mdw file on a server rather than putting it on each users machine for now. I am then using a shortcut on each user's machine that references this .mdw file on the server
5. I also have the FE on the server for now and created a shortcut on each user's desktop (I am doing this for now so that I donot need to put the FE on each users machine every time I change something. this is temporary for a few weeks till I finish development. After that I plan to put the FE on each user's machine)
The problem I am facing is that after putting the shortcut in a user's machine, if the user even wants to open any local Access db on their machine (not my app), it is now asking for a UID and passwd.
Now, when I put the shortcut on the user's desktop (to repeat, I referenced the FE, and .mdw file on the network folder in the shortcuts Target settting), should I have done anything else on the user's machine. After just putting the shortcut on the desktop, the user could click on it and go directly into my database without any UID and passwd though I have security in my db. The I went to the user's Access install and changed the workgroup file to the one on the network folder (through Tools - Security -Workgroup Info ...). Was that necessary because I had alsready put in all the necesary parameters in the shortcut's Target setting?
I guess I am missing someting about how the .mdw file associates with Access. When you define a .mdw file in the Tools - Security - Workgroup ,..) setting, does that associate with a particular DB or for any db that this Access install brings up? If so, then how does one get aorund the problem of deployment to user's desktop where the users could be having their own local Access DB's that they use without a password but need to use a password to access a DB on the network. I cannot imagine that because I require the user to use a password for my db on the network means that I have to tell them that they need to use a password for any DB they use in their machine from now on.
Please let me know where I am going wrong. Thank you
View 2 Replies
View Related
Jul 19, 2006
I've designed an access ade file (based on sql server) and distributed it at the network.
Somebody else has made another database (mdb) and placed the users in a access workgroup file by placing their windows logons into the workgroup file. These users happen to be the same users accessing my application. The following thing is happening : "when the users open my database they are prompted their user names and password of the workgroup file'.
I placed an empty database and the same thing is happening, the workgroup security is active alongside every database deployed to this specific user group.
How can I easily 'tell my database' it shouldn't make use of the workgroup security?
(It's odd that an ade which isn't able to use workgroup security prompts users by using workgroup security)
View 2 Replies
View Related
Jan 17, 2007
Hi
Apologies if this has been covered before - I promised I have searched and not found an answer.
I have just purchased the Access Development Extensions so that I can deploy my database's to users without Access. So far, I've managed to create an intallation file fine. Hwever, the database is to be used by multiple people and needs to be split.
If I create the runtime application of the frontend, all of the tables point to the backend on "my computer". I then need to give it to my client who will store the backend on thier server. How do I then make the front end (all locked becuase it's runtime) point to the backend in the new location?
I hope that makes sense.
I'm supposed to be installing this tomorrow, so any help would be much appreciated
Thanks
View 1 Replies
View Related
Nov 4, 2005
Should be a quick and easy question here... I'm getting close to splitting a DB. Back end mbd, front end mde. Searched the forum and a few other places. One subject didnt seem too clear... I developed the db in access 2002, a few of our computers are running 2003. Will I run into any problems with this setup??
Thanks
View 3 Replies
View Related
Mar 20, 2006
Hello, I wrote an access program using version 2000 and the activex calendar 11.0 which came with the software. When i tried to run the same program on access 2003 none of my dates worked and I got error messages all over the place. Help!
View 4 Replies
View Related
Jun 23, 2005
Hi I am trying to find the best way to synchronise several different versions of the one database, two of which are used by remote users so i can't really set one database on a central server, I am trying to come up with an as automated a process as possible as it will need to be done on a regular basis, has anyone any ideas??
it is a microsoft access 97 database
I will be updating it to a newer version as soon as possible
all help is greatly appreciated
Paddy
View 1 Replies
View Related
