By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

The table "tablename" is already open exclusively.

P: 57

Yesterday I made some changes to my table called "TASKS".

And after that, my application is not allowing to open subform related to that table.

See the error snapshot.

Please help
Attached Files
File Type: docx error1.docx (221.5 KB, 246 views)
Jun 2 '15 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 5K+
P: 5,397
+ Please pull your image out of the document and attach it directly to the post - I work in a secured environment; thus, I don't usually open files. You can also simply type the information into the post. :)

+ What changes did you make to the tables?
Jun 16 '15 #2

P: 57
Hi z,

Thank you so much for replying me. I am glad that you are there to help me.

Luckily I had backup file saved so I am not that much bothered to use the last file. But, yeah I had to made the changes which I made to corrupted file after creating the backup.

I made following changes:

1) some changes in the existing table design, like changing the datatype
2) some changes in the form which are bounded to that particular table.
Jun 17 '15 #3

Expert Mod 5K+
P: 5,397
That's not much to go on; thus, unless you can be more specific I cannot offer much help.

You mention that the file was corrupted, as such, that may have been your root cause. If you have not already done so:
Make a copy of the file'
Open the file
Use the Database tools repair and compact
Close and reopen the repaired file
See if the error persist

other than that... without the error message and/or specifics regarding the changes there is not much more advice to offer you.
Jun 17 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.