I have a access web database with few tables. I have even published them to the sharepoint. I have created the linked tables to the existing tables with sql server 2008 R2 which created few tables with prefixed as "dbo_". My tables are also created in the database specified in the sql server 2008 R2.

If i rename the linked tables to original table and create a record using the form. its creating and record is also inserting the linked table and sql server 2008 R2 which fulfills my task. But when i am trying to publish the changes that i have done to sharepoint, its throwing me with an error the the form that was created with original table was not present.

How can go about this issue... my intention here, whenever i do some modifications on the table that should even reflect the sql server table aslo.

Thanks in advance...