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.
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.
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?
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?
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?
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
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..
I'm currently working with a form, which is in datasheet view. I have many rows which are combo boxes (yes/no), and the name is rather long. So each line (each row) spreads on to 2-3 pages to the right.What I would like to do is make the namebar, on top of every column, a little bit higher, so the name would be split into two lines, or three. Allowing me to make the width allot smaller.Here is an example of my problem:http://213.213.137.96/~terminal/columns.jpgSo my question is, can I change the height of the column name? Or is there some trick I can use?regardsFrímann Kjerúlf
Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.
Hey guys.. I am trying to make my DB into an MDE file however that option which is in Tools > Database Utilities is not highlighted on this particular database. Anyone know why? Thanks!
EDIT - This features seems to be inactive on all atabases on my computer (I haven't tried another computer yet). I am using Access 2000 and running Win XP Hme. SP1.
I'm making my first commissioned database and I can't get my head around auto-lookups.
At the moment, I'm only working with tables because I want everything properly formatted and working at the table stage before I move on to making my forms, queries, reports, and eventually the switchboard.
What I want to do is when I call up a particular ID number in a table which has corresponding data in another table, I want the corresponding data, such as names and phone numbers, to come up automatically within the table.
My database has about eight tables in it and all are linked in someway, either because I need to create lookups, or because they will eventually be subforms.
So what I need is for someone to explain an easy way to get the tables to do what I want. I've looked up the Dlookup function in Access Help but it didn't make sense :confused:
Can someone help me please? I would REALLY appreciate it.
In my form I have the title of a CD which is under the name of 'CD_Title' which is taken from my CD's table and I was wondering how to show it up in a Label so when I flick through the albums the Label changes to the album that it is selected!
Being an Access newbie and all I knew nothing about the maximum number of TableIDs being 2048...really I just found out about TableIDs when the error message popped up. :o Is there a way around this, short of revamping the entire database?
I have a front end/back end app in AccessXP/Sql Server. I have a master version of the front end on my pc, and each user has a copy on their pc. Everything works fine. I wanted to go the last step in securing the project, so I converted to an MDE. Now, on some of the other PC's, any field in a form that has "NOW()" as the default value (unbound fields) displays the #NAME? error.
Any idea why it would work fine in a .MDB, but not in an .MDE?
I have 3 tables with which i want to extract columns from each of them and place them into a new table. The problem i have is that none of the tables share a common member. each table contains the same amount o rows spo when outputted to the new table will match up
The help for junctions says to make a compound key in the junction table, but I don't understand the intructions for this. Do they mean make all three of ID's the junction table PK's or is there a literal "Make a Compound Key" button somewhere?
Currently, the table has an AutoIncrementing field as the PK and the two FK's copied in from the Primaries (converted from Auto to Number). As a result, I can only make one-to-one relationships to the junction table.
SELECT testScreen, Count(ID) AS testCount FROM SERPTestInput GROUP BY testScreen
It returns a count for each testScreen that appears in the table.
Then this query returns the same thing except it joins another table and adds the criteria that the status for the record must be successful.
SELECT testScreen, Count(testID) AS myCount FROM Results RIGHT JOIN SERPTestInput ON (SERPTestInput.ID=Results.testID AND Results.testStatus = 'Successful') GROUP BY testScreen
So both queries currently generate an 8 row table with the first column being the testScreen and the second being a count. I would like to somehow combine the two so I get a three column, 8 riow table. Column 1 would still be the testScreen, column 2 the total count for each testScreen and column 3 would be the successful count for each test screen.
In short, can the above two queries be combined into one?
I have a little problem with making a query and would need your help.
I have the following temporary table that gets filled automatically with 2 records every day:
DATE | TIME | NAME | CODE
The first record will have the DATE, TIME, NAME ( always the same ) and the CODE that can be START or STOP.
What i need, is to put the 2 records from the same day in a single row to get something like that: NAME | DATE_START | TIME_START | DATE_STOP | TIME_STOP | NAME
Until now i was able to make 2 different queries. One can give me the START info's, the other one the STOP info's. My question is if there is a possibility to combine those 2 queries or to make one query to get the result i need.
I have 2 tables: first table has 4 columns: /job code/project1/project2/project3/ job code is some digits, and in next columns are the job description (different for each project).
The second table has /project name/job code/description/working hours/date/
I made the query what shows how many working hours was consumed for each project monthly and my working codes, but I would like to have job descriptions after job code, If its project1 then the description should be taken from first table from the column "project1". Is it possible to do it with query?
I belive I have done this before but I cant remember how!
I have a continuos form with two text boxes on it and a check box.
I am trying to say if text box1 = "1" then text box 2 is visible if text box 1 = 2 then text box 2 is invisible. I am doing this on a tick box (for other reasons) so my code looks like this:
If Me.Text1 = "1" Then Me.Text2.Visible = True End If If Me.Text1 = "2" Then Me.Text2.Visible = False End If
It works, kind of. The trouble is because its a continuous form all the Text2 boxes become visible or invisible depending rather than just the one record i'm working on. Is there a soloution to this?
