Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 559
  • Last Modified:

MS Access Database Repair

See attached message (file called access_repair.jpg).

We have a process wherein a Microsoft Access database is linked to a Quick Books database. This process runs on a Windows XP scheduled task every night. It consists of bat files, ftp to a web server and running macros & queries in the access DB.

I am aware of the fact that XP has "expired" & is no longer supported by Microsoft.

The last two nights, the process has failed with the attached message.

See attached file called Linked_to_Lss. This shows the tables in the database; note some are externally linked; those connect to Quick Books tables.

Is it safe to do the suggested Repair? Will that NOT effect the Quick Books tables?

Why would this all of a sudden be a problem? It's been running for years. Slight changes were made a few weeks back but it has run properly for about two weeks.

I can provide the main macro & all of the executed queries, if need be.

Thanks!
access-repair.jpg
LSS-Access-tables.jpg
0
Richard Korts
Asked:
Richard Korts
  • 4
  • 4
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Why would this all of a sudden be a problem? >>

 It's very hard to say, and it might be related to the OS or Access, not the DB.

 First, make a backup copy of the DB as it stands.   You can then run a compact and repair on it.   This will not touch the QB tables in any way.

 After the C&R, check if the database is operational.   I would also open a code module and do a compile, and make sure it compiles without error, and then save.

 If after that, the process continues to fail, then you'll need to pin down what is causing the failure.

Jim.
0
 
Richard KortsAuthor Commented:
To JDettman (Jim Dettman)

Do I just copy the mdb file & put it somewhere or is there a backup utility in Access?

Thanks,

Rkorts
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You can just do a simple file copy.  Just make sure it's not in use when you do.

Jim.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Richard KortsAuthor Commented:
I did the Compact & Repair; the Mouse Pointer turned to an hourglass for like one second.

Does it work that fast?

Thanks
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Sometimes yes.   Depends on what's in the DB, how large it is, etc.

Jim.
0
 
Richard KortsAuthor Commented:
OK, I have scheduled to try the overnight process again at 1 PM Central Time (about 90 minutes from now). We shall see.

Thanks
0
 
Richard KortsAuthor Commented:
To JDettman (Jim Dettman)

I ran the overnight; it failed, but for a different reason. See attached.

Even though I arranged with the customer that no one be on Quick Books at the specified time, I suspect someone was on & this record could not be adjusted due to that.

I will ask a Quick Books question regarding this one.

Thanks
ODBC-Error.JPG
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Even though I arranged with the customer that no one be on Quick Books at the specified time, I suspect someone was on & this record could not be adjusted due to that.>>

 Sure looks like it.

Jim.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now