* This is the modus mailing list * Lewis,
Did you run the Vircom sql script when you setup the new SQL? There is a script that creates those tables and probably assigns their permissions. From what I've read of this thread it got me to wondering whether or not you ran the script. Regards, Mike Herrera Access One Online Svcs. http://www.access-one.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Grimes Sent: Sunday, November 30, 2003 3:11 PM To: [EMAIL PROTECTED] Subject: [Modus] SQL died and is now rebuilt but needing assistance. * This is the modus mailing list * Lewis, Okay my SQL guy is going to be out until Tuesday and I swear I almost have it. I did everything on the Vircom How To regarding the SQL script but we never ended up with a tblMsgCatalog or a tblRecipients table. What I ended up doing was switching to the native mdb file for a short time and then copying it over to the SQL machine and creating a new SQL database by first importing the mdb and then using the Query to add the M3 .sql script. Now I see the two tables named above but now I receive an error in the modus logs referring to a field called NewMsg in tblMsgCatalog that cannot be null. T ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
