How to know if database is corrupted?

calvinle

Registered User.
Local time
Today, 10:12
Joined
Sep 26, 2014
Messages
332
Hi,

I think the database that Im working on is corrupted.
I have a subform cotinuous, then i have a control textbox to sum the whole field. Doesn't work. It shows #Error.
I create another form then redo the same activity, and now works.
On another form, i have a subform on a form, i can add data
To it. When my colleague opens it, he cannot add data to it.
I didnt add any enable or disable code to the database.
Also, one of the combobox query data from a backend table, when my colleague tried to access, it says " Cannot update becuz database [path] cannot be found". Then he click again in that combobox then it works.

Is it possible that the database is corruept?
 
I always compact and repair before i save and close my working station.
 
Are you on a network or standalone pc?

Is your database split be/fe?
 
The front end is o each user computer and the linked table is backend on network.
 
The backend needs to be compacted and repaired, perhaps?

However, your ability to add data and your colleague's Inability to add data do not always point to corruption. Everyone who touches the back-end database needs Windows MODIFY access level to the folder in question. Those who lack that level of access would be stick in READ_ONLY mode. Can your colleague do ANY updating at all in the database?

That "Path" comment also could be if you access the back end using mapped drive letters. Remember that anything after about drive M or N (usually the highest USB port) is dynamically mapped. To use it right, EVERYONE has to map exactly the same way.
 
The path is linked to the LAN server starting \\... So not personal drive.

However you made a super good point for the writing access to that LAN. I will double check that and confirm back. That employee is on vacation until nx week.

Thanks
 

Users who are viewing this thread

Back
Top Bottom