Hi
I have an Access database (front and back end, data in access, linked)created in Access 2000 that used to be working on XP machines for years without a problem, in office 2002-2003 and 2007. Then we got some pcs with Windows 7 and the database started having problems. First it crashed everytime someone using XP opened it and at the same time someone with Windows 7 opened it as well. So I removed the program from all xp machines.
But now I have the following problems.The system is working OK for a day or two and then without a warning:
1. It may stop responding. I traced it to hang in the select statement that opens a table with the id as criteria.
2. It produces the message "Cannot open database. It may not be a database that your application recognizes, or the file may be corrupt." when trying to run some code that assign a number to a field.
When I try to open the table it opens and everything seems OK but the code does not work. One time two records were corrupter (#error) but usually the table is OK.
I noticed that most of the times but not all it crashes on the same machine. Also I think the problem has to do either with the table or while trying to run vba code.
In both cases in order to solve the problem I take the back end from the day before, delete data and copy the table from the current day.
Until now, I have tried, compiling, compact and repair, checked the libraries, regional settings. I do not now what else to try.
I would appreciate it if someone could advise me.
Thanks
Stalo
I have an Access database (front and back end, data in access, linked)created in Access 2000 that used to be working on XP machines for years without a problem, in office 2002-2003 and 2007. Then we got some pcs with Windows 7 and the database started having problems. First it crashed everytime someone using XP opened it and at the same time someone with Windows 7 opened it as well. So I removed the program from all xp machines.
But now I have the following problems.The system is working OK for a day or two and then without a warning:
1. It may stop responding. I traced it to hang in the select statement that opens a table with the id as criteria.
2. It produces the message "Cannot open database. It may not be a database that your application recognizes, or the file may be corrupt." when trying to run some code that assign a number to a field.
When I try to open the table it opens and everything seems OK but the code does not work. One time two records were corrupter (#error) but usually the table is OK.
I noticed that most of the times but not all it crashes on the same machine. Also I think the problem has to do either with the table or while trying to run vba code.
In both cases in order to solve the problem I take the back end from the day before, delete data and copy the table from the current day.
Until now, I have tried, compiling, compact and repair, checked the libraries, regional settings. I do not now what else to try.
I would appreciate it if someone could advise me.
Thanks
Stalo