I am trying to move from access tables to sql server.
I have my sql server database and table in place, but the web app is giving me this error:
ODBC Error Code = S0002 (Base table not found)
I have double checked that everything is there, and it is.
I can go into the SQL server enterprise manager and see the table and it works there fine.
I think something needs to be done for permissions for web access to the table.
Is this a true statement?
What are the steps to giving my db table web access?