[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2009-03-30
10
Medium Priority
?
597 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
ID: 24018596
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
ID: 24018607
John_BAS,

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

Author Comment

by:John_BAS
ID: 24018670
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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 46

Expert Comment

by:tbsgadi
ID: 24018701
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
ID: 24018737
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
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24018757
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
ID: 24018853
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
ID: 24018866
The form could be corrupted.
Can you bring it in from a backup?
0
 

Author Comment

by:John_BAS
ID: 24019533
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 1500 total points
ID: 24019553
Thanks, anyway you should try decompiling & compacting..It might help.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month18 days, 14 hours left to enroll

834 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