I've recently wrote some code to update an inventory table within a database. The program works great; the problem is that many machines access this database at any given time, and I'm concerned that at one point my program will not be able to update the table because of too much traffic. Is this even possible? This data is very critical and I must make sure that this information is updated when needed. If so, is there some sort of return value that can be sent back to VB6 confirming the save data.

Please help me understand this further, I'm fairly new communicating with MS Access remotely.

Thanks,
RJ83