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 year
I'd read a few places that embedding pics wasnt the greatest of ideas, but I thought that 1 JPG embedded onto 2 forms would be ok and would prevent the pic from being deleted or moved. (Theyre always screwing with the server here.) But it's making my DB huge.
No pics embedded Size: 808kB
1 Pic Embedded into 2 forms Pic Size: 156k JPG DB Size: 135 MB
Is this normal? I could understand a 156k pic adding somewhere around 156k to my DB, but 134 megs? Anyone have any insight?
I am using the Auto FE Updater to update the FE's of my database over a LAN. The utility is setup and working normally for the most part, but I have one little issue that I can't seem to find any info on anywhere.
There are two groups of users that are only separated administratively (not geographically), they are in the same building. One set has their drive containing the database FE & BE mapped by a logon script; the other group must map the drive manually. The problem is with the second group; they can't map the drive to the same drive letter because they have another drive automatically mapped to that letter in their logon script. Plus since they are doing their own mapping, they don't map to the same letter amongst themselves. I am using a shortcut to the StartMDB.exe on the network drive (the shortcut is in a separate folder from the actual executable). I am using UNC everywhere possible but when the shortcut is put on the desktops of the second group it still points to the drive letter of the first group. If I try to change the shortcut to UNC it always reverts back to the letter it is mapped to.
I am trying to make a .cmd file so I can use UNC there but can't get it to work. Does anyone have a .cmd file that starts an exe and points to an ini file as would be needed by Auto FE Updater? If so could you post a copy of it so I can see what I am doing wrong? Also, does anyone have any other suggestions?
I have set up Tony Toews Auto FE updater and it works great on my machine. I just had one of my users go into the shared drive and double-click the StartMDB.exe file from this program and she is getting this error message:
"Null command line sent to utility"
"If you are using a shortcut the target in the shortcut has not been properly set up"
I have not created a shortcut for StartMDB so I don't understand what could have gone wrong. Any ideas?? I have posted this message in the community newsgroup for Tony Toews but not sure if I asked it in the right one. Just hoping someone else may have encounter this problem in the past.
I am running an Access 97 database with the backend on the server and client databases on about 2 workstations. I also have a working model of the frontend on the server that I often update. I then have to go around to each workstation and manually install the new front end from the server. I am looking for an application built in Access 97 that I can apply before the client database opens, it checks the client on the server and if a newer version is available, it copies it to the workstation. Once copied, it then proceeds to open the new front end on the workstation. Tony Towes has an excellent application on the Granite website but I cant use it because it contains a VB programme that I cannot import onto our network (security restrictions).
Grateful if someone could point me in the right direction.
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?
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..
Hi, I have a huge databse with a form, showing record info. If I use a search button to search the databse it takes ages to find the record. The quickest way is to find the record by hand, find the record number, copy that, and paste it into the form and hit enter.
Does anyone have any ideas how i can speed thing change over up.
One of our key customers (GE) has demanded that we begin to submit our estimates in their transmission 160 character format.
Basically it it a txt file that looks like this all on one line. 1ABCDWXYZ0502EST TEST123456T050208654321C 00010851803098518031 000000E 0000000000000D CAR SHOPPED AS CLEAN-PROCEED WITH
Only a couple of those characters are in my database and will change. Other than that items will continously be the same. The items that are optional and we don't have not only have to be blank but have to have spaces there instead...not 0's.
How do I set up a query to kick all of this out? I tried something like:
I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?
I inherited a database from someone else which has about 9000 records.
When sorted, one can see that the AutoNumbering starts at about 72K...then after a while there is a jump to about 134K...then after some more records the AutoNumber suddenly goes up to about 396K.
Does anyone know the most likely reason(s) that the numbering is like this?
I have a form that contains a field for file box numbers, and a field for two different box numbers. I have a check box set up for the data entry person to check when the box if full of files. I need the the box numbers to increment by 1 for the two different box colors when the check box is = yes. Can this be done?
i've just delivered my program to my client and there are 2 MAJOR bugs.
bug 1: the first time program is opened, everything works fine. it goes to the switchboard, etc., everything's cool. however, if he closes the program (i think he closed it using the red X) and tries to get back in, only one item on the switchboard shows up from that point on. the thing is, this problem DOESN'T HAPPEN ON MY COMPUTER so i have no way of even attempting to figure this out. the way i have my program set up is i have an interface and a BE and an .mdw file all in the same folder. i've created a shortcut that uses a workgroup switcher so that he can open the program and use it w/the .mdw file.
i have no idea what could possibly be causing this to happen. i would think that the switchboard would open correctly every time.
bug 2: this one does happen on my computer.
setup: i have frmCustomers (outer form) with sfrmJobs (subform) with a subform inside of that named sfrmFinances. Everything in frmCustomers works fine, and everything in sfrmJobs works fine. The primary key (JobID) in sfrmJobs is entered manually. After the JobID is entered, sfrmFinances is accessible. sfrmFinances' control source is qryFinances, which has a few fields from tblJobs (control source for sfrmJobs). frmCustomers is linked to sfrmJobs by CustomerID and sfrmJobs is linked to sfrmFinances by JobID.
problem: a new customer is entered in frmCustomers. a job number is entered for the new job in sfrmJobs (JobID). the user then attempts to update a field (any field, but for example, ContractPrice) and a window pops up and says, "Field cannot be updated". you click ok and it pops up again, at least 10x in a row. then it finally lets you enter data, but when you try to save the record, it pops up with another window that says,
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."
excuse me?? how could there possibly be duplicate data??? the funny thing is tho, when the user closes the form, and then opens it back up and tries to enter financial data w/the same customer, it allows it.
???????
The first bug is more important than the second one, but any advice or ideas on either are EXTREMELY appreciated. thank you very much in advance.
I try to get an ASP file work with Access database and I get this error:
Microsoft OLE DB Provider for ODBC Drivers- Error '80004005' Specified driver could not be loaded due to system error 126 (Microsoft Access Driver (*.mdb)).
I tried everything and nothing - and the configuration of this driver doesn't work... How do I fix this driver??
I have a bunch of people with laptops who go on reviews throughout the state and leave reports on site with the facilities they review. They go out in multiple person teams and work together on reviews. Currently, each person types out their own citations in MS Word on their own computer, saves them to a flash drive and then the facilitator compiles them all together and prints out a report. Then the facilitator comes back to the office, provides their support staff a copy of the report, and then the support staff finalizes it and sends out a letter.
Unfortunately, none of our laptops have Internet capability out in the field.
My idea is to have a multi-user split main database that is stored at our main office. This is for the support staff to store all of the reports. Then I propose to have a local copy of the database (much smaller) on each of the laptops.
Here are my questions: Lets say that 3 people are out on review together. They each have their entry form on their own computer. The form will be sending information to a few different tables. How can they easily export out their results so that the facilitator could easily import them into their database on their computer.
If all of that were to work somehow, how could the facilitator easily export out the review information tables so that the support staff could import them into the main database.
One of the many stumbling blocks I see relates to Primary keys. The main database will have a main table with a PK of 2008.100 for example. While out on review the reviewers will not be able to use the naming conventions of the main database PK. They might use something like the City name and date (Pensacola02222008). Could that PK be automatically switched into the other format upon import?
Let me know ya'lls thoughts. I have been trying to get my head around this for a few days and have not been able to come up with a feasible solution.
I am upgrading a .mdb to MSSQL. The .mdb is 17MB, but the resulting MSSQL is 72MB. Tried using both the Access Upsizing Wizard and Enterprise Manager DTS. I have done this a number of times before, but never ran into this problem. Any ideas what coule be going on, and how to fix it?
Guys, my database have 7 fields and 690 thousands of lines.
When I resort, for exampe by date field, the database on my P4-3.2 with 1gb memory, on Access 2003 with XPpro freezes and does not respond at all!!!
On my old P3-866 512mb with Win2k it was working! After 3 minutes the computer was getting back.... But now.... I waited for 20 minutes. The access doesnt load not a CPU, and no IO readswrites are done - it simply stops responding.
What can we do with it? Why the perfomance is SO LOW?!
We have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.
I want to create a querry that exports a table with 3 columns:
1-->customer 2-->date of last visit 3-->average of out of stock products on the LAST visit
I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.
we have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.
I want to create a querry that exports a table with 3 columns:
1-->customer 2-->date of last visit 3-->average of out of stock products on the LAST visit
I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
a system for my company. I have been working with Access for a total of 3 days now, so bear with my inexperience.I have a table with State, Product Name, and so on as Column headers. I have repetition in both of those Columns (if that matters). I would like to figure out how to be able to pull up (Search, Sort, not sure how to word it) 1. By state) all products offered in that state and related info2. By Product) all states using the selected product and related infoWhich would be better for the above goals - Form or Page?I have looked into cascading combo boxes....it that the right direction?
