Unable to open MS Access form in design view or form view.

Hello Everybody,
I am working on MS Access database(for e.g. D1). I have many forms and tables. The tables in D1 are linked to another database(D2). I changed a name of one table in D2 and I made a new link with that table(with new name) in D1.
Now the problem is that two of my forms in D1 which are using this table as a source(whose name i change) are not opening. Before whenever I double click on them, they gave a message that the source table does not exist(of course, because I change the name), but I change the table in the record source of those forms. Now, whenever I click on the forms to open, or to open in a design view, nothing happens. Now, no message appear about unavailability of source table, but just nothing happens. For e.g. I double click on the forms but they just don't react. (I can open all other forms who do not depend on that table)
Can anybody have a suggestion for me??
Thanx in advance...
John_BASAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tbsgadiCommented:
Hi John,

First try compacting the database
Then try deleting the links and see if you can open the form in design mode.


Good Luck!

Gary
0
tbsgadiCommented:
John_BAS,

If that doesn't work try decompiling
http://www.granite.ab.ca/access/decompile.htm
Gary
0
John_BASAuthor Commented:
Hi Gary,
I know how to make a link between two tables from different databases. But can you please tell me how to delete the link between tables present in two databases?
Thanx
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

tbsgadiCommented:
I'm not sure I understand.
The Table is in one mdb & the other mdb has a link to it.
If that is the case you can delete the link using the delete button
0
John_BASAuthor Commented:
Hi Gary,
Yes, two tables are in two different mdb databases. I want to delete a link but I think delete button will delete the table, right?
Thanx
0
tbsgadiCommented:
One mdb is linked to the other. Delete the one that has the link NOT the one with the table!
0
John_BASAuthor Commented:
Hi Gary,
No, the form is not opening. I even change the name of the source table but it is even not giving any message about unavailability of source table or something else.
I know that, if my form opens in a design view, I can fix everything in it.
Any reasons, why the form does not open, does not give any error message or does not even react while double clicking on it??
Thanx a lot.
0
tbsgadiCommented:
The form could be corrupted.
Can you bring it in from a backup?
0
John_BASAuthor Commented:
Hi Gary,
Thanx for your help. I import the forms from the back-up but that backup is from last Monday and I lost the new changes, I made in the form design in the last whole week.
Anyway, thanx again for your time...I will accept your solution.
0
tbsgadiCommented:
Thanks, anyway you should try decompiling & compacting..It might help.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.