Solved

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

Posted on 2009-03-30
10
577 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
 
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

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

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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.

895 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

16 Experts available now in Live!

Get 1:1 Help Now