Access database issue in multi user environment.

Question

I work on access 2000 database to create inquires and purchase orders on daily basis. This database has been placed in a shared folder for multi users.

Before I never had issues while working on the database. However, since couple of days ago, it is not working properly.

Few days ago, I created new inquiry in the database and I found some duplicate records in that inquiry. After that, I deleted duplicate records and then assigned purchase order.

But, when I opened the same inquiry in other PC. It was showing all previous duplicate records and the purchase order I assigned to that inquiry was related to the other supplier.

I tried to resolve this issue by disconnected map network drive and again create map network drive; however, it couldn't resolve this issue.

I can't figure out what is wrong with the database.

Any suggestions to resolve this issue would be highly appreciated.

Answer 1

Why don't you have the mdb? If all you have is an mde, you are stuck.

I can't explain why this is happening all of a sudden and only to you not others. The only way to do that is to see the code that is causing the errors and we would need the mdb for that.

Based on what you have told us, I'm reasonably sure that one of the problems here is the fact that this is not a split database,

You said something about tables may have been unlinked. But the only way that would be the case is with a split database.

Answer 2

Sorry for late responding. Actually, I don't have mdb file; therefore, I can't split database. I haven't found a solution of this problem as yet.

I have two questions. First, I have been working on this database (mde file) since 2011. Why, I've never had this kind of issue in the past?

Second, I am the only one in my department who is facing this kind of issue, otherwise rest of my colleagues are working on this same database without any issue.

If I am having this issue by not splitting the database, so why my colleagues are not having the same issue with the database?

The database is showing old records in my PC; however it is not showing latest records. It seems that somehow tables may have been unlink.

Would you please advise me as to how to resolve this issue?

Answer 3

No it means this issue was probably caused by NOT splitting the database.

Answer 4

It means this issue can't be resolved without splitting database.

Answer 5

I work on access 2000 database to create inquires and purchase orders on daily basis. This database has been placed in a shared folder for multi users.

That is an invitation to corruption!. EVERY multi-user application NEEDS to be split between a back end (the tables) and a front end (everything else). The back end is stored on a shared network drive and linked to the front ends which are stored on each user's PCs. That you haven't had problems until now is pure luck.