ODBC called failed

• mvee

  Hall of Fame

  Points: 3634

  More actions

  July 15, 2005 at 5:47 pm

  #67218

  I have an Access ADP that connects to a SQL database.

  There is an excel file that is updated by a different group of people that has some pertinent info to this SQL application.  Before the user runs a certain report, they are suppose to click this button to append/update the records from the Excel file to a table in the SQL db owned by dbo.

  I have a test environment and a live environment.

  This procedure works fine logged an as me (super guru) or an average db user on the test database.

  For some reason, it does not work in the live environment.  I've compared every single permission I can think of.

  The Access app gives the following error:

  ODBC -- call failed...Create Table permission denied in databased PBC (#262)

  Any ideas?

  Oh, the only thing that I found different was that the live site is owned by sa and the test site is owned by me (my account).

  Thanks,

  Megan

• July 18, 2005 at 8:00 am

  This was removed by the editor as SPAM

• mfromer

  Mr or Mrs. 500

  Points: 548

  More actions

  July 18, 2005 at 10:56 am

  #575253

  I would guess that you don't have admin rights on the live environment DB, which is why you can't create a table.