| Author |
Message |
|
sawyerashton
Joined: Thu Jul 07, 2011 3:33 am
Posts: 3
|
 Searching Error
I'm having an error when searching in BookCat. The problem started as I was searching for books and one of my student bumped the power cord and the computer was unplugged. When I restarted it, I am now getting this error when searching. The error is only happening when in Book View and using the quick search field at the top.
Update Recordset
An error occurred: "DAODatabase.Execute failed"
"Table 'TMP_CASEYDONATED_Owner_Browse_Book' already exists."
Can anyone please help? I've attached a screenshot of it as well.
You do not have the required permissions to view the files attached to this post.
|
| Wed Jan 18, 2012 9:25 pm |
|
|
|
kevinrailway
Joined: Sat May 06, 2006 2:02 am
Posts: 87
Location: Melbourne, Australia
|
Re: Searching Error
Try Tools > Repair Database
Kevin Martin
|
| Wed Jan 18, 2012 11:31 pm |
|
|
|
DougWilliams
Joined: Sun Dec 08, 2002 9:36 pm
Posts: 2573
Location: Wisconsin, USA
|
Re: Searching Error
Couple of things to try:
1) Try doing a repair. TOOLS > REPAIR DATABASE
Once the repair is complete and if the issue is resolved, you should compact the database (FILE > COMPACT DATABASE)
If that doesn't resolve the issue, try:
2) transferring to a new database.
You will need to create a new database (FILE > NEW DATABASE).
Then transfer using the FILE > TRANSFER.
Make sure to select everything.
Open the new database and check if the issue is resolved.
Let us know how it goes!
_________________
Doug Williams -Record Collector-
"You Mean I'm Supposed To Listen To 'Em?!?!?!?
|
| Wed Jan 18, 2012 11:33 pm |
|
|
|
sawyerashton
Joined: Thu Jul 07, 2011 3:33 am
Posts: 3
|
Re: Searching Error
Repair Database worked!
Thank you all so much.
I've been using the program for over a year and am not even close to scratching the surface of this program.
All I know is that it has made my classroom library with over 1000 books SOOO much easier to manage.
|
| Thu Jan 19, 2012 3:41 pm |
|
|
|
DougWilliams
Joined: Sun Dec 08, 2002 9:36 pm
Posts: 2573
Location: Wisconsin, USA
|
Re: Searching Error
Glad to hear it!
Don't forget to compact the database too. After a repair, the size of the database can become much larger than it needs to be.
Happy CATting!
_________________
Doug Williams -Record Collector-
"You Mean I'm Supposed To Listen To 'Em?!?!?!?
|
| Thu Jan 19, 2012 3:55 pm |
|
|
|
csutak40
Joined: Sun Dec 27, 2009 2:12 pm
Posts: 7
|
Re: Searching Error
Sorry to piggyback on this thread, but I too am having a problem with searching. I don't get a pop up error message, but when I attempt to find a book with the ISBN number, it proceeds to search for it, then Status changes to "Error". I thought there may be a problem with the book I was trying to enter, so tried one of my already entered books. It warned me that the book was already in the database, I clicked on continue, and, again, it started to search, then reported error again. After reading this thread, tried "Repair Database", didn't help. Any other Suggestions?
I am using V. 9.22.04 Internet dll version 195
_________________
Cheers
Judy
|
| Sun Feb 26, 2012 4:34 pm |
|
|
|
DougWilliams
Joined: Sun Dec 08, 2002 9:36 pm
Posts: 2573
Location: Wisconsin, USA
|
Re: Searching Error
Hi csutak40, Try updating to the latest version 9. (9.22.06) http://www.fnprg.com/bookcat/version9.html
_________________
Doug Williams -Record Collector-
"You Mean I'm Supposed To Listen To 'Em?!?!?!?
|
| Sun Feb 26, 2012 4:52 pm |
|
|
|
csutak40
Joined: Sun Dec 27, 2009 2:12 pm
Posts: 7
|
Re: Searching Error
That worked! Thank you very much!
_________________
Cheers
Judy
|
| Tue Feb 28, 2012 3:13 am |
|
|
