Custom Installer Of Database?
Aug 18, 2007
I'm looking at creating an automated system to install the database. I know that with the access developer kit it includes an installer package creator, however it doesn't have some features I'm after.
Basically, I want it to obviously copy the database file into a folder (that the user specifies) and create a shortcut if the user specifies to the desktop and/or start menu. But then there is a back end, so I want the option to specify if the machine it is being installed on will be hosting the backend or not.
Then it needs to install access runtime as well, then copy a DLL file and .bas file into the same directory as the front end, then copy a DLL file into a system folder and then register that DLL file within windows.
Do I need to create a separate program all together, or is there something that'll allow me to do this?
Thanks very much
View Replies
ADVERTISEMENT
Jun 24, 2007
My DB has around 20 users and frontend is on local machines and back-end on server. I always copy front end and many batch files associated with db and paste them onto local machines. Then create a link and paste on desktop. I always make a folder name "DMSS" and pase all copies files in that. But frequently becuase of one or other problem, I need to do this exercise again on many PCs.
Now I want to make an installer CD like we buy for softwares, which on running will do all this work.
Can somebody guide me to the right direction?
View 3 Replies
View Related
Aug 28, 2005
Hello,
I have a roof-estimating program that I made in MS access 97. I want to sell it to online. However the buyer will have to have access 97 installed on their computer to be able to use my program. Is there a way to allow users to use my program with out them having access 97 installed on there computer? And if so how involved is it to make this work?
I’ve been reading about the access developer’s extensions for access that makes a run time version of an access program. Will this work in my situation. I’m using access 97. I've seen some web sites with run time installers. Do these programs really work like they say?
Will I need to re-write my program? And if I do need to re-write it, is there a certain way that it needs to be written in order for this to work.
Please Help
Thanks Chuck patentinv@sbcglobal.net
View 6 Replies
View Related
Jul 21, 2007
After hard work done, my system become ready. Now I want to deploy it in the clients computers. What is the best installation software my system files from the CD disk into the user computer?
Thanks Very Much
View 1 Replies
View Related
Aug 28, 2007
Hello there,
I use access 2000 but also have access 2003 installed on my computer. Access 2000 is my default version and is usually what I use 90% of the time (for various reasons).
Anyways, every time I launch 2000 (without going into 20003 at all) it ALWAYS brings up windows installer. Is there a way to fix this or must I live with it since I have 2 versions installed?
Thanks!
View 2 Replies
View Related
Jul 2, 2007
Hi all,I'm in a bit of a dilemma here. We currently have an mdb which includes a form and 4 tables. The entire mdb is around 800 megs. What we used to do is distribute this mdb to users in completely different locations on a CD, but now it has become to large for a cd to hold. Our manager wants us to figure out a way to distribute this mdb using only 1 cd, without zipping it. How would i go about doing that? Is there currently an installer, that can download the database from our ftp site and then insert the tables, or is there any other easier way i can get this done? P.s. The database will likely get larger and larger every yearThanks in advance
View 14 Replies
View Related
Nov 23, 2004
I am sure this has been asked before but i have searched and found nothing,
I have 2 versions of Access on my PC 97 and 2000, if i use the chart facility i always get a box appear saying windows intaller and then goes on to ask me to insert a certain disk from the office package.
but if i click cancel quick enough it bypasses the enter disk part..
how can i overcome this please.
View 2 Replies
View Related
Oct 17, 2014
Creating and installing a custom icon for my database but I'm still seeing the access icon. I've done these things:
-I made a 32x32 bitmap in photoshop.
-I saved it in the same folder as my database.
-I opened access 2007 with my database
-I went to access options/current database/application options/application icon and browsed for my bitmap.
-Clicked on use as form and report icon.
-Closed everything and reopened my database.
I couldn't see my icon anywhere in explorer, access or my desktop shortcut for my database.I repeated all this except I put the bitmap into an online icon creator and downloaded an .icon for win vista and win 7 which I selected as above.
View 3 Replies
View Related
Nov 28, 2012
I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
View 1 Replies
View Related
May 24, 2014
I am creating a Machinery database to match parts up with equipment. So they can see what the Equipment is and all the available parts. The sort needs to be like this
First Sort:
If the manufacturer of the machine is the same as the manufacturer of the part sort that at top then sort alphabetical
Is this possible? Each equipment would have a different manufacturer so I can not do some type of hard coding.
View 1 Replies
View Related
Mar 29, 2006
HI all, I have recently created my own custom toolbar for my database which works fine on my computer, but when the database is transfered to another computer via a memory stick (needs to be done as it is going to be used on remote laptops away from the main network), the custom toolbar does not carry over. Instead of the custom toolbar being shown, the normal, main toolbars are reset to the default ones shown.
Is there a way of stopping the toolbars reseting when transfering the database so that my custom toolbar is the default toolbar?
Thanks for the help!
View 1 Replies
View Related
Jul 13, 2006
I have a custom toolbar in my application. However, it isn't visible at the top of the application window and when I try to make it so - via View - Toolbars - it doesn't appear on the list of available bars.
I had assumed that I had somehow deleted it, but I know it's still present somewhere, as when I try to recreate it, I get a message saying so.
How can I get the toolbar to be displayed? :confused:
View 8 Replies
View Related
Jan 1, 2007
I have a database for call outs, i had a problem with double booking, but cured that, my problem now is every time my work mates try to book me in that go into the debug box (accidently) all i need is a ok button only msgbox to say the time is already booked. can anyone plaease help.
here is my db if any one want to have a look
View 2 Replies
View Related
Feb 13, 2007
Hi all. I have tried searches on here and via google but can't find a difinitive answer to my question. What i would like to do is create a custom help file that will run when the user requests it. I know there is a property option to set a custom help file within a form but i am unsure of the correct process to do this to get it working.
Could someone please help me understand what needs to be done.
Thanks in advance.
View 2 Replies
View Related
Mar 6, 2007
Hi folks:
when I create a custom toolbar on my db, would that custom toolbar be carried to other copies of my db? I'm hiding all toolbars using code and I need to display only one.
thanks
View 1 Replies
View Related
Oct 25, 2007
Since the introduction of 2003 when you create a custom menu you always get the 'Type in a question for help' tag and the min max close buttons. Is there any way of removing them or disabling them?
:confused:
View 1 Replies
View Related
Jun 17, 2006
I would like to create a custom autonumber to use as my primary key in one of my tables in my database.
I would like my records to be displayed as such C000001 , C000002 and so forth. Does anyone know how todo this?
Thanks in advance.
View 1 Replies
View Related
Jul 31, 2006
Hello, I am trying to set up a relatively simple relationship between numeric fields in two (already related) tables. The problem is Access doesn't really support this type of relationship... or in fact, doesn't have an interface for coding your own custom relationships (if it had one, this would be ridiculously easy).
But it doesn't. So I have to turn to you.
To explain my problem better, I'll use a visual aid.
http://img269.imageshack.us/img269/9123/db1zx2.jpg
My two tables are as follows, the master is called [Raw Materials] and details is called [Raw Materials Details] (the aptly named).
I guess I should rename the [Raw Materials].[Stock] to something else (as this isn't REALLY data redundancy). But anyway, what I want to do is have the [Raw Materials].[Stock] automatically equal to Sum(Stock) FROM [Raw Materials Details].[Stock]. To rephrase, I want the Total Stock field to be automatically equal the sum of corresponding stocks.
Either way, I have no idea how to go about doing this. Can anyone point me in the right direction?
View 14 Replies
View Related
Aug 27, 2005
Hi all,
I cant make work, a query with creteria filled within controls of a form. I will be more specific to make u understand what i want to ask.
There are 2 text fields and 2 combo boxes. All of them call a report (by pressing a button) from the main table.
in the "totalquery" query i call each control this way:
select tblPeople.name,tblPeople.tel,tblPeople.age,tblPeop le.Car from tblPeople where tblPeople.Name=[forms]![frmMyform]![combo1] OR tblPeople.tel=[forms]![frmMyform]![text1field] OR tblPeople.age=[forms]![frmMyform]![text2field] OR tblPeople.Car=[forms]![frmMyform]![combo2]
GROUP BY tblPeople.name,tblPeople.tel,tblPeople.age,tblPeop le.Car;
I want to make it display (the right) results if one of the text filed/combo is filled or with data, or all together or in combinations.
i use the OR statement,but it doesnt work if I fill in two fields/combos together and etc.
Anyone? :rolleyes:
View 4 Replies
View Related
Sep 12, 2007
Hello all!
Basically what I am wanting to know is how difficult is it going to be to do the following.
I want to have 8 searchable fields, first name, last name, MO, Job code, etc etc. I want to be able to type somthing in any one of these fields and then when i hit a submit button I want to to return to me all the data that corresponds to what I am looking for. I know I could just create a simple query from the query wizard but i want everything in the program to look uniform as to not throw every one off. How difficult would this be and how should I go about doing it. If you need more information let me know.
View 2 Replies
View Related
Oct 17, 2007
Wondering if it is possible to order by particular values??
That is I have a column (varchar) named "Status" with values such as; Entered, Active, Completed etc (I didnt design the DB).
What I need is to order by Entered, then by Active then Completed etc.. Is this possible??
Ive got this code for SQL; but it doesnt work in Access (03)..
ORDER BY
CASE Status
WHEN 'Entered' THEN 0
WHEN 'Active' THEN 1
WHEN 'Completed' THEN 2
ELSE 3 END, Status
View 2 Replies
View Related
Oct 27, 2005
I have a form with tab pages which I can not change the tab order.
When I bring up the Tab Order box no fields are displayed only a Custom Tab Order! Never seen this before.
Question is how to get rid of this and be able to change tab orders.
Thanks
View 2 Replies
View Related
Jan 16, 2006
I'm just creating my first db. When I'm on a form looking at a previous record (in this case a transaction), I need to be able to make a minor change to that record (such as the date for a repeat transaction), and then save the record as a whole new record. The button commands I found in the wizards only let me save over the current recond after an edit. Anyone know the easiest way to creaet a command button that does this? Thanks for any insights.
View 3 Replies
View Related
Dec 22, 2006
I trying to setup a custom yes/no.
In the table I set the yes/no format "Made";"Recieved" » lookup 'text box'
I made the form and in the textbox and did value list with made and recieved. but it's giving me the could be text when number should be used and vise versa thing.
View 2 Replies
View Related
Mar 8, 2005
i must be overlooking something obvious, but....
how in the world do you put in the little gray separators in a custom toolbar? you know, to keep similar buttons in logical 'groups' on the toolbar...
View 1 Replies
View Related
Mar 29, 2005
I am in the process of developing a DB for work. The DB is used to track incident reports and lost/found property reports.
I was interested in using 2 custom autonumbers for 2 different reports within the same DB. I would like to use the format of "I" for an incident report, "F" for the found property reports. So when I start a new Incident report it would generate the following number; "I05-03-001" The "I" specifing that it is an incident report, "05" for the current year, "03" for the current month, and "001 as the next sequential number for the reports for that month.
Does anyone have any suggestions on how I can get this done? I would very much appreciate your help.
John
View 1 Replies
View Related
