Solved

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

Posted on 2009-03-30
10
575 Views
Last Modified: 2012-05-06
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...
0
Comment
Question by:John_BAS
  • 6
  • 4
10 Comments
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
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
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
John_BAS,

If that doesn't work try decompiling
http://www.granite.ab.ca/access/decompile.htm
Gary
0
 

Author Comment

by:John_BAS
Comment Utility
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
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
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
 

Author Comment

by:John_BAS
Comment Utility
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
One mdb is linked to the other. Delete the one that has the link NOT the one with the table!
0
 

Author Comment

by:John_BAS
Comment Utility
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
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
The form could be corrupted.
Can you bring it in from a backup?
0
 

Author Comment

by:John_BAS
Comment Utility
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
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
Comment Utility
Thanks, anyway you should try decompiling & compacting..It might help.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now