I 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.transfers preadsheet acImport,
acSpreadsheetTy peExcel97,
"dbo.DL_Funding _Data",
"theFilename.xl s",
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
db_owner role. My server is MSDE 2000.
I use the following code to import a spreadsheet:
docmd.transfers preadsheet acImport,
acSpreadsheetTy peExcel97,
"dbo.DL_Funding _Data",
"theFilename.xl s",
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