Database Corruption

[PeterDavis]

Using Access 2002 on Windows xp

I have recently upgraded a database from Access 97 to Access 2002

I first upgraded the front-end databases, and everthing was fine. The back end would not convert so I imported all objects into a new Access 2002 shell.

Now it seems prone to corruption.

Any ideas what is causing it?

Thank you

[Tanis]

Corruption could be caused by the users not exiting properly. If they just close the DB using the X in the corner, this can cause corruption.

[SandyZ]

Is the front end corrupting or the back end?
Are your users accessing the front end on a server across T1 lines? I have had trouble with that in the past.

The solution was to move the back end data to SQL Server. It is much more stable. But another option is to have the users move the front end to their local hard drives, and just keep the back-end on the server.

Using Access 2002 on Windows xp

I have recently upgraded a database from Access 97 to Access 2002

I first upgraded the front-end databases, and everthing was fine. The back end would not convert so I imported all objects into a new Access 2002 shell.

Now it seems prone to corruption.

Any ideas what is causing it?

Thank you

[PeterDavis]

Is the front end corrupting or the back end?
Are your users accessing the front end on a server across T1 lines? I have had trouble with that in the past.

It is the back end mdb file which corrupts on the server. The front end mdb files are on the local workstation. The odd thing is that this configuration worked fine with Access 97. It was only when the backend was upgraded to 2000 that the problems started.

{Users can only exit by means of a command button but im any case, this is not when corruption occurs}.