Access databases can only be open by one user at a time.
It would be wise to open a connection , read all data, then close the connection.
Begginnerdev
Practically a Posting Shark
893 posts since Apr 2010
Reputation Points: 198
Solved Threads: 149
Skill Endorsements: 9
On the computer '192.168.1.24' should exist a shared folder published as 'LandTransfer'.
When you share the folder, go to the advanced share options, and set the share permission to full for every.
If the computer '192.168.1.24' belongs to an Active Directory Domain, and yours also, to the same domain, then on the '192.168.1.24' computer you must give permissions to domain users to the folder to modify (not to the share). Otherwise, if both computers are stand-alone (not acive directory integrated) you must create a network unit( S: or what else is free) , pointin to the share in '192.168.1.24' and supply the user credentials using the computername\username and the passwor for an existing user in the '192.168.1.24' computer. In this case, you must change your connection string to "S:/Database/LTMS.mdb".
Alsu you'll need to give local modify permissions to the folder for the username credential you used. (see this KB)
@begginerdev: An Access db can be acessed from many users at same time. See this article.
hope this helps
lolafuertes
Practically a Posting Shark
895 posts since Oct 2008
Reputation Points: 164
Solved Threads: 189
Skill Endorsements: 5