I have a problem with Access 2007, SP2, on a particular PC.
For a particular database, when using the Relationships view Access crashes sometimes when a table is added. It always crashes when I display all relationships.
Which table I add to the relationships view doesn't matter, so it seems to be related to the number of tables on the view.
In total there are only about 20 tables in the database.
It seems to be some sort of database corruption, but I can't seem to fix it.
Has anyone else encountered this problem? Has anyone found a solution to this glitch?
I found the solution. I had this problems as well. I got a new laptop with new operating system, new Office installation and it happened again. I couldn't believe it, but then I realized the only link between the two was my Quick Access toolbar. I had brought the access.qat over from the previous machine. When I deleted the access.qat my relationships worked fine.
I haven't tried to rebuild the .qat to find the culprit, but I will rebuild that very slowly checking out the function of relationships along the way.
14  4392 
What OS? Is the OS fully patched? Import the db onto a fresh db and see if the problem follows. Have you tried Compact and Repair?
Windows Vista, with all updates.
I've tried importing to a fresh db, and tried Compact and Repair.
There are some issues that are unique to Vista. I don't know if this is one of them. Allen Browne usually has a pretty good list. Maybe he has noted it. http://allenbrowne.com/Access2007.html
I checked the site and haven't found this particular problem mentioned.
Has anyone encountered the problem where Access crashes when a table is added to the Relationship Diagram?
Yeah, it's INFURIATING. Can't make any joins, can't edit any joins made in previous versions, CAN'T CAN'T CAN'T.
In my case the database relationships worked on a different computer.
I still haven't managed to fix the problem on the original computer though.
Yes, this problem happens with me! I am really fed up with Ms Access 2007 and thinking to move to FoxPro.
It seems I found a trick to solve the problem! Do the following easy steps:
1-In the database where the problem occurs (say DB1), delete all the relationships.
2-Create a new database (say DB2).
3-In DB2, import all the tables from DB1. (Do NOT import anything else: Queries, forms, ...)
4-In DB2, recreate the relationships.
5-In DB2, create the other objects (queries, forms, etc.). You have to create the forms and modules from scratch. However, you don't need to rewrite the code in the modules; you can just copy it from DB1.
I hope this works for you.
At first it seemed to me that the problem is because Access cannot handle some automatic options. However, after few days of trying to solve the problem I've found it is easy but annoying. The problem is simply because the Relationship window cannot display relationships that exceed a certain number. The solution is simple:
In the Relationships window, once you finish with setting all the relations of a certain table, simply hide that table (right-click on it and choose "Hide Table"). This keeps the number of related tables that are displayed at minimum and solves the problem.
If later on you want to check the relationships related to a certain hidden table, do NOT choose Show All. Rather, hide some related tables, and then choose Show Table, and then double click the table you want.
If your Relationships window is already corrupted because it has many related tables, do the steps I mentioned in the prior post. (As you build the relationships, do not forget to hide the table that you've finished with.)
NOTES:
1-This problem does not mean that the relationships are not built or that Access cannot handle them. Rather, the problem is only with displaying the relationships.
2-After you've built the relationships, if you want to just check them, you can use the following way:
In the Database Tools tab, choose Database Documenter. Then choose all the tables that you want to check their relations. Then, click the Options button and enable only Relationships. Then click Ok. Access will create a report of all the relations.
Micho2008, have you tried doing a re-install of MS Access, or trying your database on a different PC?
The problem only occurs on a few computers or installs.
Chances are if you try the same database on a different computer you will be able to view all relationships, however if you put the database back on a problem PC it will crash when opening a relationships window with too many relationships on it. In that case, reduce the number of relationships on a PC that doesn't crash at the database window...
I'll get around to doing a re-install and see if that fixes the problem on my PC.
I found the solution. I had this problems as well. I got a new laptop with new operating system, new Office installation and it happened again. I couldn't believe it, but then I realized the only link between the two was my Quick Access toolbar. I had brought the access.qat over from the previous machine. When I deleted the access.qat my relationships worked fine.
I haven't tried to rebuild the .qat to find the culprit, but I will rebuild that very slowly checking out the function of relationships along the way.
Thank you very much for that update!
Deleting access.qat fixed the problem for me. Thanks!
What a crazy solution! But Access does seem to have a mind of its own...
Sign in to post your reply or Sign up for a free account.
Similar topics
by: 8leggeddj |
last post by:
Hello,
I am having a problem when using access xp as a frontend for sql server
2000.
I have been trying to update a number of stored procedures (Just simple
adding fields etc) which results in...
|
by: Mike Ridley |
last post by:
I am trying to create a new query using 3 linked tables. As soon as I
add the third table to the design grid Access crashes.
I have looked in the newsgroup and find that there have been problems...
|
by: Chris Hankey |
last post by:
I having a strange and annoying problem where Access crashes when the
user copies (to the clipboard) the results of a query. The message is
not very helpful. It simply says - "Microsoft Access...
|
by: Ray |
last post by:
Stop me if you've heard this, but I am running Access 2002 and all of
a sudden, if I design a particular form (it's been working fine for
ages), Access crashes rather than open it in design view.
...
|
by: jessicapree |
last post by:
When I apply a filter for a subgroup of data on my main form in my
database, I can use about 4 or 5 macros and then Access "crashes" --
all of the macros stop working and I have to exit Access. I...
|
by: NissanSE98 |
last post by:
Hello,
I'm building an asp.net application that will get contact information from an Access Database that is linked to microsoft exchange or outlook.
I go to link tables in Access and choose...
|
by: mnjkahn via AccessMonster.com |
last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I
right click on the field name in Query Design View, and then click Build,
Access crashes before the Build window...
|
by: ironmanlarry |
last post by:
Hey,
I'm trying to take an mdb file and make an mde file from it. I've done it before without any problem, but now when I try to do it, Access will go into Not Responding mode as soon as I click...
|
by: MariaTorvalds |
last post by:
I have a problem where if I use a calculated control, for example =Date()) on my form, PLUS I have a subform on a tab control on the same form, then when I refresh the record (by menu command or VBA...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
