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
*I am using SQL as the backend that I just mirgrated
DB.Execute sInvoiceQuery, dbSeeChanges
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.
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?
> 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What error are you getting? You will see an error if another user is editing the data your working with.
JimD.