MS Access / VB App - On XP Pro SP1 - Mutual Exclusion

J

Jon Bailey

Hey all,

I have 3 PCs setup on a peer to peer network. They are top
spec with XP pro installed.

Im having problems with data sharing on the network. A
software program I use needs access to a data directory.
This directory is shared accross the network with FULL
CONTROL for EVERYBODY.

At the moment the two other PCs have mapped drives to the
data share and all can access. BUT. The data is only
letting me access it and locking the other two out till I
have released control.

Any ideas.

The program is a VB software app my company designed and
built and now provides to the fabrication industry
(windows and PVCu products).

The program makes use of several MS Access DBs (swapping
to SQL in the new version) the data stores prices,
customers, measurements and other information for the
manufacturing process.

This software is now live in over 40 installations and
works fine in about 99% of them, I only seem to have this
problem in XP and on peer to peer networks (customers
networks, we have very little say in the setup or
structure or type of network used)

The only people using the PCs have admin rights as
security is not a major issue, I try to make it but u have
to see these people b4 judging the network, they would
take a years course at university to open a bag of crisps.

And for the moment FULL CONTROL is active for everybody to
allow me to rule out permissions as a source for my
problems (I hope).

I understand the concept well of mutual exclusion, but
even in MS Access and Word docs, they will let multiple
users view documents and table contents without write
ability until the primary user released control of the
document.

On our XP network at the main office this works fine,
multiple users have read rights but no write access until
control is released. But a few customers will have the
process in the Task manager as 'Not responding' until
promary user control is released, then the process
continues to activate normally and display the data.

Its driving me crazy, any suggestions or similar issues
encountered would greatly help me out.

Jon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top