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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2005-03-29 : 04:37:39
|
| We have an Access database but want to move the tables into sql server. I can link to the sql table using ODBC and create a form based on this sql table. However, if I try to change the data it says this recordset is not updatable. Is there a way around this ?This will be an interim phase while the Access 97 is rewritten in asp.net, but will allow the users to carry on updating for the time being. |
|
|
ijprasad
Starting Member
29 Posts |
Posted - 2005-03-29 : 04:43:37
|
| use MS DTS to transfere data from access to ms sqlInderjeet |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-03-29 : 11:29:20
|
| you tables in SQL Server must have primary keys declared in order for Access to be able to write to them. (in addition to the rights of the user account that is used to link to the SQL tables). If you don't have primary keys on your tables, then you have much bigger problems than the fact that you are having trouble updating tables using Access !- Jeff |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2005-03-30 : 04:43:59
|
| You may want to look at the Access Upsizing Wizard from the MS website in the short term. It's not brilliant but it will give you something to work fromsteveA sarcasm detector, what a great idea. |
|
|
|
|
|
|
Link to SQl tables using Access 97