<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
<channel>
<title><![CDATA[FLEXquarters.com Limited]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/]]></link>
<description />
<generator><![CDATA[Kayako case v4.66.2]]></generator>
<item>
<title><![CDATA[[QXL-ALL] Troubleshooting - Cannot modify the design of the table - It is in a read-only database. Source:odbcjt32.dll]]></title>
<link><![CDATA[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3012]]></link>
<guid isPermaLink="false"><![CDATA[5a01f0597ac4bdf35c24846734ee9a76]]></guid>
<pubDate><![CDATA[Thu, 31 May 2018 11:29:02 +0000]]></pubDate>
<dc:creator />
<description><![CDATA[Troubleshooting - Cannot modify the table's design - It is in a read-only database. Source:odbcjt32.dll
Problem Description:
I keep getting an error message that states&nbsp;Error Occurred: unable to create table in destination database-customer-access,...]]></description>
<content:encoded><![CDATA[<h2><span style="color: #6633cc; font-family: Arial,Helvetica,sans-serif;">Troubleshooting - Cannot modify the table's design - It is in a read-only database. Source:odbcjt32.dll</span></h2>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Problem Description:</span></span></h3>
<p>I keep getting an error message that states&nbsp;<br />Error Occurred: unable to create table in destination database-customer-access, QXL, additionalInfo: tableselection-customer,Table-40, Tables 152<br />I look in the logs, and it states&nbsp;<br /><br />Exception classes:&nbsp;<br />System.Data.Odbc.OdbcException<br />Exception messages:&nbsp;<br />Message: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of table 'QXLCustomer.' It is in a read-only database. Source:odbcjt32.dll</p>
<p>&nbsp;</p>
<p><br />Additional Info: CREATE TABLE "QXLCustomer" (<br />"Name" TEXT(41) NOT NULL,<br />"FullName" TEXT(209),<br />"IsActive" YESNO,<br />"ClassRefListID" TEXT(36),<br />"ClassRefFullName" TEXT(209),<br />"ParentRefListID" TEXT(36),<br />"ParentRefFullName" TEXT(209),<br />"Sublevel" INTEGER,<br />"CompanyName" TEXT(41),<br />"Salutation" TEXT(15),<br />"FirstName" TEXT(25),<br />"MiddleName" TEXT(5),<br />"LastName" TEXT(25),<br />"JobTitle" TEXT(41),<br />"BillAddressAddr1" TEXT(41),<br />"BillAddressAddr2" TEXT(41),<br />"BillAddressAddr3" TEXT(41),<br />"BillAddressAddr4" TEXT(41),<br />"BillAddressAddr5" TEXT(41),<br />"BillAddressCity" TEXT(31),<br />"BillAddressState" TEXT(21),<br />"BillAddressProvince" TEXT(21),<br />"BillAddressCounty" TEXT(21),<br />"BillAddressPostalCode" TEXT(13),<br />"BillAddressCountry" TEXT(31),<br />"BillAddressNote" TEXT(41),<br />"BillAddressBlockAddr1" TEXT(41),<br />"BillAddressBlockAddr2" TEXT(41),<br />"BillAddressBlockAddr3" TEXT(41),<br />"BillAddressBlockAddr4" TEXT(41),<br />"BillAddressBlockAddr5" TEXT(41),<br />"ShipAddressAddr1" TEXT(41),<br />"ShipAddressAddr2" TEXT(41),<br />"ShipAddressAddr3" TEXT(41),<br />"ShipAddressAddr4" TEXT(41),<br />"ShipAddressAddr5" TEXT(41),<br />"ShipAddressCity" TEXT(31),<br />"ShipAddressState" TEXT(21),<br />"ShipAddressProvince" TEXT(21),<br />"ShipAddressCounty" TEXT(21),<br />"ShipAddressPostalCode" TEXT(13),<br />"ShipAddressCountry" TEXT(31),<br />"ShipAddressNote" TEXT(41),<br />"ShipAddressBlockAddr1" TEXT(41),<br />"ShipAddressBlockAddr2" TEXT(41),<br />"ShipAddressBlockAddr3" TEXT(41),<br />"ShipAddressBlockAddr4" TEXT(41),<br />"ShipAddressBlockAddr5" TEXT(41),<br />"Phone" TEXT(21),<br />"AltPhone" TEXT(21),<br />"Fax" TEXT(21),<br />"Email" MEMO,<br />"Cc" MEMO,<br />"Contact" TEXT(41),<br />"AltContact" TEXT(41),<br />"CustomerTypeRefListID" TEXT(36),<br />"CustomerTypeRefFullName" TEXT(159),<br />"TermsRefListID" TEXT(36),<br />"TermsRefFullName" TEXT(31),<br />"SalesRepRefListID" TEXT(36),<br />"SalesRepRefFullName" TEXT(5),<br />"Balance" DOUBLE,<br />"TotalBalance" DOUBLE,<br />"OpenBalance" DOUBLE,<br />"OpenBalanceDate" DATETIME,<br />"SalesTaxCodeRefListID" TEXT(36),<br />"SalesTaxCodeRefFullName" TEXT(3),<br />"TaxCodeRefListID" TEXT(36),<br />"TaxCodeRefFullName" TEXT(3),<br />"ItemSalesTaxRefListID" TEXT(36),<br />"ItemSalesTaxRefFullName" TEXT(31),<br />"SalesTaxCountry" TEXT(31),<br />"ResaleNumber" TEXT(15),<br />"AccountNumber" TEXT(99),<br />"BusinessNumber" TEXT(99),<br />"CreditLimit" DOUBLE,<br />"PreferredPaymentMethodRefListID" TEXT(36),<br />"PreferredPaymentMethodRefFullName" TEXT(31),<br />"CreditCardInfoCreditCardNumber" TEXT(25),<br />"CreditCardInfoExpirationMonth" INTEGER,<br />"CreditCardInfoExpirationYear" INTEGER,<br />"CreditCardInfoNameOnCard" TEXT(41),<br />"CreditCardInfoCreditCardAddress" TEXT(41),<br />"CreditCardInfoCreditCardPostalCode" TEXT(41),<br />"JobStatus" TEXT(10),<br />"JobStartDate" DATETIME,<br />"JobProjectedEndDate" DATETIME,<br />"JobEndDate" DATETIME,<br />"JobDesc" TEXT(99),<br />"JobTypeRefListID" TEXT(36),<br />"JobTypeRefFullName" TEXT(159),<br />"Notes" MEMO,<br />"PreferredDeliveryMethod" TEXT(10),<br />"IsUsingCustomerTaxCode" YESNO,<br />"PriceLevelRefListID" TEXT(36),<br />"PriceLevelRefFullName" TEXT(31),<br />"ExternalGUID" TEXT(40),<br />"TaxRegistrationNumber" TEXT(30),<br />"CurrencyRefListID" TEXT(36),<br />"CurrencyRefFullName" TEXT(64),<br />"CustomFieldAccountNumber" TEXT(30),<br />"CustomFieldCollectionPlanDetails" TEXT(30),<br />"CustomFieldCollectionsPlan" TEXT(30),<br />"CustomFieldDepartment" TEXT(30),<br />"CustomFieldPACTS" TEXT(30),<br />"CustomFieldSupervisionType" TEXT(30),<br />"ListID" TEXT(36) NOT NULL,<br />"TimeCreated" DATETIME,<br />"TimeModified" DATETIME,<br />"EditSequence" TEXT(16) NOT NULL<br />)<br />Exception classes: <br />System.Data.Odbc.OdbcException<br />Exception messages: <br />Message: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of table 'QXLCustomer.' It is in a read-only database. Source:odbcjt32.dll<br />Stack Traces:<br />At System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)<br />At System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean need reader, Object[] method arguments, SQL_API odbcApiMethod)<br />at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean feedreader)<br />at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()</p>
<h3><span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #0066cc;">Solutions:</span></span></h3>
<ul>
<li>Please make sure your MS Access database is not read-only.</li>
<li>Please open the MS Access&nbsp;database file and try to remove the table QXLCustomer manually.&nbsp;</li>
<li>Try changing the path of your MS Access file.<br />Move your file from C:\Users\YourName\Documents\QXL\<br />to<br />C:\MyQuickBooks Data\<br />Change the path of your MS Access file in your DSN.</li>
<li>Try changing from an .mdb database to a .accdb&nbsp;</li>
<li>Try changing the DSN from a user DSN to a system&nbsp;DSN</li>
</ul>]]></content:encoded>
</item>
</channel>
</rss>