SQLTeam.com | Weblogs | Forums

Tablename not recognized

I have an app that works perfectly on a stand-alone computer, interacting with an MS Access database containing two tables.

However, I have been tasked with incorporating this app into an agency-wide SQL Server database. The existing data has been copied into its "new home", but the table names chosen by the DBA produce errors(not recognized) when I write and execute a query.

Any ideas on how to proceed?

Particularly, the table names produce an error in DbSet statements.

Care to share these exact errors as we don't have powers to see them remotely

CS0246: The type or namespace name could not be found (are you missing a using directiveor an assembly reference?)

What is being rejected is the identifier within the < > of a DbSet declaration. How do I determine what to enter there?

this sounds more of an acess/vba question than a sql question?
please show us some code.

the more you share the more we can help you.

identifier within the < > of a DbSet declaration is not enough