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 |
|
dsousa187
Starting Member
2 Posts |
 Posted - 2012-08-26 : 09:20:05
|
| I am using SQL server express 2005 as back end and MS access 2007 Project as Fron End.My problem is I could not add new data to table I imported from MS access.mdb to sql server express 2005. When I open sql server tabel via MS access project is said it is read only.Thanks for all your helps in advance |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-26 : 10:08:29
|
| For you to be able to modify data stored in SQL Server tables from an Access front end (I am assuming you are viewing them as linked tables and trying to modify the data from Access), it is required that the tables/views have a primary key or a unique index. Check your SQL tables to see if you have PKs or unique indexes, and if not, you would need to create primary keys or unique indexes for each table that you want to modify. |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-08-26 : 10:10:38
|
| Make sure your tables have a defined primary key - or a defined unique constraint that Access can use. |
|
|
|
|
|
|
Upadate SQL server table