I have an app that runs on a regularly scheduled basis.  It has run, problem free, for months.  Today, however, I received the following error message:

Run-time error '3075':
Method '~' of object '~' failed

Here is where it bombs:

DoCmd.RunSQL "CREATE TABLE " & sTodays_Date & "_On_Time_Delivery (Row_Id Long, Vendor Text(100), " & _
            "PO_Creation_Date Date, PO_Number Text(100), PO_Line_Number Long, Part_Number Text(100), " & _
            "Part_Description Text(100), Planner_Code Text(100), PO_Category Text(100), Item_Revision Text(100), " & _
            "PO_Qty Long, Need_By_Date Date, Promised_Date Date, Shop_Date Date, PO_Line_Type Text(100), " & _
            "Receipt_Number Text(100), Receiving_Txn_Date Date, Delta Long, Status Text(100), Txn_Type Text(100), " & _
            "Received_Qty Long, PLA_ID Long, PO_Unit_Price Currency, Standard_Cost Currency, " & _
            "Buyer Text(100), SQE Text(100), Value_at_Receipt Currency);"

Can anyone tell me why this would stop working?

Any help you can provide would be greatly appreciated.

Thank you.

Maybe a database reference files (ADO) was updated or something...



____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

I'm not quite sure what's going on.  I have restored the code from a backup.  I'm running it again.  This is very frustrating

Try downloading the latest MDAC

____________________________
If you find the answer helpful, please mark this topic as solved.