QuoteWerks Knowledgebase Topic (Article ID 6504)

Rehosted-Errors when exporting to SECURITY.MDB

This information applies to :

Article ID

September 27, 2007


Are you using the most current release of QuoteWerks?
Version 23.0 Build 1
While exporting updated security settings from a rehosted installation of QuoteWerks to a Security.MDB, you receive the following error:

SQL Execute Error
QuoteWerks trapped error The INSERT INTO statement contains the following unknown field name: 'PDSProductsViewAccess'. Make sure you have typed the name correctly, and try the operation again.(-2147217900)
SQL=INSERT INTO SecurityAccounts ( AccountingUserID, CMPassword, CMUserID, CommissionStructure, DocDeleteAccess, DocModifyAccess, DocViewAccess, EMail, Extra01Access, Extra02Access, ExtraDate01,ExtraDbl01,ExtraLng01, ExtraLogic01, ExtraMemo01, ExtraText01, ExtraText02, Fax, GroupMembers, GuestPassword,ID, LocationIdentifier, MenuAccess, MinimumMargin, MiscAccess, Phone,RecType, Region, ReplicationID, Title, UserDocumentPrefix, UserFullName, UserName, UserPassword, PDSProductsViewAccess, PDSProductsCreateAccess, PDSProductsModifyAccess, PDSProductsDeleteAccess, BundleViewAccess, BundleModifyAccess, BundleDeleteAccess, Con...

The SECURITY.MDB file is from a pre-Build 27 installation of QuoteWerks. New tables were added in this build of QuoteWerks.

Please contact QuoteWerks Technical Support (support@quotewerks.com or 407-248-1481) ti receive a fresh SECURITY.MDB file.

New Search