quote:

---

Originally posted by jsmith8858

1) linked tables and pass through queries have NOTHING in common -- other than the fact that they both connect to external datasources. But in a given MDB file, they have nothing to do with each other. Pass-Though Queries are just connecting to some datasource and executing a command against it; they have nothing to do with any linked tables that might exist in your Access DB. Does this make sense?

---

quote:

---

2) Linked tables CAN be updated as long as you have permissions to do so, and the table has a primary key defined. I've done this many times. (if you don't have a PK defined, you have much bigger problems than we can help with ... you have not answered any questions we have asked you yet, but I'll try again anyway: Do your linked tables have primary keys?)

---

CDaoDatabase daodatabase;
daodatabase.Open( SZ_MDB_SPEC_VINCULADA  );  // mdb with linked tables
CDaoTableDef daotabledefTabla( &daodatabase );
daotabledefTabla.Open("tabla");
CDaoRecordset daorecordsetSelectTabla( &daodatabase );
daorecordsetSelectTabla.Open( &daotabledefTabla ); // exception!
daorecordsetSelectTabla.MoveFirst();
cout << "daorecordsetSelectTabla CanUpdate: " << daorecordsetSelectTabla.CanUpdate() << endl;

	CDaoDatabase d;
	d.Open("c:\\AccessDev\\Test97.mdb");
	CDaoRecordset r(&d);
	r.Open(dbOpenDynaset,"SELECT * FROM dbo_Employees", dbSeeChanges);

	if (r.CanUpdate())
		this->MessageBox("Can update!");
	else
		this->MessageBox("CANNOT update!");

	r.Close();
	d.Close();

quote:

---

1) When you first open up MS Access, and click on the linked table, does it prompt for log-on information?

---

quote:

---

2) In Access, can you open the linked table(s) in question and update them manually?

---

quote:

---

3) You understand that no matter what you do, if you link to a table w/o a primary key, Access cannot update it, right?

---

quote:

---

by the way:

>>Throws an exception "Invalid Operation" in the line marked "exception!"

Throwing an Exception does not mean something cannot be updated! It means your code is throwing an Exception! there's an error, you must fix it! If it executed succesfully (w/o any errors) and the output indicated that CanUpdate() was FALSE, then that would mean that you cannot update the recordset. Does this make any sense whatsoever?
(please answer this as well if you can)

---

quote:

---

Well I got all running but it seems that important diferences are in DAO3.5 and DAO3.6
One code workd for DAO3.6 (opening as basically you have post), but hangs in 3.5 (even SQL-Server)
Another works for DAO3.5, but is far more complex (based on pasthrough), and in one computer works and in other throws an exception (I think it simple to solve, because is explicative -is not doing the passthrough, and posibly because I did not explicitly set the dbSQLPassThrough -In my tests it worked in passthrough mode as the SetConnect is used-.

---