Run-time error '3192'

[Guest]

I have an Access Database that actually executes SQL Stored Procedures within
Access Macros. I am getting the following error when attempting to write data
out to a SQL Table from within Access via a macro and stored procedure.

Run-time error '3192':
Could not find output table 'dbo_SaleUploader_SaleUpload'

I am finding that errors generated within Access trying to navigate around
and in the Access Database application are sometimes misnomers. This table,
SaleUploader_SaleUpload does exist within SQL Server and I can ODBC to it
from within Access. My thinking is that perhaps the Access Table that it is
using to read and then write out to this SQL Server Table, the columns might
be incompatiable.

If anyone can help this novice out with this error, I'd GREATLY appreciate it.

Thanks!

wnfisba

 

[Guest]

your hunch you state is that the Access Table that it is

using to read and then write out to this SQL Server Table, the columns might
be incompatiable.

***** I would resolve this hunch by performing the task into a known
compatible Access table instead - just as a test

**** the message indicates that it can't find the table. You know that the
table exists. Could it be that you are naming it incorrectly? have you
double checked the syntax...as the "dbo_ maybe is a hint...