I have a question about distributed database.
My project is an inventory system.
I don't using dbms like sql server, oracle, or mysql, but i'm using Ms.Access (.mdb) for my database.
I'm using 3 computer on my local network (2 client and 1 server).
Both client access database to server computer.
When i insert thousands of data from my application to .mdb on server computer, it needs a long time (about 1.5 minutes).
It will become a trouble to user client.
I can't create a trigger in Ms.Access.
So, what should i do to increase this connection?
Please give me a theory or a project example.
Gerald.