dbo qualified name problem w/Access 2003

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jer

    dbo qualified name problem w/Access 2003

    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

Working...