Over 1 million tech questions and answers.

NTDS table is corrupted?

Q: NTDS table is corrupted?

Hi all,

For the past week I ve been having a lot of notifications on my Win2008 AD. They are the same:
NTDS (628) NTDSA: Database e:\Windows\NTDS\ntds.dit: Index DRA_USN_index of table datatable is corrupted (0).

Anybody knows what this is?

RELEVANCY SCORE 200
Preferred Solution: NTDS table is corrupted?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: NTDS table is corrupted?

Your boot hard drive is failing

Read other 3 answers
RELEVANCY SCORE 54.8

Anyone know how to fix a corrupted partition table?
Every program i have tried has not worked because they all say that the table is corrupted.
I have reformatted once and i wouldnt like to have to again.
So any help would be VERY appreciated.
Brandon
 

A:Partition Table corrupted

Read other 6 answers
RELEVANCY SCORE 54.8

My daughter's IBM ThinkPad 600E won't boot up into Windows 98SE. It tries to run scandisk but gives an error message that the FAT table is bad and it can't run. It then freezes when trying to open Windows. I also can't boot into safe mode but can boot to a DOS prompt. Any idea of a utility that can fix the drive?
 

A:[SOLVED] Corrupted FAT table?

Read other 11 answers
RELEVANCY SCORE 54.4

Hi,

My Hitachi Touro 4TB disk partition got corrupted.
Originally it was one 4TB partition with about 2.5TB of files.

One minute it was fine, then it came up with "Need to format hard disk before use", then it wouldn't even start up.

The disk is currently mounted in a disk dock. The disk wouldn't start up in its original enclosure so there might have been a hardware problem with the electronics of the enclosure which corrupted the drive.

Now it has 3 partitions

465.75 GB RAW - Healthy (Primary Partition)
1582.25 GB Unallocated
1678.02 GB Unallocated.

I have tried TestDisk but for some reason after about an hour of scanning or so, the drive seems to switch off. But it seems fine when I'm using Windows software. I've tried writing MBR but TestDisk says it can't!!

Should I use something like easus partition manager and set the primary partition back to one 4TB partition and then use recovery software to recover the files or is there a better way?

Thanks

A:Best way to sort out a corrupted partition table?

Sorry to say this, but in every instance where any of my partitions were reported as "raw", that mean that the drive had suffered physical damage. And, in NONE of those cases was I able to recover anything of any of the drives.

I had two fairly new Seagate drives do this to me last year, and in both cases, they were sudden head crashes.

Read other 9 answers
RELEVANCY SCORE 54.4

I am a complete novice so please be patient and talk to me like i'm a 6 year old if possible.
I have a 10 yr old hp with xp. I use a modem with Charter internet supplied by my apt complex for free. I recently bought a belkin router and a netgear tv box. Everything was working fine until we had a power outage during the night. The next morning nothing was working. A day later i got my modem, router and tv box to work. The computer worked after trying to turn it on 3 times. The monitor wouldn't come on at first. Now everything is working but i still can't get online. My connections say they are connected but nothing is received.
I ran the IE connection problem diagnostic tool and it says:
default gateway 0.0.0.0
no default gateway entry
corrupted routing table
the default route is missing or invalid
invalid IP address
could not connect HTTP connection
HTTPS and FTP connections

I have no idea what any of that means. Can you help? Thank you.

A:[SOLVED] corrupted ip routing table

I assume you have tried to reset the router?

Read other 19 answers
RELEVANCY SCORE 54.4

Hello Sir,

First of all,to inform you, this has happened due to my mistake! and i am really very guilty about it.

The thing is that i have both ubuntu 12.04 and win 7 home basic installed on my system.
I installed ubuntu later so as expected the win7 loader was replaced by the grub loader.
What i wanted to do was restore my original win7 loader so that i could set my default OS to Win7 so that i didn't have to select it every time my system booted up.

In this regard,i searched some youtube videos and then ended up with a video which was not described very well, still i followed it because i wanted to get back the win7 loader desperately.
I am providing the link to that video:

Restoring Windows's Bootloader After Installing Linux - YouTube

I went ahead with the steps described in the video, And then shit happened.
My windows partition got corrupted and now i stand at the risk of losing about 500gb of important data which i had collected in about over an year.

I am able to boot using ubuntu but i am unable to browse my files on the hard disk(which i could do easily, earlier) as it doesn't show any partition.

When i inserted the recovery disc,it simply gives the option of restoring the factory settings,nothing else(like repair,which it used to give earlier).

My question to you sir, is that, is there any way through which i can restore my computer to normal and save my data?

I will be really very very grateful to anyone who helps me out of thi... Read more

A:Corrupted Windows partition Table

Hi ankitSurfzen and welcome to Seven Forums. You could try Minitool Partition Wizard to recover the partition. This video will show you how. How to perform Partition Recovery with partition magic? Partition Wizard Partition Recovery Video Help.

Read other 9 answers
RELEVANCY SCORE 53.2

The partition table is corrupted and I need to backup some stuff from C drive. I tried taking out the hard disk and backing up data but I got an error message saying that I need to format the disk before using it. Then I tried data recovery software recuva. It said " unable to determine filesystem type". Then I tried Testdisk n through it I recovered 2 partitions but not the C drive. Now I am using Mini tool Partition Wizard but it hangs at 9%. How should I get data from C drive?
 

A:Internal Hard Drive Partition Table Corrupted

Please do not start more than one thread for the same issue.

Closing duplicate.
 

Read other 1 answers
RELEVANCY SCORE 53.2

Hello everyone,
After I used "Acronis Disk Director" in a HirenBoot CD to cut some space from my D drive to my C drive (boot drive), I've got this "Windows is checking the D drive" then "Corrupted master file table. Checkdisk is aborted" on my D drive. After doing some homework, I've tried corrected it by using testdisk's Fix MFT function but "Both of the MFT files are corrupted. Can't fix".
I did not back up the whole partition.
Are there any other ways that I could try to fix this? I do not really want to buy $60 + commercial software that TestDisk recommends just to fix this possibly once-in-a-lifetime issue. However, if recovery softwares is the only option left, then I have to use them.
Cheers guys. I'd really appreciate any help.

A:Corrupted master file table after resizing partitions

You could try running:
MBR - Restore Windows 7 Master Boot Record

Read other 1 answers
RELEVANCY SCORE 53.2

Silly me, I just saw the instructions here on how to post which I somehow missed before:

Is Windows 7 Professional
- x64 (64 bit)
- the original installed OS on the system? yes
- an OEM version
- OEM = NOT pre-installed - I installed myself when I build machine

- age of system (hardware): almost exactly 1 year old
- age of OS installation: almost exactly 1 year old also
- have you re-installed the OS?: no, I have never re-installed the OS

How do I get the dump files from a machine that won't load past the BIOS???

------------------------------------------------------------------
I haven't seen any recent threads on this so here is the situation:
I had a failed Service Pack Install so I ran both the Chkdsk C: /f function and a sfc /scannow System File checker functions as described in this article about Fixing a Failing Windows 7 Service Pack 1 Install.

I then installed and ran the Windows Update Readiness Tool.
Upon a 3rd reboot, I get the following error: 0cx000000e

I used the System Recovery Options from the Windows 7 Install Disk and the Startup Repair has diagnosed:

Test Performed:
Name: Check for updates
Result: Completed successfully. Error code 0x0.
Time Taken = 0 ms

Test Performed:
Name: System disk test
Result: Completed successfully. Error code 0x0.
Time Taken = 0 ms

Test Performed:
Name: Disk failure diagnosis
Result: Completed successfully. Error code 0x0.
Time Taken = 109 ms

Test Performed:
Name: Disk metadata test
Result: Completed successfu... Read more

A:0xc000000e - Partition Table Repair - corrupted F:\windows

Well, I see there has been some views of this post. Any ideas? even a RTFM comment would be appreciated. just tell me which manual. please. thanks.

or even tell me to just do a new install. or is it possible to do a repair install from the installation disk?

Read other 2 answers
RELEVANCY SCORE 53.2

I have a 20G hard disk that is (used to be) divided into 5 partitions.
When my computer booted up yesterday, only the C partition was visible -
the other partitions, containing all my personal files, installed games and
digital photos, had disappeared without a trace. Partition magic, which I had
used to partition the disk in the first place, informs me that "Logical drive
chain points to sector without partition table." Is there some utility that
can recover my partition table for me?
 

A:Any way to rescue corrupted partition table on hard disk?

Disk Doctor, which is part of the Norton Utilities or Norton System Works depending on your OS, may be able to correct your problem.
 

Read other 1 answers
RELEVANCY SCORE 52.8

First of all, I hope this is the correct forum for Windows 2000 Advanced Server questions.

I have a W2k Server, fully patched and running without problems (I thought). It does NOT have Exchange installed! I recently found that old log files in the C:\WINNT\NTDS were filling up the C Drive.

These files have names like:

edb001d5.log 10,240kb 2/7/2004
edb001d6.log 10,240kb 2/10/2004
...
edb002ee.log 10,240kb 3/11/2005

there were 285 of then taking about 3GB of space.

As I understand it these are temporary transaction files for AD and should be not needed after a day or so... I've checked and decreased the Garbage Collection interval to 8 hrs and I've adjusted the logging settings so I'm seeing entries in the Directory Event Log like "Garbage Collection started" and "Garbage Collection Finished, Deleted items: 0" (this is not the exact wordage).

I actually took a chance and moved the older log files dated from 02/2004 through 07/2004 to another folder. The server has been restarted a number of times and has shown no problems so I went ahead and deleted those files.

There are still 168 old log files taking up almost 2 GB of disk space in the NTDS directory. Dated from 8/04 through today.

I have restarted in DS Restore Mode and run NTDSUTIL to check file integrity and also Semantic database analysis. Both completed without errors.

When I restarted the server everything was running fine, but the log files are still there.

The server is re... Read more

A:NTDS Log Files

Read other 7 answers
RELEVANCY SCORE 52.4

I have a Western Digital MyBook ES 500 GB external hard drive (USB and eSATA interfaces) for data backups formatted from a Windows XP PC that I now use with my laptop running Windows 7 64-bit Home Premium. Recently my son connected it to his Apple PC and tried to create a partition to back up his files. Apparently this corrupted the partition table. I can no longer access any data on the hard drive. The drive does not appear in Computer but does appear in Device Manager and Disk Management.

I believe the problem is that the partition table (formatted for Windows) was modified by an Apple computer so that Windows can no longer tell what file system is on the partitions. My son is gone for a month and I no longer have access to his Apple computer so I can't plug the drive into an Apple computer to check if the drive gets detected.

I looked at the drive using:

1. Windows 7 Disk Management
2. Acronis Disk Director 11
3. EASEUS Partition Recovery (latest version)
4. Partition Wizard 5.2

None of them could do anything except delete or format the partitions. I saw no repair option or ability to mark the partitions as NTFS file system.

The partitions on my external drive are still there but no file system is shown for most of them. Acronis Disk Director shows the following information:

Disk 1 (GPT)
VOLUME CAPACITY FREE SPACE TYPE FILE SYSTEM STATUS
EFI 200 MB 200 MB Ba... Read more

A:Corrupted Partition Table on External USB Data Backup Drive

A big chunk is unallocated. Was some of your data there? If so try Partition Wizard Partition Recovery Wizard - Video Help.

See if PW can also run Partition Wizard Check File System which can recover some partitions that are not readable.

If not some success has been reported repairing the partition table using Disk Genius trialware: http://www.diskgenius.net/

Read other 3 answers
RELEVANCY SCORE 51.6

The Directory Service failed to construct a mutual
authentication Service Principal Name (SPN) for server
036381e0-e454-420e-a263-4f3e3e8f7d82._msdcs.jfh.com.au.
The call is denied. The error was:
The DSA object could not be found.

The record data is the status code.
000020e3
This is the error message I get on my forest domain
controllers. I have one child domain and every thing
seems to be working fine. Except I get these error
messages. I have increased the loggin level on NTDS and I
get two futher events. id 1080 and 1173.

I have searched every where and I cannot find any info on
this at all.

Thanks

Greg Gardiner
Systems Administrator
The Age
 

Read other answers
RELEVANCY SCORE 51.6

Hi SF dudes

Just seeking some help with a bsod problem, iv followed the SF bsod posting guide and have collected the dump files(attached), if iv missed something please let me know.

Buils as follows:

CPU: AMD FX 8150 8-core (stock not OC)
Mobo: ASUS Sabertooth 990fx (latest firmware flashed, shows all system correctly)
RAM: Corair Vengence 1600mhz (cmz16gx3m4a1600c9)16gb 4x4gb
GPU: Gigabyte GF GTX670 OC 2gb (as factory, not OC)
PSU: Antec HCG 900w (SLi down the track)
SSD: OCZ vertex 3 240gb
Hdd-1: WD Green 2TB (WD20EARX)
Hdd-2: Old Hitachie 300gb 2.5inch (as per cutomer request)
ODD: LG BD-DVDRW combo (CH12LS28)
WiFi adpt: TP-Link Wireless N pci-e(TL-WN881ND)
OS: Win7 pro 64bit with SP1 Retail with key(not burnt,DLed or USB)
Aftermarket CPU cooler: Corsair H80

So i went through quite abit of ram testing, each dim and each slot tested with win7 memtest, clear with 10 passes each.
Done all win updates, 3 .net framework updates failed(could be a lead)
Device list shows all driver working, (no(!))
I dont want to rant but there are other details that could help so just ask for the specific info/data/spec and ill post.
I checked out the SF tool files but...
So if a few minidump & debug gurus could jump in here and take a look it would be great.
Thanks in advance and happy computing

Ronyart

A:New Build, Bsod at randow. Stop:0x1a sub:41790 table page corrupted

A few extra details:\

Temp:
CPU: Idel 30-35 Load 42-46
MoBo: Load 36-42
GPU: Load 36-48
Collected using Asus Ai Suit(UptoDate)

All Bsod are Memery_Managment, stop:0x0000001a
with almost all 1st sub codes being 41790-table page corrupted

The GPU driver has me worried, everytime i go into device manager and hit the auto update button for the GPU the screen flickers and jumps but to generic stock resolution and fails to even see the driver, just shows generic driver,to resolve this i must uninstall then reinstall the driver but the same thing still happens with the update button even after the reinstall
Lets Go SF, hit me!

Read other 4 answers
RELEVANCY SCORE 48

2012R2 box won't join the domain, tried reseting computer object, tried deleting it/recreating it...  
Any ideas on where to fix the currupted policy table?  


Eventxmlns="http://schemas.microsoft.com/win/2004/08/events/event">
-
<System>
 
<Provider
Name="Microsoft-Windows-DNS-Client"Guid="{1C95126E-7EEA-49A9-A3FE-A378B03DDB4D}"
/>
 
<EventID>1023</EventID>

 
<Version>0</Version>

 
<Level>2</Level>

 
<Task>1023</Task>

 
<Opcode>0</Opcode>

 
<Keywords>0x4000000010000000</Keywords>

 
<TimeCreated
SystemTime="2020-04-30T22:00:24.021435100Z" />

 
<EventRecordID>181636</EventRecordID>

 
<Correlation
/>

 
<Execution
ProcessID="1052"ThreadID="3892"
/>
 
<Channel>System</Channel>

 
<Computer>dcmitvmlgc002</Computer>

 
<Security
UserID="S-1-5-20" />

 
</System>
-
<EventData>
 
<Data Name="RuleName">{b76ed7a8-be84-4713-9504-6fb495209d03}</Data>

 
<Data Name="ErrorCode">1018</Data>

 
</EventData>
 
</Event>

Read other answers
RELEVANCY SCORE 48

 Event viewer displayed an error message Master File Table contains a corrupted file record . This system has no other symptoms.  I have run chkdsk /f and it did clean up/moving of the files it did not fix the MFT.  Can this been done with utility Dell Backup and Recovery or do I need a 3rd party program such as TestDisk?

Read other answers
RELEVANCY SCORE 47.6

https://gist.github.com/TrueToonatio...fe4795caf4f73e

Hi I've ran a mem check through windows and it says my ram is fine. I was thinking of re-flashing my motherboard.
The story:
A week and a half ago I had to go back to windows 7 from windows 10. I did a clean install with a boot drive everything seemed fine then this blue screen happened. Updated it and everything the blue screen happened again. So... I reinstalled windows 7 again from my CD this time and wanted to upgrade to windows 10 and I got Safe OS error. Tried it with a boot driver had the same error again. Then it blue screened again. So I reinstalled windows up Updated it completely and it messed up with the updates.
I reseatted my ram switched slots reseated my gpu etc. I do not know why windows 7 is being so unstable when everything was fine when I had windows 10. I'm thinking its a driver issue but I do not know where to look.
Currently this version of windows 7 SP 1 I have only has a few updates. IE 11 has direct x stuff etc.

Win7 on SSD
two secondary hard drives
M4-CT1128M4SSD2 ATA Device
ST10000DM003-9YN162 ATA Device
WDC WD101EZEX-00BN5A0 ATA Device
Sapphire 7950 as gpu
i5 3570k cpu
biostar motherboard B75MU3B LGA 1155
Ram Patriot Gamer 2 DDR 3 PGD38G1600ELK 8GB

The computer can run hours at a time without blue screening
TLDR: installed windows 7 around 4 times still same problem

A:Blue Screen: A page table page has been corrupted win7?

Hello Toonation and welcome to 7forums!

Please run this as it will help us help you:

Blue Screen of Death (BSOD) Posting Instructions

The dump files are a good start but to reach the finish line we need more!

Cheers, Boris

Read other 2 answers
RELEVANCY SCORE 43.2

I have a Make Table query that when I run it and view the table in the query it shows only the data I want. But when I go and open the table that theis query made, there are entries that should not be there.

It is putting in rows with blank fields, I am not sure how to stop it. I have tired to put something in the query for that field but I get back the error "Invalid Use of Null"

If I could put in the criteria that worked I would be all set.

Any ideas?
 

A:Solved: Access (Make Table) Query Results Returned not Same as Table

Read other 6 answers
RELEVANCY SCORE 43.2

A previous thread indicated problems encountered when trying to update a Table of Contents and Table of Figures, etc. using Word 2007. I couldn't find any solutions to that message. I am having the same problem. I tell it to update the Table of Contents or Table of Figures, and it does that correctly, but as soon as I click "print" the page numbers all change to 2! Any ideas?
 

A:Solved: Word 2007 - Page Number Issues Updating Table of Contents and Table of Figure

Read other 12 answers
RELEVANCY SCORE 43.2

I would like to populate an excel sheet with the values that are there in another adjoining sheet (The excel file is the same). The issue here is the data in the adjoining sheet table is pivoted. So what I want is:
Sheet 1 (Columns): Server_Name, Oracle - Category backup etc
Sheet 2 (Columns): Server_Name, Monitors only and the monitors here have different values for each server.

Sample for Sheet 2:

Here is an excerpt from the first pivoted data sheet. This is my sheet 2 (the pivoted table) and my first sheet is the same as above.
sDisplayName sMonitorTypeName sMonitorTypeDescription (Placeholder?)
AQUA3 AQUA3 - AOL Jobs Monitors the ETL jobs on AQUA3
RPC Service NT Service Monitor
SNMP Test availability of SNMP
AQUA4 Oracle - Category backup Active Script Monitor
Oracle - DataPump backup Active Script Monitor
Oracle - DBA account created Active Script Monitor
Oracle - Keep Cache Active Script Monitor
Oracle - locked accounts Active Script Monitor
Oracle - RMAN backup Active Script Monitor
OracleDBConsoleORCL NT Service Monitor
AQUAMARINE3 RPC Service NT Service Monitor
SNMP Test availability of SNMP
BASIL3 RPC Service NT Service Monitor
SNMP Test availability of SNMP
BERYLLIUM1 Beryllium 1 - Eon Incremental Monitors the ETL jobs on Beryllium 1
RPC Service NT Service Monitor
SNMP Test availability of SNMP
BERYLLIUM2 Oracle - DBA account created Active Script Monitor
Oracle - Keep Cache Active Script Monitor
Oracle - locked accounts Active Script Monitor
OracleDBConsoleCBORC... Read more

Read other answers
RELEVANCY SCORE 43.2

hi,

Just wondering if anyone could tell me if and how i can revert back to an older version of a table.

I had a table saved contain product details
whilst i was away a work mate accessed the table deleted some colums and saved over the table.
i was just wondering if the was anyway to undo this save, or if a back of the previous table could be found somewhere.

using Access 2000 on Win XP (no restore point available).

thx in adv.
Dam
 

A:Access 2000 table backups? / undo a save to a table

No.
Not unless it's on a drive where you have been backing up the entire database or have specifically set up for the database to backup the data...
 

Read other 1 answers
RELEVANCY SCORE 43.2

If I move a table row in Word 2007, it seems to split the table at the point it is inserted. The row above gets the table bottom formatting, the row I insert gets both table top and table bottom, and the next row gets table top. If I hover the mouse at the start of the inserted row it offers me the table start marker, as does hovering over the next row. This happens whether I drag and drop or cut and paste.

What&#8217;s going on, and how can I insert the row as part of the existing table, or at least re-merge the tables back to one again? I never had this problem with 2003.

Thanks,

Ian
 

Read other answers
RELEVANCY SCORE 42.8

hello,
I have created a make table via a parameter query. The parameters are defined correctly and I am prompted each time to enter them. the DeptNo does work as my query is filtered based on a value entered, but when I enter the tablename parameter, the make table query always saves the table as @tablename, and not any text i enter for the @tablename like "mynewtable" or something. Here is the SQL code.
Any ideas? Ignore the complexity of the query, my main concern is being able to loop through some VBA code and continually change the tablename each time (along with the DeptNo. I think this will save me time vs creating a new sql statement each time and doing a docmd.runsql ...
Thanks.

PARAMETERS DeptNo Text ( 255 ), [@TableName] Text ( 255 );
SELECT AUMaster.Lawson, ChgMstr.DEPT, ChgMstr.[CHG CD], ChgMstr.[REVENUE DESCRIPTION], [Prior and Curr Year Revenue - Qty].Price, ChargeCodeProfile.[Count per Charge] AS Weight, [Prior and Curr Year Revenue - Qty].[2006 Projected Quantity], [Prior and Curr Year Revenue - Qty].[2006 Projected Revenue], [Prior and Curr Year Revenue - Qty].[2007 Projected Quantity], [Prior and Curr Year Revenue - Qty].[2007 Projected Revenue] INTO [@TableName]
FROM ((ChgMstr LEFT JOIN [Prior and Curr Year Revenue - Qty] ON ChgMstr.[CHG CD] = [Prior and Curr Year Revenue - Qty].ChargeCode) LEFT JOIN ChargeCodeProfile ON ChgMstr.[CHG CD] = ChargeCodeProfile.[CHG CD]) LEFT JOIN AUMaster ON ChgMstr.DEPT = AUMaster.Affinity
WHERE (((ChgMstr.DEPT)=[D... Read more

A:Parameter Make Table Query-passing the table name - HELP!

Read other 10 answers
RELEVANCY SCORE 42.8

http://www.mediafire.com/?8bbfjsbun24m74z

In this database, i have a data entry form called "Information Requested" and all information in this form when entered are added into table Information Requested. In the form, 3 fields Names, Business Units and Emails are drop down lists based on table Contact List. However, what the form does now is i have to pick the name, business unit and email manually. It's not really efficient this way. what i want is when i pick the name, the corresponding business unit and email of that person will automatically show up in the box. How can I achieve this?
 

A:[Access 2010] How to append record from one table to another table.

The data should NOT be transferred to the table, only displayed on the Form, as it should only be entered once.
You can display it on the form by including the data in the Combo as a "Concatenated" field or you can transfer the data to "Unbound" fields.
 

Read other 1 answers
RELEVANCY SCORE 42.8

Hey there folks...
I am in need of some assistance. Obviously!

I need a form which allows a user to select a record from one table and completely move the record to a totally separate table in the same database. I need it to transfer all the data for the selected record.

AutoNumber will not be an issue as each record has unique identifiers.

I found this article online but it seems it will append ALL data and doesn't allow a user to select the correct record. This uses an Append Query which makes sense but again it seems as though it will transfer ALL records. All I need is for it to transfer a specific record depending on the user's selection in the form.
 

A:MS Access 2007: Moving a record from one table to another table...

Is this to "Archive" the record?
It is not normally necessary to actually "Move" a record, as you can just have a tick box called archive or similar that can be used to exclude that record from normal display and to display it as an Archived record.
There are 2 ways to do what you want, if it is really necessary, one is using an Append query, you can Identify the currently selected record on the Form using
forms![Form Name]![name of Key Field]
in the First Criteria row of your Key field, where Form name is the actual name of your form and name of Key Field is the actual name of your Key Field.
The other version is to use a VBA recordset Clone to do the same thing.
The
 

Read other 1 answers
RELEVANCY SCORE 42.8

I'm trying to run a clear table query (to keep the table, but delete the data), and then an append query to repopulate the table, and it's not working.

...any idea what I'm doing wrong?
 

A:ACCESS clear table/append table not working?

Read other 11 answers
RELEVANCY SCORE 42.8

I have different mailing lists that I want to add to a mailing list in my database. There may be duplicate addresses in these lists. I want to only add an Address, FirstName, LastName record once. So how do I combine these lists with my original list without adding a duplicate Address, FirstName, LastName record?
 

A:importing data from a table to another table without adding duplicates?

Read other 6 answers
RELEVANCY SCORE 42.8

I am having trouble updating data from one table to another. I am not Appending the data.

I've linked the two tables on an ID field.
I created a select query to see the data I would update.
I changed the query to an Update query.
In the Update To field I placed the following: [table].[field name]

After running the query I noticed the update did not work. The data from the first Table did not get updated to the second Table it wound up being deleted from the first Table.

Your help is appreciated.

Buttercup
 

A:Solved: Access 2003 Update Table from another Table

Buttercup1, welcome to the Forum.
I am not sure why you wan to update the second table with data from the first table.
Can you show me a screenshot of your query with the table(s) in and also your Table relationships?
 

Read other 3 answers
RELEVANCY SCORE 42.8

Hi there,
I am not that cluey with access vba programming and I need some help please.
I have a Table called (Parts) with columns (PartName), (PartNumber), (PartCost), (Quantity)...
I have (Parts) table linked to (Repairs) table in one to many relationship.
I have a Form linked to the table (Repairs) with different fields to enter different repair details.
Among these fields is: combo box (PartsNameCombo) where you can select the Part Name from values listed in (PartName) column in table (Parts), and I have used the following codes to populate the selected part's cost accordingly:

Private Sub PartNameCombo_Change()
'Auto populate Part cost based on Part Name
Me.PartCost.Value = Me.PartNameCombo.Column(2)
End Sub

I have repeated the above combo box three times (in case different parts used in one repair).

My Question: I would like to add code to automatically subtract (1) from part's Quantity in (Parts) table whenever a particular (PartName) is selected in the combo box.
so for example, if in a repair, I selected: (front case) in the first combo box and (display screen) in second combo box, I want the cases quantity to drop by one and also screens quantity to drop by 1?
Any one can please help?
 

A:Updating table value when different table form field updated

At least two ways to do this but I wouldn't make it automatic. What if the wrong Part name was inadvertently selected? I would ad a button to the form "Take one from Inventory" and execute an update query that basically does Quantity= Quantity-1 . This query would need to link to PartNumber on the active form.

The other way would be to write the SQL to do the update in VBA and run the EXEC SQL command under the new button.
 

Read other 2 answers
RELEVANCY SCORE 42.8

I am starting this Access database from scratch. I have to import/upload a sales file weekly. I will be adding this file to a main sales data table. The issue I have is that this file does not have any dates on it. I need to be able to add a start and end date to the table.

Example fields that I would need/have

Need:
start date
end date

Have:
Item #
Store #
Sales Units
Sales Dollars

What is the best way to handle this? I have an idea - just not sure what order I should put my steps for importing the file, asking for the date range, adding the date to the table, etc....
 

A:Solved: Access - import table - add date to table

Read other 9 answers
RELEVANCY SCORE 42.8

I put a table into a doc file and decided later I didn't need it there, so I used the Control key and down arrow to highlight it then hit Delete. The table disappeared, BUT now, every time I open the .doc, I get the following warning.
How do I get rid of it without having to print out the entire 5 page document then retyping it?

 

A:Wodrd2K fives warning about corupted table in a .doc, but there's NO table!

Try saving the document as a text file (*.txt). This will get rid of all the formatting, leaving just the text. Hopefully, this will get rid of the reminants of the table. Take it back into Word and then redo the formatting.
 

Read other 2 answers
RELEVANCY SCORE 42.8

Hi there,
I am not that cluey with access vba programming and I need some help please.
I have a Table called (Parts) with columns (PartName), (PartNumber), (PartCost), (Quantity)...
I have (Parts) table linked to (Repairs) table in one to many relationship.
I have a Form linked to the table (Repairs) with different fields to enter different repair details.
Among these fields is: combo box (PartsNameCombo) where you can select the Part Name from values listed in (PartName) column in table (Parts), and I have used the following codes to populate the selected part's cost accordingly:

Private Sub PartNameCombo_Change()
'Auto populate Part cost based on Part Name
Me.PartCost.Value = Me.PartNameCombo.Column(2)
End Sub

I have repeated the above combo box three times (in case different parts used in one repair).

My Question: I would like to add code to automatically subtract (1) from part's Quantity in (Parts) table whenever a particular (PartName) is selected in the combo box.
so for example, if in a repair, I selected: (front case) in the first combo box and (display screen) in second combo box, I want the cases quantity to drop by one and also screens quantity to drop by 1?
Any one can please help?
 

A:Updating table value when different table form field updated

Read other 16 answers
RELEVANCY SCORE 42

Hi, i'm new in using excel macro and vba. In my workbook, there are large amount of uncluttered data in many table in one worksheet. I need help how to combine/merge/join multiple table in one worksheet into one master table into another worksheet using userform? i'm sorry if my explanation is confusing because I'm not so good in English. thank you for any help.
 

Read other answers
RELEVANCY SCORE 42

Hi there,

I have excel 2007 and I am trying to delete a table I put in. (Insert > Table) The problem is when i do this it deletes the data within the table. I dont want to have to delete the table and put in all the information again. Is there an easy way to do this? I looked at a similar post and it said to press the filter button on the data tab. This does nothing.

Any help or suggestions would be greatly aprreciated.

cheers.
 

A:Removing a Table without deleting the data within the table!

Read other 16 answers
RELEVANCY SCORE 40.4

Hello!

I am new to the IE Forum!

I would like help with IE 7 keyboard/mouse commands for choosing tables and table elements (i.e. <TD>). I know this is no problem in Firefox. If I want to choose a <TD> element in FF, all I have to do is point to the element I want and press the Ctrl + <left mouse> and the element is chosen. If I want to choose a whole table in FF, all I have to do is place my mouse beside the table and press the Ctrl + <left mouse> and the complete table is chosen.

My question is, can I do something similar with Internet Explorer? I hope so, I am running another application that works better in IE.

Thanks for any help on this matter!

Gary

Read other answers
RELEVANCY SCORE 40.4

I have two access tables I would like to merge data into one table. How to do?

I tried blank database importing one by one but result is I get two tables not one.
 

A:Importing data from one table into another table

You are going to have to write an insert query. If you view it in SQL mode it would look something like:

INSERT INTO MyTable1
SELECT *
FROM MyTable2;
 

Read other 2 answers
RELEVANCY SCORE 38

I have a database that i'm creating that has 3 different tables. Its for safety violations at work. One table is the innitial one that has all the pasic information on it. I set it up so that it automatically assigns a number to each complaint filed. The other two are for follow up. One is for how the problem is going to be fixed and who is supposed to do it, And the other one is for verification to make sure that the problem has been fixed. My problem is that i want the two follow up tables to automatically import the complaint number when a new complaint is filed. I tried to set everything up myself, but had no luck. Can someone please help? Thanks.
 

A:Solved: update the column in one table based on the column of another table

Read other 16 answers
RELEVANCY SCORE 38

MS Access:
I have several fields in a form that uses two tables. I would like to set up a command button so that when you are on a current record, it will copy the field information from the record you are on to other fields in the same record. I do not know the SQL commands to set this up.

For example, there are name fields, address fields, and phone to be copied. Reason: One is contact information; one is survey information. In most cases the information is the same but on rare instances, the information needs to be entered (when different).
This is not an update for all records in the database. This is based individually on each record.
Not sure if you need to do On current, on click, or after update.
Not sure if default value in form can be used.
Please help.
 

A:Copy data fields in same table to other fields in same table MS Access

Read other 16 answers
RELEVANCY SCORE 38

First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. Moving on...

My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so often that each week I have a whole schedule to plug in. I'd like to automate the process. Pulled directly from the clipboard, the table looks like this: EDIT: this forum doesn't seem to keep tables and wants it vertical like this. Just imagine the text is in a horizontal table.

12:30 pm - 07:15 pm
Front Service Clerk
M: 04:00 pm - 04:30 pm


06:30 am - 11:15 am
Front Service Clerk

01:15 pm - 11:00 pm
Front Service Clerk
M: 06:00 pm - 07:00 pm

12:00 pm - 03:00 pm
Front Service Clerk

08:00 am - 02:45 pm
Front Service Clerk
M: 10:15 am - 10:45 am



Is there a way to make a macro to pull the time and put it into the time section of an iCalendar file, pull the "M" and put it into the "location" section, while ignoring the "Front service clerk" section? Important: Saturday is the first day of the week. Also, days I don't work are blank and get copied into the table. Any way to fix that? Preferably it'd then save it as an .ics file, but it can just put it out in ics format and I can change the file extension.
Thanks.

Read other answers
RELEVANCY SCORE 38

First off, yes I want an iCalendar vs an Outlook calendar file because, heresy of heresies, I prefer Thunderbird to Outlook. Moving on...

My work doesn't offer an option to download the weekly schedule as a file, and my schedule changes so often that each week I have a whole schedule to plug in. I'd like to automate the process. Pulled directly from the clipboard, the table looks like this:

01:45 pm - 11:00 pmFront Service Clerk
M: 05:00 pm - 06:00 pm

06:30 am - 12:30 pmFront Service Clerk
M: 09:00 am - 10:00 am

02:00 pm - 11:00 pmFront Service Clerk
M: 05:45 pm - 06:45 pm

06:30 am - 03:45 pmFront Service Clerk
M: 09:15 am - 10:15 am

01:45 pm - 06:30 pmFront Service Clerk
M: 04:15 pm - 05:00 pm



Is there a way to make a macro to pull the time and put it into the time section of an iCalendar file, pull the "M" and put it into the "location" section, while ignoring the "Front service clerk" section? Important: Saturday is the first day of the week. Preferably it'd then save it as an .ics file, but it can just put it out in ics format and I can change the file extension.
Thanks.

Read other answers
RELEVANCY SCORE 37.6

Hello all,

My copy of Windows 7 Home Premium x64 on my laptop has been having some strange issues lately. I cannot run .msi files, and device manager never populates a full list. Sometimes (rarely, but it does repeat) Windows Explorer will freeze, and if I attempt to close it and reopen it using task manager, the UI reloads, but whenever I click on a folder it claims Windows cannot load explorer. Restarting fixes that. I scheduled and ran CHKDSK, and it repaired a few bad sectors, but it didn't fix any of these problems. I have run CCleaner (both the regular cleaner and registry fixer) and defragmented my hard drive until it's only 1% fragmented. I then tried sfc /scannow, and it read a bunch of corrupted files but could not repair them. I read that to fix sfc, you must download and run Windows System Update Readiness Tool. It has been running and "Searching for Updates on this Computer" for about an hour now, and I'm getting concerned that it's just not doing anything. It's not frozen, the bar keeps moving from left to right and I can click on and off of it. I also have the logs from sfc if anyone wants to take a look at them, they'll be attached. The computer isn't very old, and has an intel i3 and 4gb of ram. If you would like any extra information to help, please reply and I'll get back to you as fast as I can Any recommendations on where to go from here would be greatly appreciated.

Thanks so much for any and all help!

A:Many corrupted Windows7 files, SFC reads corrupted data but doesnt fix

Hi Qujibo,
First comment you said ran ccleaner REGISTRY cleaner, this is not advised, unless you know what your doing

If there is an UNDO backup from that utility RUN it.

SURT can quite easily run for a couple of hours.

There are a lot of Winsxs errors in your log.

AFTER surt has run

REBOOT

run the MXdiag report from this link
Windows Genuine and Activation Issue Posting Instructions

Was this OS only installed via sysprep a couple of days ago??

Roy

Read other 2 answers
RELEVANCY SCORE 37.6

This problem started a couple days ago. There doesn't seem to be a user initiated trigger, as it first happened after the computer was idling for a while, and subsequent crashes/problems occurred at various times in various circumstances, all the while getting worse. I'll elaborate below, but first:HardwareMotherboard: Gigabyte GA-P35-DS3LProcessor: Q6600Memory: 2x 1GB Ballistix (on QVL)Hard Drive: 500GB Seagate 7200.11Video Card: MSI 8800GTPSU: 630W RaidmaxSoftwareOS Version: Windows XP Pro 32 bit, 5.1.2600 Service Pack 2 Build 2600Antivirus: NOD32Firewall: Zone AlarmThe ProblemThe computer is almost exactly two months old, and was running perfectly up until this point when, as stated, it crashed seemingly randomly and never stopped crashing since.The first error I was not around for. I came back to my computer to find it was in an infinite BSOD-reboot loop, where it would clear POST and the Windows splash screen would pop up for about three seconds followed by an instant BSOD. It probably was going on for a good 20-30 minutes before I stopped it, which I did by completely powering down the system and then restarting. When Windows loads, it pops up the message 'Windows has recovered from a serious error'. I send the error report and it says everything is unknown except that it was caused by a driver, but doesn't know which driver. I figured it must have been a random thing, because I hadn't updated any drivers since first building the computer, ... Read more

A:Bsods And Corrupted File System Structure And Corrupted Drivers, Oh My

all of your hardware seems made by reputable companies but for onePSU: 630W RaidmaxEverybody makes a few bad power supplieshttp://www.newegg.com/Product/ProductRevie...False&Page=Did the gigabyte mobo come with some monitoring software utilities?

Read other 4 answers
RELEVANCY SCORE 37.2

Hello,
today I am posting in the Eight Forums to ask about how to fix a corrupted looking Windows 8 start menu with no corrupted files found. I know that's a really bad way to explain the situation. I have uploaded a screenshot which I hope explains the issues. I wanted to add the blank squares do not work and also the Maps button.
Thanks
Emaunel

A:Windows 8 Start Menu Looking Corrupted; No corrupted files

Repair the start screen, see here:

Apps and Tiles Not Working or Responding: Fix in Windows 8

Read other 1 answers
RELEVANCY SCORE 37.2

So, I reformatted my computer again. Did some SFC scans before I installed any Microsoft updates and all scans were clean. Did all the updates, drivers, program installations. Couple days later I decide to check with SFC and found some errors. There's also errors at the source, meaning I can't replace them correct? This seems kind of stupid. Always having corrupted files no matter how many times I reformat.

A:Corrupted Files + Unable to Repair + Corrupted Source

Hello ecko69x

From the last entry in your report below, it looks like they have been repaired, and you are good to go.

"Verify and Repair Transaction completed. All files and registry keys listed in this transaction have been successfully repaired"

Read other 7 answers
RELEVANCY SCORE 36.8

Hello, I've been struggling with getting a simple InfoPath 2007 form to work with a test MS Access 2007 database. I feel the best way to explain what I am doing is by giving you an example.

Background of scenario:

Lets say I am a distributor of gas cylinders. I have 100 different gas cylinders that I fill and send to customers. When they are done with the gas, they return the cylinders and I fill them back up. Each cylinder has specific data related to each: manufacturer, serial #, specific cylinder ID, and material of construction (carbon steel, stainless steel, etc). I have this data in my MS Access database, in an individual table called "CYLINDER_DATA". Every time I refill a cylinder, I need to record the date and measure the pressure and temperature (among other things) of the gas in the cylinder. This data (along with the specific "CYLINDER_DATA" at this date of measurement) must be added as a new record in a different table called "CYLINDER_MEASUREMENTS" in the same database.

What I would like to do:

So, I want to create an InfoPath form for operators to use whenever they need to perform measurements on a newly filled cylinder. So, I created an InfoPath form, that starts with a drop-down list box control that is populated with the 100 different cylinder IDs. A user would choose one of the "cylinder IDs" from the drop down list and then click "retrieve data". This would then populate the fields directly below:... Read more

Read other answers
RELEVANCY SCORE 36.4

This has been going on for 3-4 months. Sfc will detect errors it cannot fix, then 5 minutes later, sometimes hours later, sfc will not detect any errors. This happens over and over again every single day typically. Longest it never happened was a week when
I ran a program to watch for file modifications of the culprit file. It also says the files in store are corrupted, which they are apparently not.

After a strange system crash said i had one minute to save my files, I rebooted, ran sfc /scannow, jumped to c:\windows\syswow64\comsvc.dll, its hash had changed. (this is the second or third time I saw this file with a unique hash
the hash change is always the same- usually it detects some integrity violation but the file hash remains unviolated, it says tried to replace but files in store are also corrupted, but hashes in store were the same as original files sent to
me by a Windows Update Senior Analyst) I made a copy of the changed file. Sfc said it could not repair the file. Immediately after, I ran another sfc /scannow and there were no violations. The file hash had also returned back to normal. Not sure if sfc repaired
the file, but couldn't repair the files in store, which are the usual culprits. 

Here are both logs and copies of the same dlls with different hashes + Surt log, CBS log.
https://drive.google.com/open?id=1VEtfN7Wsj4XrmVsV2gRSxza92zQg-COu

There is a one byte difference on line 4804


w??u?M9}t?M?P??... Read more

Read other answers