Linked Table in SubForm

[jamphan]

I have a subform that utilizes a linked table on a public server. The main database is housed on individual PCs which is done for the purpose of speed of the database. What I would like is for the users to be able to update the linked table so everyone would be able to see the updates but I am running into the problem that only 1 person can have the table open and update. Any solutions?

[TheShabz]

look up the "database splitter" utility. It will make life easier. Google and F1 are your friends.