Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jerill
Starting Member
7 Posts |
 Posted - 2011-10-26 : 11:51:29
|
| 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 ? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
|
|
|
Issues linking tables from SQL 2008 R2 to Access