creating tabes with full schema name

  • Thread starter Thread starter mcnews
  • Start date Start date
Yeah, ADP has a lot of trouble with full schema name, especially when it's
not dbo by default (ie, you are not part of the owner database role (dbo)).
Also, it has the very bad habit of adding the current user as the schema
name to many calls to the SQL-Server. For example, if your user name is
MyName and you want to call the stored procedure dbo.MyProcedure, it will
often call MyName.MyProcedure instead, making it impossible to find
dbo.MyProcedure.

On forms, you can set the Record Source Qualifier and for control, you can
add the schema name to the Row Source but it's probably a better idea to
always use dbo and set everyone to dbo when you want to use ADP against a
SQL-Server.
 
Back
Top