Updating a linked table

[sturner333]

I have a database with tables that are already linkes to other forms, etc.
How do you update these tables, like add new rows? When you open and/or save in the design mode, it say the linked table can not be updated.
Thanks

 

[Golom]

Do you mean table design mode?

If so that is just saying that you can't modify the structure of a linked table. You can still add, delete, update records in the table just as you would for a local table.

 

[Lilliabeth]

The problem has nothing to do with the fact that you have forms. The message you are getting indicates that you are not actually opening the table, you are opening a shortcut to the table. The file you are in is just the front-end of a database. The tables reside in a different file.

How to add rows? You said you have a form. That's what it's for.

If you meant to ask how to add new columns, you will need to open the back-end file to do that.

 

[sturner333]

Yes, table design mode. So there is absolutely no way to add more rows to the table once it is linked?
Thanks

 

[sturner333]

Thanks.

 

[Golom]

Of course there is. For example

INSERT INTO LinkedTable (fld1, fld2, fld3)
            VALUES ( 1, 2, 3 )

will insert a new row in the table.

or in code

Dim rs As Recordset
Set rs = Currentdb.OpenRecordset ( "LinkedTable" )
rs.AddNew
rs![fld1] = 1
rs![fld2] = 2
rs![fld3] = 3
rs.Update

does the same thing.

What you cannot do to a linked table is add new columns (or delete them or redefine them or build indexes). That is everything that you can do in the table design window.

There are ways to do this of course but they involve accessing the table in the database where it actually exists rather than the one in which it is linked.