dbo prefix

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
 
V

Van T. Dinh

(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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dbo schema problem and permissions 1
Split Forms and ADP issues 2
Setting sourceobject for subform 1
dbo. in vs generated code for stored procedures. 2
object name doesn't follow microsoft access object naming rules 3
Problems with LINQ and CLR Stored Procedure 1
Trying to Copy Structure - Error msg for Table Name 2
Open parameterised stored proc as a resultset in a window 2

Top