Currupt Access DB

[artsapimp]

I have been compacting a database on a weekly basis instead of daily which would have been a little smarter. The information is coming back as a ? and a square instead of populating from a text field. The same query pulls the opened_date, closed_date, Active and does a count(*) which works fine. The only information that doesn't come through correct is the description field.

Does anyone have any idea how I can fix this?

Here is my Query incase you're interested in that.

strSQL = "SELECT Count(*), Outages.Outage, Outages.Active, Outages.Start_Date, Outages.Start_Time, Outages.End_Date, Outages.End_Time"
strSQL = strSQL & " FROM Outages RIGHT JOIN Tickets ON Outages.OutageID = Tickets.Outage"
strSQL = strSQL & " GROUP by Outages.Outage, Outages.Active, Outages.Start_Date, Outages.Start_Time, Outages.End_Date, Outages.End_Time"

Thank you for any help.

[mosquito]

I think that you have to restore a backup. Or try to open the database in MS Access, and select the repair option. Try to switch to MSSQL Server, or even MSDE (a scaled down version of SQL Server, and it comes free with ms office)

[artsapimp]

That is what I was afraid of. We are going to upgrade to SQL but I don't know when that will be. I will start pushing it a little more. Thanks.

[mosquito]

Make sure that you check the upsizing tools from ms, they can save you a lot of work when you have to migrate from access to sqlserver.

[artsapimp]

I sure will, thanks.