Cannot modify Table properties for back-end db

[wrek]

Hi all,

I have a typical split database - tables in backend, forms in front end.

However, I cannot modify the tables' properties in the backend, even though they are just LINKED to the frontend. ("A query or form bound to the table is open...etc")

Furthermore, an .ldb file exists for the backend when only this one particular user uses the frontend. It's valid too....not a 'ghost' one.

Any ideas why this is happening?

 

[ghudson]

However, I cannot modify the tables' properties in the backend, even though they are just LINKED to the frontend. ("A query or form bound to the table is open...etc")

That is your answer...you can not modify the design of the table while a form, query, etc. has a lock on the table. You should ensure that all users are out of the db when ever you need to make design changes to the objects within your db. You will have to reboot the computers that had the db open if you can not open the db exclusively.

 

[wrek]

Thanks

(I naively expected to be able to change properties because the table was linked.... )