Click here to Skip to main content
15,889,034 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Currently MS access database file (.accdb) and a front end application to use it( developed in VB.17 (.exe)), is on same PC.

2-3 other PC/Laptop given shortcut of this exe. So all computers are using it in LAN.

Is it possible to put the access database file online (Google drive/ dropbox or any other) and use it through vb application from pc ?

In short, access database file on internet and VB application to connect and use it on PC or Laptop. (and on android phone, if possible).

What I have tried:

I am using LAN but want database to be on internet so that it can be accessed from anywhere.
Posted
Updated 24-Aug-18 23:49pm

Yes, you can ... but it isn't a good idea.

There are quite a few reasons why not, and they start with:
1) Multi Usability - which is after all what the internet is all about! Access is not a good multiuser DB at all - it can be used that way, but it always gives problems, mostly intermittent. And don't even ask about performance! Even on a LAN, you are much better off using a multiuser DB system such as MySQL or MS SQL - the performance will be better, and so will the reliability. Remember that when you use an Access DB on a different computer, all of the processing is done locally - so all of the data has to be transferred over the network to find out if it is needed. As the DB grows in size, the performance worsens because more and more data is flooding the network. With a multiuser DB, the processing is local to the DB itself instead of at the client computer. Adding the internet to this adds a new layer of slowness ...

2) Security. To use an Access DB over the internet, you need to have it publically available for both read and write - which means anyone who wants to to examine, alter, or delete your DB - that's not a good idea! Most hosting services hide MS SQL and MySQL from direct access for better security, and SQL requires a login before you even get close to the DB!

Seriously, I wouldn't do it. I'd look at MS SQL Server either as is (if your host allows) or better via a service (that you'd have to write) which makes the requests for you and returns your query results to your system.
 
Share this answer
 
Access is a file based database engine, so everyone should be able to work with it via a Windows or SAMBA share.

Do not do this for security and performance reasons.

If you need a centralized database you should migrate to a proper database server (MS SQL Server has upgrade methods) and you will need to change your VB source code.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900