troubleshooting Question

Loading Table Disappearing

Avatar of stopher2475
stopher2475Flag for United States of America asked on
Microsoft AccessMySQL Server
8 Comments2 Solutions375 ViewsLast Modified:
I have an access .adp file that loads data to a sql server database.
I use a function that uses the transfer spreadsheet function like so.
    'Delete prior data for this date.
    CurrentProject.Connection.Execute "Delete From dbo.tblWrk_" & sDataType

    SysCmd acSysCmdSetStatus, "Importing worksheet..."
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "dbo.tblWrk_" & sDataType, sFullName, True

Basically I give my function a file path and a data type and it loads the data into the appropriate loading table.
After recently moving this database from a 2000 to a 2008 SQL server I'm finding the loading table will randomly disappear and I have to recreate it. I'm not dropping it anywhere. Is there some kind of incompatibility with 2008 that would cause the table to drop?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros