G
Guest
Working on an Access 03 db with program front end and data backend. This was
originally a badly designed unnormalized Access 2K db. Prior to conversion I
compacted and repaired outside the db. I then opened it and Access to
converted to 03 format. I made massive changes but 2 of the forms and 3
reports I kept. Before installing on the customers site I did a debug,
compact and repair. At the customers site I use a batch file to copy the
front end to the individual users C:\MSA_Prod\ location. Each user is using
their own new copy of the front end while being connected to the network
backend each time they use the batchfile. 2 hours after installation I get a
call the combo boxes are not working correctly and a query has stopped
working. The combo boxes no longer jump to the first instance of the first
letter entered. The query which uses the Date() function to limit the
results to todays entries shows no entries even though they do exist. Removal
of the Date() from the criteria in the query shows ALL the entries. Including
those entered today.
This smacks of corruption. Debug, compact and repair does not fix.
I used the Export to text file and Import from text file. That did not fix
the problem.
I imported the front end into XP and exported to text and imforted from
text. That seemed to work as the section Namemap was short.
NameMap = Begin
0x0acc0e55
End
On the corrupt ones the NameMap was 20+ lines
The problem is I amd unable to create a new report in a new db and export to
text with out having a large section in the NameMap portion.
How can I create a clean report or are the reports I have created and
exported to text and imported to text in a NEW db safe. The customer is not
happy as I have been attempting to correct this problem for over a week. HELP
originally a badly designed unnormalized Access 2K db. Prior to conversion I
compacted and repaired outside the db. I then opened it and Access to
converted to 03 format. I made massive changes but 2 of the forms and 3
reports I kept. Before installing on the customers site I did a debug,
compact and repair. At the customers site I use a batch file to copy the
front end to the individual users C:\MSA_Prod\ location. Each user is using
their own new copy of the front end while being connected to the network
backend each time they use the batchfile. 2 hours after installation I get a
call the combo boxes are not working correctly and a query has stopped
working. The combo boxes no longer jump to the first instance of the first
letter entered. The query which uses the Date() function to limit the
results to todays entries shows no entries even though they do exist. Removal
of the Date() from the criteria in the query shows ALL the entries. Including
those entered today.
This smacks of corruption. Debug, compact and repair does not fix.
I used the Export to text file and Import from text file. That did not fix
the problem.
I imported the front end into XP and exported to text and imforted from
text. That seemed to work as the section Namemap was short.
NameMap = Begin
0x0acc0e55
End
On the corrupt ones the NameMap was 20+ lines
The problem is I amd unable to create a new report in a new db and export to
text with out having a large section in the NameMap portion.
How can I create a clean report or are the reports I have created and
exported to text and imported to text in a NEW db safe. The customer is not
happy as I have been attempting to correct this problem for over a week. HELP