R
Ricki_Ricardo
Hello. We have used adp's for years to connect to our SQL server. The staff
really loves the ease and consistency of the ADP's. However in working
through some problems we have been having, I've noted that they don't prefix
items like table names with dbo. This has caused some problems, especially
since moving to Access 2007. The problem is, they all use the ADPs and from
the adp they can rename a table called SCHOOLS to INSTITUTIONS, for example,
but they cannot rename it to dbo.schools. Is there some workaround for this
problem? I'm not positive this renaming will solve their problems, but it
can't hurt.
I'm guessing we can use SQL Enterprise to handle this, but most of the staff
has never touched the product. So either we have to train them in using it,
or pass off the job to a much smaller subset of individuals.
TIA,
Rick
really loves the ease and consistency of the ADP's. However in working
through some problems we have been having, I've noted that they don't prefix
items like table names with dbo. This has caused some problems, especially
since moving to Access 2007. The problem is, they all use the ADPs and from
the adp they can rename a table called SCHOOLS to INSTITUTIONS, for example,
but they cannot rename it to dbo.schools. Is there some workaround for this
problem? I'm not positive this renaming will solve their problems, but it
can't hurt.
I'm guessing we can use SQL Enterprise to handle this, but most of the staff
has never touched the product. So either we have to train them in using it,
or pass off the job to a much smaller subset of individuals.
TIA,
Rick