I am upsized from Access 2003 to SQL Server 2008 R2 using Upsizing wizard. And i have linked Access Tables to SQL Server database so that I can use Access forms which now points to SQL as backend.
After upsizing the tables, if I go to SQL Studio on server and right click on any table ( lets say Table1) and see "Extended properties" of any table, I see it is referring to "Table1_local".
But Access forms still inserts data in Table1 of Access database. And SQL Server is referencing to Table1_local. So I don't see any new data inserted as SQL refers to Table1_local. Can I somehow point from SQL Server Table1 to Access Table1.
I have more than 200 queries in Access Forms.
Any thoughts ?
asked Oct 26, 2011 at 09:04 AM in Default