dbo prefix

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

Recently after a number of changes our db has started requiring all
references to stored procedures in forms/code to have the name prefixed with
dbo...

This is now a problem as when attempting to specify the SourceObject of a
subform Access does not accept the name dbo.TableName as an error is
returned stating that "The form name entered doesn't follow Microsoft Access
object-naming rules."

Thanks

Henry
 
(I don't use ADP so I may be wrong).

For normal MDB, I don't even use the DatasheetView of the
Tables as SourceObjects for Subforms.

1. Try creating a simple Form in DatasheetView based on
the Table using the Form Wizard and then use this Form as
the SourceIbject for your SubformControl.

2. Try just TableName only rather than dbo.TableName.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top