I've inherited an Access 2000 ADP which I've been tasked to rewrite in VB.
It uses no security, (sa and blank password), and my first step is to secure
the SQL Server database.  Problem is, when I switch over to NT integrated
security, the reports based on stored procedures cease to function.  However
if I add 'dbo.' in front of the sp name, they work fine.  I programmed
extensively with ADP's a few years ago and I've never come across this.

So, do I need to go into all the reports and add the dbo, or is there a way
around this.  I'd like to get the database secured before I begin the new
application.

TIA

-Andy