Microsoft SQL Server forum - dbo qualified name problem w/Access 2003

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

dbo qualified name problem w/Access 2003

Jer

2005-08-22, 8:23 pm

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.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

Sponsored Links