Adding New Records To A Linked Table

[anishkgt]

hi,

Is it possible to add new records to a linked table ? i tried it out but new records is not possible, is there a workaround for this.

Thanks

 

[pr2-eugin]

Linked Table as in the DB split between Front end and backend both using Access or SQL/ODBC linked table?

If it is the former, show some code or explain how you are trying to add records?

 

[anishkgt]

Seems that the db server that i had was opening that particular databse as readonly. Restarting the db server solved everything.

 

[anishkgt]

One quick question, do i need relate tables (relationships) in the front end also. Its already related in the back end database.

 

[pr2-eugin]

do i need relate tables (relationships) in the front end also. Its already related in the back end database.

Not necessary. Although when performing JOINS I think you will have to do it manually, as the relationships will not be available in the front end (not 100% sure though)..

 

[anishkgt]

Hmmmm i felt that its not needed in front end thanks anyway.

 

[anishkgt]

Ok seems like the issue with adding records to linked table did not go away.

I noticed that the db itself after opening it shows as read-only, which it shouldn't. But after restarting the pc with the backend db it works fine.

 

[anishkgt]

But after some time everything seems to be ok. Is it because that particular linked table is locked for some reason if so is ther

 

[anishkgt]

Finally got it sorted out it was a folder rights which had restricted earlier. So far so good.