Print Page | Close Window

Bug with built in Access DB

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6102
Printed Date: 03 June 2025 at 3:41am


Topic: Bug with built in Access DB
Posted By: corymckee
Subject: Bug with built in Access DB
Date Posted: 10 June 2007 at 10:44am

I tried to connect to the access DB and I get an error on setup when pointing to the Access DB.

Error updading/checking TblReloadTableInfo - The Microsoft Jet database engine cannot find the input table or query 'tbl_localdomains'.  Make sure it exists and that its name is spelled correctly

ERROR - Some fields are missing from the tables!
Please proceed to Step 2-b to add missing fields
Done.

2b shows nothing and the activity log shows "Exception occurred during ChecktblReloadTableInfo: Syntax error (missing operator) in query expression 'tblreloadtableinfo where id > (select min(id) from tblreloadtableinfo t where (t.domainid = tblreloadtableinfo.domainid) and (t.tablename = tblreloadtableinfo.tablename))'"

Please advise.


Replies:
Posted By: LogSat
Date Posted: 10 June 2007 at 11:26am
SpamFilter Enterprise does not support a MSAccess database. Only Microsoft SQL Server and MySQL are supported database platforms for SpamFilter Enterprise.

MS Access and Oracle can only be used by SpamFilter ISP in "Standard" mode (non-Enterprise mode).


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP

Posted By: corymckee
Date Posted: 10 June 2007 at 11:28am
Thank you. I will test with MSSQL instead.


Print Page | Close Window