Hi,

I have a standalone exe and Database on my local machine at work, that I use as a Knowledge Base for myself.

Now the rest of the office wants to be able to read and update the information in the DB.

My question is, how do I go about coding this. I currently define my DB like this .

Option Explicit

Private Const dbname = "C:\program files\Knowledgebase\knowledgebase.mdb"

and open it like .

Set dbase = ws.OpenDatabase(dbname)

a Obviously I need to locate the directory on a network drive. What is the code I need to open the DB ?

b I need to think about record locking, How do I do that please, so people can update more than 1 record at a time. and how does the db know which is currently the last record, so it can get the next free one ?

Thanks.
Degz.