TO UNSUBSCRIBE: email "unsubscribe issforum" in the body of your message to
[EMAIL PROTECTED] Contact [EMAIL PROTECTED] for help with any problems!
----------------------------------------------------------------------------
Walker Andrew <[EMAIL PROTECTED]> writes:
> On the console the file rsntclientlog.mdb has grown to 1048592Kb ! and I am
> now experiencing dB synchronization errors with all detectors. When I try to
> synchronize with the maintain detector log I get the message "dB synch
> error: The dB synchronization operation was cancelled" and a hex id
Seen this a couple of times. You can delete records from the access database
(which has reached its maximum of 1GB causing the problem) in either access or
the rs console. (Make sure that you not only delete the database, but also
repack it. Access will just tombstone all "deleted" entries, not really delete
them)
That way you retain the database structure. Make sure you backup the old
database first. The precise path of the db can be found in the ODBC control
panel.
Another way would be to convert your access "database" to SQL server. I managed
to do this using the Access to SQL server import utility that comes shipped
with SQL Server. You'll need to rewire the ODBC from access to SQL server to
get RS to log into the new database.
(I was disappointed to find out that the ISS engineers chose to store their
data in access. Even a plaintext file would have been a better solution
IMO.)
Hope this helps,
Willem
