I have an app in which I added all the tables to a main form data environment. Now this seems like it was a bad idea to have all the tables opened and only use a few at a time.

I am now tring to use the "Use table In 0 Shared" method but I get a "File in Use" error. Any ideas?