G
Guest
I think my database may have finally outgrown Access 2003, but I cannot
convince my users to move to something bigger (yet). So, at this time, I need
to try to get the database working, while I continue to try to convince the
user to bite the bullet and pay for the new upgraded application.
I'm hoping I can describe the problems I'm seeing and see if someone can
help me track down the problem (if there is something to track down anyway).
My database has about 45 tables, 118 queries, numerous forms (one with too
many controls really) and some reports and a good deal of code in modules.
Currently, I'm having problems with my queries sometimes working and
sometimes giving me error messages like "Query to complex" or something like
"mismatched number of columns between the queries". I do have a number of
union queries, but sometimes I get this second message on queries that are
not using a union query and has no underlying union query. I a lot of my
queries do use other queries as underlying queries, but when I've been
getting the complex message, I have done what I can to directly reference the
table, instead of it's base query. (I typically create a base query for all
tables, then use those base queries in everything else). In this case, I'm
assuming it's hurting me so I am removing some of them where I can.
Almost all of the tables have RFI relationships, so there are a large number
of those (and yes the tables are in a back-end database).
I have done a compact/repair numerous times, with no luck. I have also tried
creating a new blank database and importing all the objects into the new
database. Most of the attempts lock up and crash before the objects are
imported into the new database. On the occasions it does work, the new
database is just as unstable.
I'm not sure this is the best newsgroup for this question, but since I can
duplicate the problem by simply trying to run some of the queries, I figured
I would try posting here.
I have tried to run the Performance Analyzer, but it locks up and crashes,
giving me the dialog to to repair and reopen my database (I am sick of this
dialog box)!
Can anyone give me some things to look for to help me to try to figure out
what I can do (if anything) to fix my problems?
I am wondering if I have too many relationships? Is that possible?
Thanks for any suggestions.
Larry
convince my users to move to something bigger (yet). So, at this time, I need
to try to get the database working, while I continue to try to convince the
user to bite the bullet and pay for the new upgraded application.
I'm hoping I can describe the problems I'm seeing and see if someone can
help me track down the problem (if there is something to track down anyway).
My database has about 45 tables, 118 queries, numerous forms (one with too
many controls really) and some reports and a good deal of code in modules.
Currently, I'm having problems with my queries sometimes working and
sometimes giving me error messages like "Query to complex" or something like
"mismatched number of columns between the queries". I do have a number of
union queries, but sometimes I get this second message on queries that are
not using a union query and has no underlying union query. I a lot of my
queries do use other queries as underlying queries, but when I've been
getting the complex message, I have done what I can to directly reference the
table, instead of it's base query. (I typically create a base query for all
tables, then use those base queries in everything else). In this case, I'm
assuming it's hurting me so I am removing some of them where I can.
Almost all of the tables have RFI relationships, so there are a large number
of those (and yes the tables are in a back-end database).
I have done a compact/repair numerous times, with no luck. I have also tried
creating a new blank database and importing all the objects into the new
database. Most of the attempts lock up and crash before the objects are
imported into the new database. On the occasions it does work, the new
database is just as unstable.
I'm not sure this is the best newsgroup for this question, but since I can
duplicate the problem by simply trying to run some of the queries, I figured
I would try posting here.
I have tried to run the Performance Analyzer, but it locks up and crashes,
giving me the dialog to to repair and reopen my database (I am sick of this
dialog box)!
Can anyone give me some things to look for to help me to try to figure out
what I can do (if anything) to fix my problems?
I am wondering if I have too many relationships? Is that possible?
Thanks for any suggestions.
Larry