Hi Guys
I am using upsizing wizard for data migration. I tried to migrate tables from both Access backend to sql server and it worked a treat. After the tables got exported in sql server I linked those tables to Access frontend .
But all the tables linked are starting with 'dbo.' So my Access forms don't work because they were earlier linked to tables named e.g 'tblStaff' but now that table is changed to 'dbo.tblStaff'.
How can I resolve this issue so that I don't have to change my forms and queries etc..?
Many Thanks
I am using upsizing wizard for data migration. I tried to migrate tables from both Access backend to sql server and it worked a treat. After the tables got exported in sql server I linked those tables to Access frontend .
But all the tables linked are starting with 'dbo.' So my Access forms don't work because they were earlier linked to tables named e.g 'tblStaff' but now that table is changed to 'dbo.tblStaff'.
How can I resolve this issue so that I don't have to change my forms and queries etc..?
Many Thanks