hello everyone,
I have completed my vacation database with an Access 2003 front-end and SQL 2000 back-end. I now have to set up the Access front-end on multiple users desktops. I have connected ODBC and SQL is connecting without a hitch. The problem is on my forms that run stored procedures. Anyone heard of this...the stored procedure works fine in the queries tab, however when being run from a form it does not find the stored procedure.
Any help would be greatly appreciated.
Lucinda
I have completed my vacation database with an Access 2003 front-end and SQL 2000 back-end. I now have to set up the Access front-end on multiple users desktops. I have connected ODBC and SQL is connecting without a hitch. The problem is on my forms that run stored procedures. Anyone heard of this...the stored procedure works fine in the queries tab, however when being run from a form it does not find the stored procedure.
Any help would be greatly appreciated.
Lucinda