Problems with Database Entry in Contact Database

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

We have an Access 2000 database that we converted from
1997. The database -- which is built from the Contact
Database template that comes with Access is now giving us
a strange problem that did not occur before the
conversion. I do not note if it is occuring because of
the conversion or not.

Anyway, when we try to enter data in the "Notes" field of
the Call Details Subform (part of the Calls Form), the
Application simply freezes up. We cannot save the entry
in the field and it won't let us tab out of the field.
It is frozen. We have to use Window Manager (thru
CTRL+ALT+DEL) to clsoe the CALLS window and then we
cannot get to the calls form through the Presentation
Form.

We need to close Access entirely and reopen it to restore
it. Our database is on a LAN server, with mostly Windows
XP systems (but we do have a few Windows 2000 online, but
rarely are being used) and has no other problems running.

I'd appreciate any help anyone can suggest to help us
with this problem.
 
First do a repair and compact on the database. It could be that some of the
data in the memo field is corrupted.

It appears that this is happening on all machines, and that would be because
either all the front-ends have a problem, or you are using 1 database from
the server. I suspect the latter. Immediately, split the database into a
front-end and back-end if you haven't done so. There is a wizard to help
you. Otherwise just make a copy of the file and delete all the tables from 1
of them and everything else from the other. Then link the tables. Distribute
a copy of the front-end to each workstation.

If the problem continues, find the offending workstation be trying them one
at a time.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks for the info, but I am confused.

Our database is on a server, and I have split the
database into front and back-end -- but both are on the
server in two different folders. Should I actually
install a copy of the front-end on each individual
computer (there's not many)?
 
Back
Top