Access 2007 DB Crashing On A Particular PC

[rajeshsarin]

Folks,

I have a database that is roughly 15MB in size and is shared by around 12 users simultaneously. The database sits in a windowss 2008 SBS file server.

On one of the PC's the database is crashing very frequently, especially when a user tries to type a long note in the notes field (which is set to memo).

Any ideas or suggestions??

Cheers

 

[SOS]

Okay,

1. The database needs to be split (frontend/backend with tables only in the backend and the backend on the server and then a COPY of the frontend on EACH USER'S MACHINE).

2. If you do not do it that way you will most likely end up with problems like this as well as corruption issues.