|
Hi, 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 ?
(comments are locked)
|

