I'm new to SQL
I have upsized an access database and converted it to an access project. The tables and queries migrated to SQL 2000 - No problems.
When I open the Access project on a client PC all of the tables and queries have (dbo) after their names.
I have a problem when I attempt to run reports - they fail to find the source table/query. If I edit the report and change the source from table to dbo.table the report works.
Is this the right thing to do, or should I sort out the table names.
Please be gentle....