Create a report based on the results of a (SQL) Stored Procedure

[tcorrigan]

I want to create a report in an Access 2000 ADP project that is based on the results of a stored procedure. The stored procedure name appears in the RecordSource dropdown list, but when I select it I get the error message "Microsoft Access can't find the object FamilyBarCodes". I would think that creating reports from stored procedures would be one of the basic uses of Access ADP's, but I guess not. Can anybody help me with this, please?

Tom Corrigan
Apt Technologies, Inc

 

[Aivars]

Hi!

Is your stored procedure declared as public?

Aivars

 

[tcorrigan]

It wasn't but it is now. However I still get the same error message.

Tom