Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesI am the owner of a database with other users. I have given all users db_owner role. My server is MSDE 2000. I use the following code to import a spreadsheet: docmd.transferspreadsheet acImport, acSpreadsheetTypeExc el97, "dbo.DL_Funding_Data", "theFilename.xls", True When I use an adp from Access 2000, this code executes successfully for all users. When I use an adp from access 2003, this code gets error 3078 and will only work if I remove the "dbo." from the name of the table. Any ideas on how to correct this. I don't want multiple copies of the code depending on what version of Access I use as the front-end. Thanks, Jerry
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread