Archive for category Database
Capitalize the first letter of a word in Microsoft Access 97
I am not a big fan of writing code…the stuff I struggled through at UCI more than cured me of any itch to be a code monkey. However, by virtue of my many hats, as a DBA (Database Administrator) I sometimes have to write some Visual Basic in queries in order to correct information in records [...]
Using DBCC ErrorLog Command To Cycle SQL Error Log Files
Each time SQL Server is restarted, the ERRORLOG file is recreated, and your existing error log is renamed ERRORLOG.1 The existing .1 (if any) is renamed .2 and so on to .6 This is done to ensure that the server starts up quickly with a fresh error log file. Since the current ERRORLOG file is [...]
SQL Server Agent issue – delay_between_response attribute (10 sec) of alert (9) is less
Posted by Mitch in Database, Network Admin on June 18, 2009
Agent was stopped so performance plan wasn’t running. Errors in Agent Log: delay_between_response attribute (10 sec) of alert (9) is less than poll interval for this alert (20 sec) Research led to http://www.sqlservercentral.com/articles/Administration/3177/ and CTRL+A copy/pasted the solution into notepad. Changed this registry key: EventLogPeekInterval from hex 14 to hex a which in decimal equals [...]
Couldn’t find installable ISAM – macro
This error led me to http://support.microsoft.com/kb/155666 which said that you should reinstall the Data Access components of MS Access. I had never selected them in the first place so I simply ran setup and installed them. Works now. Note: Doing this to fix one database problem resulted in another problem with a db using a different [...]
Computer not saving MDW path
If you are using an older Access database that uses an MDW for security then you might notice that sometimes you goto login and instead it opens the db with Admin access instead of prompting you for your credentials. This can be corrected one of two ways (or both if you’re feelin really crazy). 1. [...]
database.mdb unrecognized format
There are many reasons why you’d get this error, but what I encountered with one database was two people had it open and one ran a report that made changes to the tables while the other was doing something else. I closed their sessions and kicked them out of the db and opened it with [...]