distributed database

Jul 3 2012 12:45 PM
Hi,
I'm newbie c# developer, i'm doing my last work in college. 

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.

Thank you very much,
Gerald.

Answers (1)