Link to home
Start Free TrialLog in
Avatar of IsdNG
IsdNG

asked on

DB.Execute sInvoiceQuery, dbSeeChanges

Using Access 2000 and i get a DAO error when running this command:
DB.Execute sInvoiceQuery, dbSeeChanges

*I am using SQL as the backend that I just mirgrated
DB.Execute sInvoiceQuery, dbSeeChanges

Open in new window

Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image


  What error are you getting?  You will see an error if another user is editing the data your working with.

JimD.
Avatar of IsdNG
IsdNG

ASKER

I am getting the following error 3146 ODBC - call Failed DAO.Database. Since i migrated my cust table to SQL i had to add "dbSeeChanges" to my Rs commands.  I am having a problem when adding it to my EXECUTE command. Help
 
  3146 is a general server side problem.  Any number of things can be causing the error.  What is it that this ODBC call is doing?

  First thing I'd check however is the data type on the migrated tables.  Did you let the upsizing wizard determine the field types or did you add them yourself?  I'd also check and ensure that every table has a primary key.

JimD.
Avatar of IsdNG

ASKER

Sorry I am new to this...
    > Recently Moved my Customer table from Access to SQL.
    > Using Access 2000 I  had to add DBSeeChanges to all my Rs connections which is
        working fine.
    > THE PROBLEM: I have one line of code that execute's a query  DB.Execute Query1"
                               which is causing the DAO error.
                               I modified this line to read  DB.Execute sInvoiceQuery, dbSeeChanges
                               and its still not working.  Can you help?
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial