Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

VB Accessing an Access Database across a network

I am currently developing software whereby VB accesses an (access) database on a local machine.  Fine, no problem.  

However we (now) plan to be able to run the software across a network, allowing several client machines (40 max) to access a database on a server.

(trafic is likely to be minimal with no more than 2-3 machines at once trying it accessing it).

Possible solutions are:

1. Having a shared drive on the server, whereby any client machine can access it as if it were on a local drive.

2. Writing client and server ends, using a specific port for data transfer.

I've no idea how to implement the 2nd option.  If anyone has done this kind of thing before then I'd love to hear from you!

1 Solution
If the max for user is 40 then don't even bother on option 2. The company i'm working for has almost the same situation like this one. The only difference with our company is that the traffic is about 10 machines at once and we never had problems with it...

I have also not heard or even tried the 2nd option. for the 1st option what you would have to do is just change the file path in your code where you are specifying the Access database name.
Also you could think of using ODBC so that in future even if your database needs to be shifted to some other machine then you just have to change the ODBC settings in the machine instead of changing the path of the file in your code and re-compiling the executable.


lj75Author Commented:
I didn't realise how good the database driver is...I've found that all it requires is a shared drive.

It does have security implications but for the required purpose it isn't a big problem.

Thanks for the ODBC comment, I'll keep that in mind.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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