Database Crashes on Form

[Linda RQ]

Hi Everyone,

Using Access 2003 but my database is set for default File format to Access
2000. It was created in 2000. The database has been working fine for 2
years. I have a front end and back end. The front end is located on our N
network drive. The back end is set up on the same drive but in a different
folder. We just started having problems when our IS dept upgraded the
computer that the users usually use to Windows XP Pro from Windows 2000. It
may be a coincidence because the same behaviour occures when I access the
file from my PC which has not been changed and has been working for 2 years.

The original problem started when the users added a new patient record. I
have a form with 2 subforms on it. The main form is Patients, the first
subform is the PtLocation and the second subform is PtTherapy. They can add
a new patient but when they click on the subform to add patient location,
the program crashes and the pop up reads

"Microsoft Office Access has encountered a problem and needs to close blah
blah blah. If you send an error report nothing comes back for a solution
and a copy of the front end of the database is created with _Backup tagged
on the end."

I have compacted and repaired several times, I have made a copy as well.

My second problem is when I try to make changes to the controls, it also
crashes with a different message

"Microsoft Office Access was uable to open the file N:\Reg-CP-CT etc
etc.....The file may not be an Access file, the path or filename specified
may be invorrect, or the file can not be opened exclusively. To repari the
file manually, on the Tools menu, point to Database Utilities, and then
click Compact and Repair Database.

I am working on a copy of the database and have copied the backend as well
and relinked the files and it still behaves the same way.

Thanks,
Linda

 

[Jeanette Cunningham]

Hi Linda,
one thing to try:
On each subform, put a hidden text box with the linking field as its control
source.
The linking field in your forms is probably PatientID - or whatever you
called the primary key of the patients table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Linda \(RQ\)]

Thanks Jeanette,

Already had that

Linda

Hi Linda,
one thing to try:
On each subform, put a hidden text box with the linking field as its
control source.
The linking field in your forms is probably PatientID - or whatever you
called the primary key of the patients table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jeanette Cunningham]

I don't know what is causing the crash.
However you could try this: Create a new 'bare bones' form to add a new
patient.
In 5 minutes you can use the form wizard to careate the forms to add a new
patient. Include only the primary key and foreign key fields and one or 2
other fields. Don't bother with formatting or layout.
Try the new form and observe if access crashes.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Gina Whipp]

Suggestion...

MAKE A COPY and try this on the copy. Create a new database and try
importing all your objects into it. Also take a look at the these two
websites on corruption, they might offer a solution that will work for you:

Try Allen Browne's article on Recovering from Corruption at:
http://allenbrowne.com/ser-47.html

Also you take a look at Tony Toews site
http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Linda RQ]

Thanks Gina,

Will get to work on this tomorrow

Suggestion...

MAKE A COPY and try this on the copy. Create a new database and try
importing all your objects into it. Also take a look at the these two
websites on corruption, they might offer a solution that will work for
you:

Try Allen Browne's article on Recovering from Corruption at:
http://allenbrowne.com/ser-47.html

Also you take a look at Tony Toews site
http://www.granite.ab.ca/access/corruptmdbs.htm


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II