Hi,
I have an excel sheet, where I run a backup process, it is supposed to create a table in MSAccess database and insert all the data from the sheet.
This was working just fine and all of the sudden, when I run it the first time I get an error when I execute the Create statement
Object invalid or no longer set.
then if I run it again I get Could not find field 'SID'.
The create statement is the following
create _ow_table (IpersonsInameIColumn varchar,IowingIColumn varchar,IownerIColumn varchar,IamountIColumnValue varchar,IamountIColumnFormula varchar,IcurrencyIColumn varchar,IcontactIinfoIColumn varchar,IpersonsInameIComment varchar,IowingIComment varchar,IownerIComment varchar,IamountIComment varchar,IcurrencyIComment varchar,IcontactIinfoIComment varchar,IpersonsInameIFontColorID char(5),IowingIFontColorID char(5),IownerIFontColorID char(5),IamountIFontColorID char(5),IcurrencyIFontColorID char(5),IcontactIinfoIFontColorID char(5),IpersonsInameICellColorID char(5),IowingICellColorID char(5),IownerICellColorID char(5),IamountICellColorID char(5),IcurrencyICellColorID char(5),IcontactIinfoICellColorID char(5),IpersonsInameIBold yesno,IowingIBold yesno,IownerIBold yesno,IamountIBold yesno,IcurrencyIBold yesno,IcontactIinfoIBold yesno,IpersonsInameIUnderLine yesno,IowingIUnderLine yesno,IownerIUnderLine yesno,IamountIUnderLine yesno,IcurrencyIUnderLine yesno,IcontactIinfoIUnderLine yesno)
If I strip it down to the following
create _ow_table (IpersonsInameIColumn varchar)
I still get the errors
I took the long statement above and went in MSaccess and run it directly from there and the table gets created successfully!!
I ran a compact and repair on the database.
This was working before, and now it is working only if I run it against the database, so can anyone help?
Thanks
Bookmarks