Database Connection 
Author: P. S
Visited 1057,
Followers 1,
Shared 0
Is it possible, for a non-expert, to connect an Access Database to a webpage.
So, someone types something into a search field, the database finds a corresponding record and displays the other fields in that record.
The database must also be updated from access on another PC.
Sort of how you see orders being updated, you put in your order number, it then shows it's progress that someone is updating elsewhere.
Or, maybe a thord party add-in is avaialble for this sort of thing.
Any suggestions?
Posted on the
in general : NO or it depends !
what do you mean?
do you have an ACCESS DB that already contains this data or what?
if yes , you have to do everything yourself with programming.
Anyway WebsiteX5 connects automatically ONLY to MYSQL DBs and there is a paid plugin that allows you to view/edit/delete records from the DB, the object is called DBViewer.
https://market.websitex5.com/it/oggetti/anteprima/371262fa-27c5-421a-9127-852da219d4
The DB must be on your host (linux) and you can connect from any PC that is connected to the internet... but obviously for specific things you have to know how to program to work with it, except for the functions already provided.
Author
Thankyou Claudio D.
Yes - i already have an Access Database.
I will take a good look at DBViewer.
Thanks.
remember that it ONLY works with MYSQL DBs!!!
not with Access DBs
Some ISP's offer either a MySQL database or a Microsoft database.
Microsoft server or Apache server.
MS Access is able to create code that can be run on Microsoft web servers.
But you should consider using database tool like AppGini. https://bigprof.com/appgini/
It is rather easy to use and it creates applications that run on "normal" servers and MySql database.
Here: http://eksempelsite.dk/side-4.html is an (old) example of a simple app created with AppGini.
Here is a also simple but a bit more complex solution: http://eksempelsite.dk/udstillinger/ - also created with AppGini
Here: http://eksempelsite.dk/udstillinger/Emner02.php is a view created manually. The view is from the second example database.