I'm having trouble with a DB that I've been using for four years in a multi-user environment. (Windows XP; Access 2000; Novell Network) Started with one user as she got a new WinXP PC (had Win2K - not totally convinced that she didn't have the problem before the new PC); she wasn't able to do a keyword search - it would bring up every record, but other users were fine. Then, it started to do it on my PC as well (WinXP - even though I had my XP for a year longer), but other users are still fine. My code still looks fine, and apparently works for others.
So, thinking there may be some corruption going on, I decided to create a new DB and import in tables, queries, forms, reports, and modules. Only three of 20 forms show up as options to import and only a portion of the reports show up. All the tables and queries appear. When I go back to the "faulty" database, the forms are there and do work from my "menu form".
Then, I tried compacting the "faulty" database, but I don't get the message in the lower left saying it is compacting; the hourglass comes up, then the DB opens - the size stays the same. So, I don't think it is compacting.
Any ideas ????
Thanks - and I do appreciate this forum - has saved me alot of time over the years.
So, thinking there may be some corruption going on, I decided to create a new DB and import in tables, queries, forms, reports, and modules. Only three of 20 forms show up as options to import and only a portion of the reports show up. All the tables and queries appear. When I go back to the "faulty" database, the forms are there and do work from my "menu form".
Then, I tried compacting the "faulty" database, but I don't get the message in the lower left saying it is compacting; the hourglass comes up, then the DB opens - the size stays the same. So, I don't think it is compacting.
Any ideas ????
Thanks - and I do appreciate this forum - has saved me alot of time over the years.
