• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Recover access database

Status
Not open for further replies.
Joined
May 28, 2012
Messages
59 (0.01/day)
Hi
Our company pc just died. I copied everything that was on the hdd to this new pc.
When I try to open the access database, none of the buttons on the form work.
I can see all of the tables are still there, but sadly they don't seem to be connected.
I tried making a special partition again so the path would be the same on this new pc, but it doesnt work that way. Can you please help me out here ? All of our companies data is in this file...
Cheers
 
Joined
Sep 2, 2011
Messages
702 (0.15/day)
Location
Where the hand of man has never set foot
Processor AMD Ryzen 5 3600X
Motherboard ASUS TUF GAMING X570-PLUS
Cooling Noctua NH-D15 SE-AM4
Memory 2x8GB G.SKILL Ripjaws V DDR4-3200MHz CL16 1.35V
Video Card(s) MSI Radeon RX 6600 XT Gaming X 8G
Storage Crucial MX100 512GB + Samsung 870 EVO 2TB
Display(s) MSI Optix MAG24C
Power Supply Seasonic FOCUS GX-550
Mouse Razer Viper Ultimate
Keyboard Corsair K60

Mindweaver

Moderato®™
Staff member
Joined
Apr 16, 2009
Messages
8,193 (1.50/day)
Location
Charleston, SC
System Name Tower of Power / Sechs
Processor i7 14700K / i7 5820k @ 4.5ghz
Motherboard ASUS ROG Strix Z690-A Gaming WiFi D4 / X99S GAMING 7
Cooling CM MasterLiquid ML360 Mirror ARGB Close-Loop AIO / CORSAIR Hydro Series H100i Extreme
Memory CORSAIR Vengeance LPX 32GB (2 x 16GB) DDR4 3600 / G.Skill DDR4 2800 16GB 4x4GB
Video Card(s) ASUS TUF Gaming GeForce RTX 4070 Ti / ASUS TUF Gaming GeForce RTX 3070 V2 OC Edition
Storage 4x Samsung 980 Pro 1TB M.2, 2x Crucial 1TB SSD / Samsung 870 PRO 500GB M.2
Display(s) Samsung 32" Odyssy G5 Gaming 144hz 1440p, ViewSonic 32" 72hz 1440p / 2x ViewSonic 32" 72hz 1440p
Case Phantek "400A" / Phanteks “Enthoo Pro series”
Audio Device(s) Realtek ALC4080 / Azalia Realtek ALC1150
Power Supply Corsair RM Series RM750 / Corsair CXM CX600M
Mouse Glorious Gaming Model D Wireless / Razer DeathAdder Chroma
Keyboard Glorious GMMK with box-white switches / Keychron K6 pro with blue swithes
VR HMD Quest 3 (128gb) + Rift S + HTC Vive + DK1
Software Windows 11 Pro x64 / Windows 10 Pro x64
Benchmark Scores Yes
Joined
May 28, 2012
Messages
59 (0.01/day)
That just tells you to copy and paste ? I then searched the linked table manager and got http://office.microsoft.com/en-us/a...d-path-for-linked-tables-mdb-HP005187623.aspx there.
After completing that, it still doesn't work.
edit: there still seems to be a temp file in there. the pc must have shut down with access still open
edit2: I have found another, previous version (from 2007). Its the same database, the data is just very outdated. Can i import the 2014 data into the 2007 database file somehow ?
 
Last edited:

Mindweaver

Moderato®™
Staff member
Joined
Apr 16, 2009
Messages
8,193 (1.50/day)
Location
Charleston, SC
System Name Tower of Power / Sechs
Processor i7 14700K / i7 5820k @ 4.5ghz
Motherboard ASUS ROG Strix Z690-A Gaming WiFi D4 / X99S GAMING 7
Cooling CM MasterLiquid ML360 Mirror ARGB Close-Loop AIO / CORSAIR Hydro Series H100i Extreme
Memory CORSAIR Vengeance LPX 32GB (2 x 16GB) DDR4 3600 / G.Skill DDR4 2800 16GB 4x4GB
Video Card(s) ASUS TUF Gaming GeForce RTX 4070 Ti / ASUS TUF Gaming GeForce RTX 3070 V2 OC Edition
Storage 4x Samsung 980 Pro 1TB M.2, 2x Crucial 1TB SSD / Samsung 870 PRO 500GB M.2
Display(s) Samsung 32" Odyssy G5 Gaming 144hz 1440p, ViewSonic 32" 72hz 1440p / 2x ViewSonic 32" 72hz 1440p
Case Phantek "400A" / Phanteks “Enthoo Pro series”
Audio Device(s) Realtek ALC4080 / Azalia Realtek ALC1150
Power Supply Corsair RM Series RM750 / Corsair CXM CX600M
Mouse Glorious Gaming Model D Wireless / Razer DeathAdder Chroma
Keyboard Glorious GMMK with box-white switches / Keychron K6 pro with blue swithes
VR HMD Quest 3 (128gb) + Rift S + HTC Vive + DK1
Software Windows 11 Pro x64 / Windows 10 Pro x64
Benchmark Scores Yes
If the data isn't corrupt in the correct db then you should just be able to mount the db, and the link information.
 
Joined
May 28, 2012
Messages
59 (0.01/day)
update: I fixed the old pc, and everything still works. However, both pc have to run for the db to be useable, and it can only be opened at 1 pc at a time. I tried converting the file from mdb to accdb and copied that to the new pc, but that just opens an empty database.
Is there something I can do on one of the 2 old pc's that merges all the data with its links into a single file that can easily be transfered between devices ?
 
Joined
Feb 19, 2006
Messages
6,270 (0.95/day)
Location
New York
Processor INTEL CORE I9-9900K @ 5Ghz all core 4.7Ghz Cache @1.305 volts
Motherboard ASUS PRIME Z390-P ATX
Cooling CORSAIR HYDRO H150I PRO RGB 360MM 6x120mm fans push pull
Memory CRUCIAL BALLISTIX 3000Mhz 4x8 32gb @ 4000Mhz
Video Card(s) EVGA GEFORECE RTX 2080 SUPER XC HYBRID GAMING
Storage ADATA XPG SX8200 Pro 1TB 3D NAND NVMe,Intel 660p 1TB m.2 ,1TB WD Blue 3D NAND,500GB WD Blue 3D NAND,
Display(s) 50" Sharp Roku TV 8ms responce time and Philips 75Hz 328E9QJAB 32" curved
Case BLACK LIAN LI O11 DYNAMIC XL FULL-TOWER GAMING CASE,
Power Supply 1600 Watt
Software Windows 10
Joined
May 28, 2012
Messages
59 (0.01/day)
maybe this would help? Easy Office Recovery 2.0 and today it is free. http://www.giveawayoftheday.com/easy-office-recovery-2-0/
Normally it cost $59.95
"The program restores Word, Excel, PowerPoint and Outlook files." No good for my access problem it seems.

Anyway, there is a 4.5mb .mbd file which gets all it's data from a 19mb .dat file. Given that this .dat file was accesible through both pc's, i'm guessing the .mdb just has basic stuff in it.
I'll provide both files to whoever want to help me out here.
 
Joined
Feb 19, 2006
Messages
6,270 (0.95/day)
Location
New York
Processor INTEL CORE I9-9900K @ 5Ghz all core 4.7Ghz Cache @1.305 volts
Motherboard ASUS PRIME Z390-P ATX
Cooling CORSAIR HYDRO H150I PRO RGB 360MM 6x120mm fans push pull
Memory CRUCIAL BALLISTIX 3000Mhz 4x8 32gb @ 4000Mhz
Video Card(s) EVGA GEFORECE RTX 2080 SUPER XC HYBRID GAMING
Storage ADATA XPG SX8200 Pro 1TB 3D NAND NVMe,Intel 660p 1TB m.2 ,1TB WD Blue 3D NAND,500GB WD Blue 3D NAND,
Display(s) 50" Sharp Roku TV 8ms responce time and Philips 75Hz 328E9QJAB 32" curved
Case BLACK LIAN LI O11 DYNAMIC XL FULL-TOWER GAMING CASE,
Power Supply 1600 Watt
Software Windows 10
What version of MS Access was the file created with? I have 2007. Also keep in mind your companies CDC policies.
 
Joined
Feb 19, 2006
Messages
6,270 (0.95/day)
Location
New York
Processor INTEL CORE I9-9900K @ 5Ghz all core 4.7Ghz Cache @1.305 volts
Motherboard ASUS PRIME Z390-P ATX
Cooling CORSAIR HYDRO H150I PRO RGB 360MM 6x120mm fans push pull
Memory CRUCIAL BALLISTIX 3000Mhz 4x8 32gb @ 4000Mhz
Video Card(s) EVGA GEFORECE RTX 2080 SUPER XC HYBRID GAMING
Storage ADATA XPG SX8200 Pro 1TB 3D NAND NVMe,Intel 660p 1TB m.2 ,1TB WD Blue 3D NAND,500GB WD Blue 3D NAND,
Display(s) 50" Sharp Roku TV 8ms responce time and Philips 75Hz 328E9QJAB 32" curved
Case BLACK LIAN LI O11 DYNAMIC XL FULL-TOWER GAMING CASE,
Power Supply 1600 Watt
Software Windows 10
And what version are you trying to run the 2003 Access database on?
 
Joined
Feb 19, 2006
Messages
6,270 (0.95/day)
Location
New York
Processor INTEL CORE I9-9900K @ 5Ghz all core 4.7Ghz Cache @1.305 volts
Motherboard ASUS PRIME Z390-P ATX
Cooling CORSAIR HYDRO H150I PRO RGB 360MM 6x120mm fans push pull
Memory CRUCIAL BALLISTIX 3000Mhz 4x8 32gb @ 4000Mhz
Video Card(s) EVGA GEFORECE RTX 2080 SUPER XC HYBRID GAMING
Storage ADATA XPG SX8200 Pro 1TB 3D NAND NVMe,Intel 660p 1TB m.2 ,1TB WD Blue 3D NAND,500GB WD Blue 3D NAND,
Display(s) 50" Sharp Roku TV 8ms responce time and Philips 75Hz 328E9QJAB 32" curved
Case BLACK LIAN LI O11 DYNAMIC XL FULL-TOWER GAMING CASE,
Power Supply 1600 Watt
Software Windows 10
Did you try this yet? http://support.microsoft.com/kb/283849

Run the Compact and Repair utility. To do so, follow these steps:
  1. If the database is open, close it.
  2. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
  3. In the Database to Compact From dialog box, select the file that you want to compact, and then click Compact.
  4. In the Compact Database Into dialog box, enter a new file name, and then click Save.

    If the compact and repair does not succeed, you will receive a message stating so. This means the damage is so severe that it cannot be corrected.
 
Joined
Feb 19, 2006
Messages
6,270 (0.95/day)
Location
New York
Processor INTEL CORE I9-9900K @ 5Ghz all core 4.7Ghz Cache @1.305 volts
Motherboard ASUS PRIME Z390-P ATX
Cooling CORSAIR HYDRO H150I PRO RGB 360MM 6x120mm fans push pull
Memory CRUCIAL BALLISTIX 3000Mhz 4x8 32gb @ 4000Mhz
Video Card(s) EVGA GEFORECE RTX 2080 SUPER XC HYBRID GAMING
Storage ADATA XPG SX8200 Pro 1TB 3D NAND NVMe,Intel 660p 1TB m.2 ,1TB WD Blue 3D NAND,500GB WD Blue 3D NAND,
Display(s) 50" Sharp Roku TV 8ms responce time and Philips 75Hz 328E9QJAB 32" curved
Case BLACK LIAN LI O11 DYNAMIC XL FULL-TOWER GAMING CASE,
Power Supply 1600 Watt
Software Windows 10
Looks like you will need to rebuild the whole thing but at least you have the data still, right?
EDIT: Wait did you try this?

Convert a database to the Access 2007 file format

http://office.microsoft.com/en-us/a...-the-access-2007-file-format-HA010048406.aspx


You cannot convert a replicated database to the Office Access 2007 file format. However, you can use Access 2007 to create a replica of a database that is formatted in either the Access 2000 or the Access 2002 - 2003 file format.


More copy and paste:
[paste:font size="5"]Convert an Access 97 database, Convert an Access 95 database, or Convert an Access 2.0 database.
  • Click the Microsoft Office Button
    , point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.
  1. If any database objects are open when you use the Save Database As command, Access prompts you to close them prior to creating the copy. Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.
  1. In the Save As dialog box, type a file name in the File name box, and then click Save.
Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.

Here is a short and sweet version: http://www.ehow.com/how_7339817_convert-2003-database-access-2007.html
 
Last edited:
Joined
May 28, 2012
Messages
59 (0.01/day)
Sadly not, the problem seems to be in the linking of the mbe to the dat. For some reason, it doesn't find it. converting worked tho, but the file was still equally useless :(
 
Status
Not open for further replies.
Top