I have a small problem and think I have found the answer but still would like some info on it. I have a DB that was created in Access XP, One of the bosses upgrades to Office 07 full version, and only has Access 07 on his machine. The DB would not open for him..... I noticed the reference "Missing" to "Utility" Now when I open it on my laptop it's fine.... I have Office 03, Access 03 and Access 07. So I opened an old sample DB of something I found and I got the same reference error.... As it shows the path I found the "Utility.mda" and set the reference. From my searching it sounds like this "Utility.mda" was something on older versions but now is not on Office 07.... So what exactly was the "Utility.mda" what did it do, and why is it now gone???
im trying to fix an access program on a computer for a friend.
I have re-installed the progam and access 2000 runtime perfectly but several errors are stopping the program running. On my computer i have carried out the exact same installation procedure and it works fine. I am therefore thinking that there must be some sort of problem with his computer config.
After quite a bit of trial and error i have found the following.
In the directory of the program there exists a file called 'UTILITY', which says it is a type 'Microsoft Access Add-In'. What exactly could this file be for? It consists of several modules and tables which seem to relevant to the program. On my computer i can go into the utility file and look at the tables ok.
On the problem computer though i can get into the file but when i try to open the tables i get an error that just says 'Unknown'. Also after a while access then completely crashes and wants to send a report to microsoft.
Also the program has worked perfectly up until lately but no idea why this has changed.
The FE of my database has been crashing during the last week and there have been a few other problems. I got errors saying that the BE was an 'unrecognised format'. I remember getting a 'not a valid bookmark' error also.
Another odd thing that was happening - when I put breakpoints in my code it was not breaking and stepping through it. It was like they weren't there. I realise now that editing the code while it was in break mode may have caused problems.
I didn't realise these issues were signs of corruption (until I started reading up on the subject and searching this forum) so have no idea when it started or what could be corrupt.
I used the compact and repair facility and it seemed to work fine. I can open all the forms and reports. I also decompiled the FE and it hasn't crashed since but I don't know if the problem is completly solved. From what I've read the problem could get much worse if I don't deal with it now.
The reason that I think that there may still be a problem is teh fact that the JEt compact utility will not work. I just get an error saying 'Error compacting database' straight away.
Is there a way to tell if something is corrupt or am I worring unnecessarily?
I'm interested in tracking monthly utility bills....monthly charges, units/volumes, costs per unit and so on, by monthly date. Would I be OK using a single table for my data, since it only involves gas, electric and water each month? How would I chart the data, so I could see trends (i.e., cost per volume, etc.)
Are there any sample projects out there that I might be able to adapt to what I'm interested in?
I'd be most appreciative if anyone has a comment, idea or suggestion. Thanks in advance!!
Totally new to access and was wondering if there is a way to search all queries, forms, macros, etc for references to a particular table. For instance, I am adding keys to some existing tables that do not have keys and want to test all the forms where that table is used.
Its a big database and going through form by form will take a long time.
Here is a utility that will allow you to set the "Shift Key" bypass during startup .... remotely. Someone has placed an altered version of this here in the archives. The altered version requires that the machine running the utility must have Common Dialog Library installed and registered.
This version "does not require" the Common Dialog library. This version is written for Access 97.
The trick here is not to allow other users access to this utility so they can not enable the shift key.
You can copy this utility to a diskette so you can use the utility when not at your local machine.
I am in the process of redesigning one of my databases and one of the users request was the ability for them to change the screen colors. Joeyreyma had posted a screen shot which led me to put this database together.
I have A2K here at home but converted it to A97 for everybody to look at.
How this works is this:
1. When you open the database, a form called "Form Color Changing Utility" will be presented. 2. When this form opens, it triggers an Append query called "qryAppendFormName" which uses the system tables to append all the form names into the table called "tblColorStorage". This is set up so no duplicates will appear. 3. The combo box uses the system tables to return all of the forms in the database. I only have two for demonstration purposes. 4. Select "frmColor" in the combo box and you will see the current colors for the background, textboxes, and labels in that form. 5. Now change the color for any of the three choices by pressing the button with the picture of the color pallette. This will bring up the color selector dialog to allow you to select the color you want. 6. After your selection is made, code searches the "tblColorStorage" table based on the form name in the combo box and sets the appropriate field in that table with the value of the color. 7. Now, close this form and open the "frmColor" form. The settings you have chosen will be applied because of the code on the OnLoad of the form reads the values from the "tblColorStorage". Each form you set up and want to change will need to have the OnLoad event set to this code.
This database uses a short module called fColor which brings up the color selector box. I borrowed this code from Access 97 Developer's Handbook (Litwin, Getz, and Gilbert) so thanks for them on this piece.
All other coding I pieced together through trial and error.
I thought I would share if anybody had a need or could use it.
I want to create the import utility for my application to work with text (with different formats and delimiters) and Excel files (something similar to Access built-in import wizard). Reason that I don’t want users to use built-in utility is that, with the Access import utility you can not limit the number of tables that you want to user to see and you can’t change the field names to more meaningful names. Also, it is really limited to what you can do programmatically (validation of the data, limitation of the records…). I wanted to see if anybody has done this before and can share with thoughts and experience or possibly with the code. Thanks for your help.
A client of mine called me last night and said he got the following problem when trying to open his database
"The database 'PathCardata.mdb' needs to be repaired or isn't a database file.You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsoft Access to attempt to repair the database?"
When he attempts to repair it, nothing happens. I looked on the forum for this problem and a JetComp Utility was mentioned which may help. This supposedly can be downloaded from the Microsoft site. However I can't find it. Can anyone help ?
I have a VB application that re-indexs the selected database. It gets through all the tables until the last one and then produces an error advising the client to contact the helpdesk to have the database repaired.
I have run a compact and repair and that has worked. I have created a new table and appended the data from what I think is the offending table. Deleted the table and renamed the new one - all to now avail. Does anyone have any advice???
I have a problem with my current version of my db and I believe it's at a point of corruption that I can't fix. I would like to compare the backup version from a few days ago with this version to see what changes I made and do them again. Does anyone know of a utility to do this?
Is there a free utility out there for reading a .lbd file or a way to do that in Access itself?
I have a department that has users that don't understand the meaning of 'get out of the database' now so I can make a few report modifications for them. Actually the changes have been made, I copied the reports as 'beta' versions and did the same with the queries. Modified the reports and queries, showed the department head the resulting changes and received approval for deployment. Told the users to get out of database and the .lbd file (created this morning at 07:14, so, it is a fresh one and not orphaned) is still there.
Thank you for letting me cry on your shoulders you probably don't have users like this ...
I have attached a database that implements the Windows XP zip utility in a class module. It is in Access 2000 file format. To see how to call it open basZip and look in TestZip. Let me know if you have an problems or questions via PM.
hi, i have database compact utility 4. i want to know how to use that. in source field i have to give the database i want to repair. and what to give in the destination field i have to give new database (Blank Database)..? thanks
A friend (client) of mine got the following error on his database and can't repair it. "The database 'PathCars.mde' needs to be repaired or isn't a database file.You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsoft Access to attempt to repair the database?"
I tried different things (e.g. importing, using the JetComp Utility) but no success. I saw a utility for Access Recovery on the net and the demo version of this restored some of the data. However it costs $399 to buy which is a bit too pricey for me. The database is about 1 megabyte zipped up. Would anybody mind trying to repair it for me if they have any recovery utility ? I would really appreciate this as my friend has lost days of work and he's not too impressed.
I will attach it of anybody would care to help me, or I will email it.
We are using Access 97 at my place of employment, and over the years we have created quite a few Access data bases. Of course, over the years, programmers have come and gone, and it is getting more difficult for the current people to maintain the applications. As a result, we are looking for a utility (or utilities) that will do the following things:
(1). Thoroughly document an Access 97 application so that we can see where and how all fields, tables, queries, etc are used.
(2). Give us the ability to rename all instances of a field, query, table, etc, in an entire data base, with one simple command.
And naturally, the utilities need to be as inexpensive as possible.
There are no plans, at this time, to migrate/upgrade to a newer version of Access.
I was looking for a great way to link and relink BackEnd to FrontEnd and I sort of found it. Bob larson build a great extensive tool to autoupdate backend en master frontend. You can find his great post here: http://www.access-programmers.co.uk/forums/showthread.php?t=111132&highlight=back+end
Here is my problem or wish is more appropriate.
I just want to relink the backend and if the backend isnt found I want to select it using the filedialog.
Just inherited a database. The autonumber field for two tables are both named "Line ID" with a space.
I've been trying to do a global search/replace of "Line ID" with "Line_ID" but it's not happening everywhere, just in code. There's a chart on a form that uses it as child/master fields, etc. that aren't affected by the search/replace.
Is there a (preferably freeware) utility I can use for this sort of thing? God willing, this will be a once-and-done event.
I have searched every way I know on this site but cannot find the post I'm looking for. I read a post months ago that mentioned a utility that allows the user to rename an object and all the references to the object. I believe the utilitie's author was named Tom.
Does anyone know about this utility and where to find it?
I find that many times users want to extract data from the database for their own reporting needs. This simple filter module allows users to create, save, and export filters. Each user can create their own filters. This utility is very easy for the users to understand and use - and is little work to implement.
Some technical notes: - The Microsoft DAO Library needs to be referenced. - To view the UsysFilter table you must show the System Objects and Hidden Objects (from the Menu Bar select Tools > Options) - Username are retrieved by Environ("USERNAME") – this can be change to CurrentUser() if a mdw file is in use.
To customize the filter: - Change the Record Source of the fsubFilter form. - Replace the existing fields on the fsubFilter form with the ones from your new record source. - Change the SQL of the qryFilter to that of the fsubFilter new record source. - Filters are sorted in the UsysFilter table. - You can create predefined filters in the UsysFilter table – the sort works in descending order. - Change the default value of the cboFilter combobox in the fmnuFilter to your desired record in the UsysFilter table. - Change the Docmd.OpenForm method of the Form_DblClick event on the fsubFilter form to open your desired form.
run time error 2486. You can't carry out this action at the present time.
Thanks way in advance. This appears to be a very tough problem. I know that I am very frustrated and totally stumped.
I am programming in an Access 2003 environment, or an Access 2000 environment. The problem occurs in both.
The problem originally cropped up in Access 2003.
The general scenario is this.
I have a main form with a couple of subforms In the main form, there is a dropdown.
Depending on what is selected in the main forms dropdown, different forms are used to populate the subfrom control.
example (although this example isn't exactly what I'm doing in this case, it hopefully will serve to illustrate the problem)
Select Invoices in the Main Form Drop Down then the subform.source object becomes the Invoice Sub form
Select Receivables in the Main Form Drop Down then the subform.source object becomes the Receivables Sub form
In this way, the system mimics a tabbed form, but allows multiple sub forms to be accessed. By not having multiple subforms, the system has a lot fewer requeries to do.
The actual scenario is substantially more complicated in this case. I would prefer not change this approach as it would entail a lot of reprogramming.
Here's what's weird. This has been working fine for maybe a month or two. It also has worked fine for a lot longer than that at other locations. About two weeks ago, my client's computer (The one I'm developing on) had some sort of problem.
The client lost a folder on his system, and crashed his system several times. It sounds like it could have been flaky RAM.
In the process of looking for his lost folder, he opened every single one of my backup mdbs, both the front end and back end. (I backup several times a day.)
His IT guy can't restore any of the backups from tape.
So, I'm stuck with what I have.
Here are a couple of additional facts. When this problem occurs, the only way I can exit is to close access. After access closes, I can't compact the back end, and three tables remain locked so that I can't modify their design. In order to regain control of the backend, I have to logout and relog in, or I have to open task manager and kill the msaccess.exe task. This task shouldn't be open by the way, as I have exited access.
I suspect that somehow the computer problem has messed up all of my back ends.
I have tried creating a new back end and importing the tables to no avail. At this point I am 10+ hours into this problem with no end in sight. Worse, I still don't know which path to pursue to fix it. I'm not sure whether the problem has to do with the backend data being somehow corrupt, or with my programming. I suspect the back end is corrupt because the programming has been working for quite a while, but I need to eliminate this as a possibility.
so enough scenario..
Here are my real questions.
1. Does anybody have a rebuild table utility. What I'm looking for is something that cycles through the existing linked tables in a brand new mdb and runs maketable queries based on each of them, creating all new tables, but without copying the structure. Then another algorythm that might cycle through the field attributes in each table and modify the field properties to mimic the original tables. And then cycle through and recreate indexes. (I could probably write this algorythm, but it would take me hours and hours and hours.)
2. Does anybody have a more complete rebuild utility that would do the steps above and also copy all the import/export specs, queries, forms, reports, modules etc. (I don't think I could write this algorythm no matter how much time I took.)
3. Is there anyway to tell what processes WITHIN access are still running when I get the 2486 error.
4. Does anybody know of some other setting that might be causing this 2486 problem. It is now happening on multiple computers in multiple enviornments
With TOAD, a software that deals with Oracle, there is a utility that will generate a script from a table. With this script I can build the exact table again in Oracle. Access has the documenter, but no 'export' script / SQL for the table. Does anybody know of a utility or code snippet that would do the same thing.
Hello fellow Access users! This is a wonderful utility that reads the image, video, and audio files on your computer. It is really great if you save pictures on your drive (especially if you have a digital camera -- you know how those get named!).
When I ran it on my computer, I found all sort of cool pictures I had forgotten about. Great for catalogging (and finding) many email attachments too! Also for getting rid of all those unwanted files (that you didn't even know you had!) from browsing websites or installing software.
Everyone I have given this program to that has tried it is amazed. Some of the comments I have gotten are that it is the best program they have ever seen to track graphics. It actually finds all the multimedia files but images are the only things it actually shows you (sure beats the thumbnails you see in Windows). You can also use it to rename and delete files.
Attached a zipped up file that explodes into FileTrak.mdb (Access 2000). Email me privately for the documentation -- it was too big to post! (the first thing you will want to do is READ FILES from your drive -- then once you have data in there, you'll see what to do)
I appreciate hearing any comments you may have.
Edited by: GlenKruger on Mon Mar 21 17:52:34 EST 2005.
I'm tidying up the names of forms, roports, fields etc in my databases (getting rid of spaces and adding prefixes such as 'frm', 'rpt', 'qry' or 'tbl'
Does anyone know where I can find a Utility that neatly 'Finds and Replaces' access object / field names? I have a utility that works for Access 97 but can't remember where I downloaded it and was looking for a similar thing for A2000.
anyone know if there is a "Find and Replace" Utility out there anywhere that will search your whole database and do a "find and replace" on a string. For example, i mispelled preauthorized and used the wrong spelling in forms and queries. I wanted to change preautorized to preauthorized but wasnt quite sure I had found all the occurances of the bad spelling.