[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 604
  • Last Modified:

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...
0
John_BAS
Asked:
John_BAS
  • 6
  • 4
1 Solution
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now