Link MS ACCESS 2010 Database uto SQL SERVER 2008 R2

[sandeep23]

Hi,

I have a requirement. I have to link the MS Access 2010 web Database which i have created to sql server 2008 R2. My Requirement is, if i update the ms access database that should reflect the sql server database. If i insert a record in the ms access database table it should insert in the sql server database table.

I have downloaded the SSMA for access and migrated the database. but when i insert new record in my ms access table. it is not reflecting in my sql server.

My Requirement is, whenever i insert/delete/update a record in ms access table, it should automatically do the same thing in sql server.




Thanks & Regards,
Sandeep Kumar.

 

[Pat Hartman]

If this were a normal Access application, there would be no problem. However, the web edition is very restrictive and lacks many features not to mention forcing you to use macros ratner than code. I have heard that you don't have to upsize to sharepoint lists but you can upsize to SQL Server and still publish the app as a web app. If that is actually true, then that is the answer. Sharepoint lists are not relational tables anyway and so not suitable for a real application.

If you can't link directly to SQL Server rather than Sharepoint there are no other options. If you could write code, you could update the SQL tables behind the scenes (the concept of this makes me sick). I don't really know what you can do with macros.

Let us know how it works out.

 

[sandeep23]

If this were a normal Access application, there would be no problem. However, the web edition is very restrictive and lacks many features not to mention forcing you to use macros ratner than code. I have heard that you don't have to upsize to sharepoint lists but you can upsize to SQL Server and still publish the app as a web app. If that is actually true, then that is the answer. Sharepoint lists are not relational tables anyway and so not suitable for a real application.

If you can't link directly to SQL Server rather than Sharepoint there are no other options. If you could write code, you could update the SQL tables behind the scenes (the concept of this makes me sick). I don't really know what you can do with macros.

Let us know how it works out.

Hi Again,

I have created the linked tables for my normal web tables. I renamed the linked tables which asked me that the tables (normal) tables already exists would you like to rename? I said yes.. now, whenever I add/update/delete a record from the form its inserting to the linked table which eventually doing the same thing in sql server too. But when I am trying to publish it, ts giving me an error saying " the form created with the original table was missing".

please help me with this issue... How can i go about it..

 

[spikepl]

Cross-posted here: http://www.accessforums.net/access/link-ms-access-2010-database-uto-sql-24951.html#post120864

@Sandeep23

You have already in another post (http://www.access-programmers.co.uk/forums/showthread.php?t=227486 ) been requested to read http://www.excelguru.ca/content.php?184 which explains why you should not do what you are doing the way you are doing it.

Which specific lines from that link are incomprehensible to you?