I have an Access 2010 frontend with an Access 2010 backend. The IT dept took the Access backend and created a SQL Server backend. When I OBDC to the new backend all the tables have a dbo prefix. The Access frontend does not recognize the tables.
When the Access backend is upsized into SQL server is there a way to not have the dbo prefix or will all the tables need to be individually renamed?