recovering data from a corrupted database. I have a huge table with almost 600K rows and 140 columns. I went to Database Tools, Visual Basic, Tools, References. There was a broken utility file. I removed it by unchecking the box and closed and returned to my db. I did make table query from the corrupted table and then imported it into a fresh db.... but still I cannot run an append or update query successfully.
View RepliesHi all,
I have deleted certain content from a table. After it I have compressed and repaired the database but later I found out that I need those deleted data. But now they are gone. Is there any possibility to recover it? Are there any tools or something?
Thank you very much for your help.
I lost a table in my MS-Access. Is there anyway to undelete the table once the database was closed? I appreciate any help you may have.
View 4 Replies View RelatedAs part of a larger multi-user system there is a time recording part with a simple table called tblTime with an autonumber field. Today at 11:45 users started reporting receiving a 3022 error. On looking at the table I noticed that if I tried to manually add a record then the ID field number inserted automatically was not the next number in sequence, but one that already existed, hence the error.
View 2 Replies View RelatedHello,
I'm relatively new at Access and not quite sure where to post this problem. Anyway, I have a complaint database with multi-users. Twice now, I've had the data in two of my records change to what looks like a foreign language. I'm wondering if this has happened when a user tries to filter records within the database. Has anyone had similar problems such as this? If so, is there anyway to correct the text, or to prevent this from reoccuring?
Thanks!
Attempted to link to a table on an SQL Server, which included customer records & various contact dates, after the importing the records became corrupted in that they repeated the initial date over & over e.g.
Customer Date
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04
...as opposed to listing same account number but with 4 different contact dates...also when the Access database was opened on a different PC (also Office 2K) the table was displayed correctly?
Has anyone else come accross the same issue, any advice/guidance much appreciated. :rolleyes:
Hi.
Have a multiuser front and back end database.
Apparently 2 records (without memo fields) got corrupted. I could not delete the records so I tried compact and reair without being able to do either. I tried JetComp but it said it could not fix it. I cannot even delete the offending table.
Help! I have major reports due.
Russ
Due to my carelessness I lost my passwords of MDB files. I used to write all my passwords on a diary. But last week I lost it somewhere and hence I lost all my passwords. I have several MDB files of MS Access but now without passwords they are useless as I can't open them. How to recover my lost passwords back?
View 14 Replies View RelatedHi i have a small issue with a few databases a friend has asked me to help with. let me explain then you will know all that has happened.
4 days ago my friends server crashed .. hard drive failure .. so he thought
he brought the machine to me to see if i can get it fixed .. turns out the raid firemware on his dell server was flakey and needed updating over a year ago which he hasnt done. anyway it crashed same day his tape back up system his tapes he had to wipe clean and start a fresh so he has no backups ... and the raid on his server failed so now he has no data.
i used easy recovery professional to pull all the files back which it has i have repaired all the exel files but when i have tryed to do repaires on the mdb files it just says failed so for the last 2 days i have been hunting the internet for access repair tools and everything i have tryed has failed.
Some of these mdb files are over 1gb in size is there anyway to view the raw data like some other databases allowing me to pull all the tables and back?
when i try to open the files in access it comes up with an error saying unable to open un recognised formate. i have used advanced access repair tool i found on the net and that after spending an hour analizing the file said it failed.
this has been a real evil favour i did for a friend and i wish i never did it but i need to finish it can any one help im not a software guy as you may have noticed im a hardware guy myself so my knowledge on access is very limited.
Hi,
I have just got back from leave and found out my contacts db has corrupted whilst i have been away. Unfortunately during this time the automated backup has copied the corrupted file so that is now useless as well.
When i try to open the file it says 'Error cannot find object 'Database'. I have tried doing a compact and repair on it but get the same message. Is there anyway i can get this back?
Thanks
Hope you can help guys. Here's what happened.
I saved a form as a different name so that I could work on it. I made some changes to the new saved form then tried to save it to the name of the old form, to overwrite it. It came up with an overwrite warning, i said yes and suddenly the database went crazy and had to shut down.
When I restarted, the form I tried to overwrite was gone from the list, but the one I had worked on was still there, so I thought, "thats ok, I'll just rename it".
Well, it won't let me rename it either, and comes up with error messages all the time now saying that the form that was overwritten no longer exists. What have I done!!!!
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?
Some days ago I made it by using "query", but now I forget it how I make the relation on this situation. Here is my problem.I have 3 Table on mdb file, named Table: A, B, Status.Table Status have One Filed with 1 Data: Dishonor
Table A have three fields
Sl Number: (Auto Number)
Status: Lookup wizard-data of (Table-Status)-Default Value is "Honor"
Amount:Number
Table B have two Fileds
Sl Number: Number
Status: Lookup wizard-data of (Table-Status)
After Entering Some data on Table A it's Look like as:
Asl numberstatusamount
1Honor5222
2Honor855
3Honor988
4Honor7777
5Honor777
6Honor9999
[code]...
Now I want to change the Status of SL Number Honor to Dishonor so I fillup data on Table B is as like following
sl numberstatus
5Dishonor
Now how I can get the result as following by using query:sl numberstatusamount
1Honor5222
2Honor855
3Honor988
4Honor7777
5Dishonor777
6Honor9999
7Honor6666
8Honor7777
9Honor666
I have three tables: Vehicles; Vehicle Reallocated; and Vehicles Retired. I have a form that runs a query to find all the info in the Vehicles tbl that is not "Retired", not visible in the form. I then have the option to toggle to a Reallocated or Retired form. When i toggle to the reallocated form, i have the like fields in that table (ie Van #, Vin, Make etc) pulling the info from the hidden subform with the vehicle query, so i do not need to fill in repeat data. However, when i add a reallocated date and the new clinic that vehicle is for, i get the record ID for the vehicle reallocated table as expected, but when i save none of the data moved over from the query saves in the record?
How to get all the data on the reallocated form to save?
I am working from an existing database which is just two table. The main table has a massive amount of redundancy and duplication and needs splitting into, at first glance, 5 tables.
After I have run my various make table queries and added a Primary Key and FK field to the new tables how do I populate the FK with the Parent PK.
I thought I could simply add all the fields from the new table and then create an adhoc join in an update query to populate the PK to the FK. When I do this however I get "You are about to update 0 records"
I have tried the table analyzer but it doesn't give the correct options to split the table the way I need.
I have two table
1 is name master containing EMPID(Primary Key)
2 is Saving which also contain EMPID
i want to entered data in Saving with each and every EMPID with Master
I am assisting my employer by combining two databases into one. Both databases have the same field "structure" but the data differs. When creating my append query.
View 3 Replies View RelatedLet's say that there're 2 workers: Worker A, and Worker B, and they are fixing some engines. There's 2 different engines: Engine A, and Engine B. And these workers are fixing these engines for all day, and in the evening they have to register how many engines they've fixed.
And my job is to design Access database for them. I thought it will be very easy to do; I've created table with columns: Date, Worker, Engine, Quantity - so every day Worker A and Worker B can register, that they have repaired some amount of Engines A and Engines B.
But there's a problem that I also have to register how many Engines have arrived to the factory, and how many of them weren't repaired on time (E.g. 15 Engines A have arrived, Worker A fixed 5, Worker B fixed 5 so there's 5 engines left for tomorrow)
I've figured out that I should somehow create table IncomingEngines with columns Date, Engine, Incoming, Fixed, Undone (field Fixed should be completed automatically every day for every engine - it would be a sum of engines A and engines B fixed by worked A and worker B - so I could fill Incoming field manually)
It's easy to create this kind-of Query, but I can't add column to querry, or edit it.
I have a table called "WorkRequest" consisting of some fields such as WR Number, WR Date, WR Time, WR Requested by and WR Work Requested.Once a work request is completed, I want to open a form called "JobCards" from a table called "JobCards". When I click on the pulldown box for the Job card number, it lists the "WorkRequest.WR Numbers" which is what I want.
My problem is: As soon as I select the WR Number and it displays in the jobcard form in the JobCardNumber field, and I press ENTER or TAB, it must automatically populate the corresponding fields on the JobCard Form. These fields are defined identically in bot the "WorkRequest" and the "JobCard" tables.
I currently am working on a small inventory project. I have a table with the fields "Part Number" which is my primary key, "Description", "Cost", and "Sale Cost". I have a second table that I would like to use to keep track of purchase orders. It has the fields "Part Number", "Description", "QTY", and "Cost". I would like to be able to open purchase orders and be able to select a part number from a combo box that pulls "Part Number" from my item list.
So I can enter items in to my item list and later when I do purchase orders I can go to purchase orders select my item and have it automatically fill in the description and cost in my purchase order. If the item does not exist I can enter in the item in to the item list table. At this point i'm not worried about a prompt to enter in new items if they don't exist in the item list table. I just want to my Purchase Orders table to be able to autofill description and cost by selecting a "Part Number".
I am new in using MS Access. We have this thesis that checks the attendance of the professors and then sends the ID number of the professor to MS Access. I am using smsenabler as the software to encode the ID numbers to the database.
The problem is that, I want to transfer the ID numbers to specific table for the professors name. I don't know how to do it. And I can't make the ID numbers as primary keys because it duplicates every time the professor scans his/her ID.
I am not sure how to word this or how to search the forums for an answer and am getting frusterated.
I need to create a table that pulls data from other tables based on a job number and a check box (true or false).
I have to export the data from the table to a text file and set a fixed with for the columns so that it will turn out like this:
1HCPT UBR RTMX002063TE 682782 CS000000010008518RR025008518RR04 000916500007000DY0Detailed Inspection------------------------------ E
1HCPT UBR RTMX002063TE 682782 CSA00000010004458GT009004458RR04 000705000000000DY0Jack Car A End------------------------------------ E
1HCPT UBR RTMX002063TE 682782 CSB00000010004458GT009004458RR04 000705000000000DY0Jack Car B End------------------------------------ E
1HCPT UBR RTMX002063TE 682782 CS000000020004400DF009004400RR04 000141000000000DY0Hook-up Top Rod----------------------------------- E
1HCPT UBR RTMX002063TE 682782 CS000000010004450FV009004450RR04 000047000000000DY0Lube Center Plate--------------------------------- E
I can't seem to do this in a query because it does not give me an export to text option.
Can anyone help me figure out a way to do this?
For some reason, I am unable to copy the data in a table using the square at the top left of the table: (See Pic)
View 2 Replies View RelatedI have a production machine that writes its output to a CSV file every time it produces a good part (several times pr. day). It can produce identical part which means that the mashine will not put in another line in the csv, but just update the no of produced parts. I had to rename the attached file because you can not uploade *.csv files in the forum.
What I want is:
- When someone opens a specific Access db a tabel in the db is updated with all new data from the csv file.
My problem is: How do I make sure that I only get the new data from the Access db.
I have a linked ODBC table in my database that contains data like this -
Code:
Task Serial CrewAmount
00_INSTALL ENGINE INTO PEDESTAL STAND 707308AS30.2
00_INSTALL ENGINE INTO PEDESTAL STAND 707308OMB0.2
01_BORESCOPE INSPECTION 706496AS114.24
01_BORESCOPE INSPECTION 706496AS223.24
[Code] .....
What I would like to do is remove the duplicate values for the Task field, but show how much time each Crew has spent on each Task per Serial. The end result would look like this -
Code:
Task SerialAS1AS2AS3OMAOMB
01_BORESCOPE INSPECTION 70649614.2423.2428.78
00_INSTALL ENGINE INTO PEDESTAL STAND 7073080.20.2
01_INSTALL OIL TANK 7073085.67
[Code] ....
What is the best way to achieve this result? I've played around with Append queries, union queries etc, but nothing seems to give me the result I'm after.
i have created 6 tables and individual forms for each of them to fill those tables. also i have reports which are bounded to 4 of these tables/forms.
my problem is this :
i have successfully filled the tables using these forms. but whenever i open it the next day or so, the data in some of the tables gets mixed up.
For eg:
>my EMPLOYEE DETAILS has the emp no as primary key, and is linked as lookup field in other tables. (so tht user may select emp no and then enter details in FORMS)
>my EMPLOYEE ADRESS table's (report not linked) data gets interchanged according to emp no.
instead of being 1,2,3,4,5,6 (as i entered), its 2,3,4,5,6,6.
>sometimes my other tables also have these problems.