S
Steve in MN
Hi,
I have a program on a corporate network that is working at 11 different
buildings using different servers etc. The program is out for over a year
now and there have been no problems. Now one of the locations is telling me
that one of the options on the form will not open.
I copy the file back to my drive and test it and it works fine...I move it
back and they say that they cant open one of the options.
It is a click to select the option number and then press the button to
execute type of set up. The button they say doesn't work is only an open
form event...all of the other options work and forms and reports open.
What can cause this?
Our entire network is still on XP professional.
I have the db buttoned up with a bypass key on it, so I put a check for
missing references code and replace in the form start up and will see if that
works.
Is there some language that could look to see if the JET is intact or check
for global setttings or something?
This program is the front end and it links to another db that houses the
tables. In another locations back end file, i discovered a type of
corruption that isn't readily noticable. Most of the forms are suppose to be
set to Recordset type "Dynaset" but all of a sudden this building cant enter
records when linked to their back end program. I relink to another file and
it works fine, I link back to the original file and it wont enter records.
The only way it works is if I change the recordset to "Dnyaset"(Inconsistent
Updates), then it allows data to be entered into the form.
I tried importing the data to another file, but it has the same results, so
one of the tables must be corrupted in some way. The compact and repair
doesn't fix this either.
Does anybody know what would be causing this also and what are the options
to fix or find out what the issue is?
I have a program on a corporate network that is working at 11 different
buildings using different servers etc. The program is out for over a year
now and there have been no problems. Now one of the locations is telling me
that one of the options on the form will not open.
I copy the file back to my drive and test it and it works fine...I move it
back and they say that they cant open one of the options.
It is a click to select the option number and then press the button to
execute type of set up. The button they say doesn't work is only an open
form event...all of the other options work and forms and reports open.
What can cause this?
Our entire network is still on XP professional.
I have the db buttoned up with a bypass key on it, so I put a check for
missing references code and replace in the form start up and will see if that
works.
Is there some language that could look to see if the JET is intact or check
for global setttings or something?
This program is the front end and it links to another db that houses the
tables. In another locations back end file, i discovered a type of
corruption that isn't readily noticable. Most of the forms are suppose to be
set to Recordset type "Dynaset" but all of a sudden this building cant enter
records when linked to their back end program. I relink to another file and
it works fine, I link back to the original file and it wont enter records.
The only way it works is if I change the recordset to "Dnyaset"(Inconsistent
Updates), then it allows data to be entered into the form.
I tried importing the data to another file, but it has the same results, so
one of the tables must be corrupted in some way. The compact and repair
doesn't fix this either.
Does anybody know what would be causing this also and what are the options
to fix or find out what the issue is?