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 |
|
Lin100
Yak Posting Veteran
70 Posts |
 Posted - 2006-09-13 : 14:41:09
|
| Access 2002 and SQL 2000 Server.Inspection.ADP (MS Access) can update a table while Inspection.MDB cannot update the same table.I have a number of tables in an SQL server. Table_1 has a primary key defined.I have two Access databases one is Inspection.mdb and the other is Inspection.adpBoth of these databases, has Table_1 in it.On the Inspection.adp database, I can open Table_1 and edit the field value,but on the Inspection.mdb, it won 't let me update any field in Table_1. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-13 : 17:44:20
|
| When linking a table into an MDB, you need to specify the unique index. I'm guessing you didn't do this when linking the table. This isn't a problem with ADP's as they read the indexes etc directly. |
 |
|
|
Lin100
Yak Posting Veteran
70 Posts |
Posted - 2006-09-13 : 20:34:12
|
| Thank you Timmy for your help. |
|
|
|
Mbam
Starting Member
1 Post |
Posted - 2006-09-18 : 20:12:16
|
| I have almost the same exact problem, both Access 2002 & 03, SQL 7 backend. However I can add a new record in the mdb no problem, but cannot make any changes to it later. If I empty the table it works fine, but once I put all the records back in it won't work. Is there someplace to set the unique index in addition to the design table screen?Help !!Thanks!! |
|
|
|
|
|
|
ADP Access can update a table while MDB cannot