N
Norma Jean
This doesn't happen consistently, but it happens often.
When copying a Microsoft Access Project file from one machine to another,
the record source requires a different table name. For example, the table and
query names in the developer application use straight-forward table names,
such as "Companies". On the User application the report or form will not work
until I change the record source to look for "dbo.Companies".
This name change is the same as when you link Access to the SQL database.
Those table names start with the dbo. suffix as well.
Am I missing something in the development? It isn't required for all the
forms and reports, just some of them.
When copying a Microsoft Access Project file from one machine to another,
the record source requires a different table name. For example, the table and
query names in the developer application use straight-forward table names,
such as "Companies". On the User application the report or form will not work
until I change the record source to look for "dbo.Companies".
This name change is the same as when you link Access to the SQL database.
Those table names start with the dbo. suffix as well.
Am I missing something in the development? It isn't required for all the
forms and reports, just some of them.