• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

client/server threads

ive just started a project using ms-access as the DB in a client/server environment. id essentially like the server to control most of the processing. but; im a bit of a beginner when it comes to setting the environment up... (ie when to use the client, server, when to incorporate threads etc. and how??) could you enlighten me?
  • 2
1 Solution
Can you set MS-Access up in client/server mode?

I didn't think MS-Access could run as a server...

You can download a free (proper) database from;


Your question seems a bit broad...  Do you have any more specific questions?
minichickenAuthor Commented:
i'll give you my scenario, if you wouldnt mind helping me out!

my project requires adding/deleting/modifying clients/products/sales-transactions to/from a ms-access DB using a client-server environment.

what im thinking is an initial gui screen with a few buttons. one button "adds a client". the button opens up another window with appropriate textboxes (name, surname, etc.). the field values entered are stored in variables and an object "client c = new client(string, string, etc)" is made. This object is carried over to a server.

The server reverses the operation, retreives the values stored in the object (into variables again (string, string, etc)). and these are carried over to the add-to-access-db function (which stores the values in the db-table 'client').

1. problem here is to retrieve the data from the object sent to the server, you need to know the class-client.
2. the server only has 1 port per transfer.
3. the origional gui has about 8 buttons ranging from 'add client' to 'delete product' and do i have to create a port for each.

needless to say, if so, how do i do this.


or could you recommend a better solution?
Tommy BraasCommented:
Hi minichicken,

I would recommend creating a Java service on the machine running the access database, and then have the clients connect to that service. To reasons for this, one is that it shields the client application from the specifics of the database implementation, two it allows consistent access for virtually any number of clients taking care of data contention issues.


Tommy BraasCommented:

Thank you much sir! Good luck!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now