Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by KathrynM
-
Database has reached Maximum size
Thanks for the replies, I know that 97 max size is 1gb. But what I really need to know is there a way to stop the DB maxing out for no apparent reason, as one day it is working and then the next day - maxing out. Just before the maxing started, some new pc's were installed and old ones removed...- KathrynM
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Database has reached Maximum size
HELP. Very recently I keep getting this message when running queries in Access 97. The queries are not very complicated just extracting records by dates from a linked table via ODBC. And this message "Database has reached maximum size" keeps popping up and maxing out my db. Has anyone seen...- KathrynM
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Update automatically every day to show records for last 365 days
Tony I need to make a local table as the original table is very very large and I need to run many queries from this original table. The majority of these queries being well within the last year. thanks KathrynM- KathrynM
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Update automatically every day to show records for last 365 days
Hello there I am trying to make a local table based on the last 365 days, as the table I am linking from is extremely large. I was thinking I need to set up a make table query for my local table and then an append and delete query to update automatically every day to my local table. Does...- KathrynM
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
