I'm having some new problems with my database. Specifically, when I try to open a few reports and a union query I get an error that says there is not enough memory to execute the command.
The union query will open in datasheet view, and display all the correct information. However, when I go to SQL view the screen is blank. I need to make some adjustments to this query, but I don't know if I have to retype the SQL statements, or since the info shows up are they hidden somehow?
The database is split, and each end is fairly small (front 3.76 mb, back 6.5 mb). I don't understand what I need to do to fix the memory problem. It does not seem to be linked to my PC, the users are experiencing the same problems I am.
Does anyone have any suggestions?
Thanks in advance,
Jennie
The union query will open in datasheet view, and display all the correct information. However, when I go to SQL view the screen is blank. I need to make some adjustments to this query, but I don't know if I have to retype the SQL statements, or since the info shows up are they hidden somehow?
The database is split, and each end is fairly small (front 3.76 mb, back 6.5 mb). I don't understand what I need to do to fix the memory problem. It does not seem to be linked to my PC, the users are experiencing the same problems I am.
Does anyone have any suggestions?
Thanks in advance,
Jennie