Hi Gang

I'm having a little trouble getting a form to add a record to a linked table based on certain criteria. Basically if you select something from a combo box it will transfer the data to another table in a different database. The table in question is linked to the current DB but I can't get the code to run.

Any one have any answers

As far as adding data to a linked table, it should act the same way as a regular table in the same database. Make sure that the other database file is not marked as read-only. The link or the underlying table may also have some permissions set that are interfering. The most common problem I have found is if you are updating the table thru a query. Often when the query involves a join with another table it renders the whole thing not updateable.

-Phil-

Another issue may be how you are updating. If you are making a seperate call to the database without going through the linked table, then there could be issues there as well, especially with the data provider. Otherwise "it should act the same way as a regular table in the same database," joined queries notwithstanding.



mmcdonal

Look it up at: http://wrox.books24x7.com

Hmm not very sure if you have already solved this problem, I encountered this problem before. If you are using DAO recordsets you might want to check dbSeeChanges argument.

set rs = db.openRecordSet("bla bla bla",dbOpendynaset,dbSeechanges)
//open a query of table of dynamic type
if you open a table normally usually it would be a static table and you wont be able to seechanges.

If you are using ADO like I currently using right now you might not encounter this problem.