Access grows hourly

We have a Access 2007 Database which is splitted in 2 files, a Programm File where the codes and queries are located and a Data File where all the tables reside.

Since some weeks, only the Program File from this database grows hourly from 3MB to 150MB at the end of the day. After the last User from 10 closes the database, the "repair and compress" feature will automatically shrink the file again to 3MB but the most time, we can't use the database such a way, because it's too slow.

We don't know this problem exists since we had updated all clients from Access 07 SP1 to SP2 or if it's the result of some changes at the code.

We tried to create a third database file for all temporary records, but the problem still exists.

We need a solution for this grow problem.

Habilidades: Vale Tudo, Engenharia, Microsoft Access, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Veja mais: php programm codes, php programm, sp1, project management access, hourly, repair management php, changes data access, create code access, create codes access, project sp1, slow queries, codes access 2007, use code access, access create database, create access end, program use access database, project file compress, project create access database, project management records, project php access, access solution, compress file, use codes database access, changes access, access data project 2007

Acerca do Empregador:
( 1 comentário ) Switzerland

ID do Projeto: #2988835

Concedido a:


See private message.

$85 USD em 10 dias
(362 Comentários)