473,320 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Corrupt Access 2010 Web Database

So I have a web database in Access 2010, Sharepoint 2010, as an accdb file.

I have a backup of the database, but the backup doesn't have the data in the tables.

For some unknown reason, the database was corrupted. I tried "Compact & Repair DB" which made the situation 10x worse.

Now the MsysAO table is missing over 100 rows. Before, the rows were there but full of non-typical random ASCII char's like you see in a corrupt file.

Now, when on the sharepoint site, all of my DB objects are missing except for a select random few.

I tried to resync the DB to overwrite the sharepoint site, except it is overwriting the DB instead, and deleting every object so it matches the SP site. So then I tried to open and save every single object to give it a new recently modified date, then resync. This didnt work either.

I tried to save a backup of the database as a local unpublished database, but all of the tables link back to their original locations, which cannot be found.

I've been developing this DB over a year now, and I'm not sure how to restore it and get the data back. The site went from over 150 objects to about 8, and all of the data is not visible (i'm hoping it wasnt deleted when the MsysAO table was corrupted).

Any Ideas?
Feb 9 '16 #1
0 899

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Paul Howarth | last post by:
My Access 2010 database is suddenly not appending Named Ranges from Excel into and Existing Access 2010 Table. I have not written any code. I simply right-click the Table-Import-Excel and follow...
5
lilp32
by: lilp32 | last post by:
I need to connect to a password protected Access database through Excel. Everything I've found while searching seems to imply that this is a bug that Microsoft has not fixed. Is this true? The...
11
by: Jo Ann Dullum | last post by:
I have a table in Sharepoint 2010 that users have submitted proposals into. I have a link to it in my Access 2010 database. The link works perfectly on my XP laptop but not on my Windows 7 desktop....
0
by: ammounn | last post by:
i'm publishing my vb 2008 application using an access database but the problem is after publishing it wont run and it display an error message that the database was not found although i added it in...
2
by: Redbeard | last post by:
I need to save my Access 2010 database in 2003 format so that someone can use it that is only running 2003. My database was built using Access 1997 and has been upgraded over the years to 2003, 2007...
4
by: rahul2310 | last post by:
I am hiding title bar and file button on it,because of which user can not compact and repair database.so want to create button on form using which user can compact and repair. I tried code. ...
0
by: rahul2310 | last post by:
how many users can share access 2010 database on Network Folder If operating system is microsoft Windows XP Or Windows 7
3
by: Manom | last post by:
Can you guys please suggest me how to disable Shift Key bypass in MS Access 2010 database? I've been googling for help but nothing useful. Thank in advance.
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.