By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Database Corruption

P: 8
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
Oct 6 '06 #1
Share this Question
Share on Google+
3 Replies


100+
P: 143
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.
Oct 6 '06 #2

P: 3
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
Oct 6 '06 #3

P: 8
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}.
Oct 7 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.