publishing a database to web (1 Viewer)

D

deletedT

Guest

Local time

Today, 23:18

Joined

Feb 2, 2019

Messages

1,218

• Oct 22, 2019

• #1

I don't know if it's possible or not.
I have a split database with a Microsoft SQL 2016 BE.
Several users use their copy of FE on their PCs to register/search data and do their daily job.

Is it possible to publish a search form to web? I've been asked to allow the users search one of the tables when they are out of office.

Any kind of advice, link, tutorial that may help is much appreciated.

I don't know if it helps or not but I have 10 licenses of Office 365.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:18

Joined

Oct 29, 2018

Messages

21,473

• Oct 22, 2019

• #2

Hi. Very possible, but you won't be using Access to make it. You'll have to use a web platform like PHP, .Net, Vue.js, and many others.

 

D

deletedT

Guest

Local time

Today, 23:18

Joined

Feb 2, 2019

Messages

1,218

• Oct 22, 2019

• #3

I know PHP well enough and have been using it with MySql for a long time.

I have a web server that runs php. What shall I do next?
Simply read the data from sql server and show it in a html/css form?

Isn't there any service out there that can automate this?

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:18

Joined

Oct 29, 2018

Messages

21,473

• Oct 22, 2019

• #4

Tera said:

I know PHP well enough and have been using it with MySql for a long time.

I have a web server that runs php. What shall I do next?
Simply read the data from sql server and show it in a html/css form?

Isn't there any service out there that can automate this?

Click to expand...

Yup. Pretty much. There are platforms available to help speed things up to avoid starting from scratch. For example, WordPress, Joomla, etc.

 

D

deletedT

Guest

Local time

Today, 23:18

Joined

Feb 2, 2019

Messages

1,218

• Oct 22, 2019

• #5

I think they offer only creating a web site. Not a page that connects to a local sql server to search/edit data.

 

theDBguy

I’m here to help

Staff member

Local time

Today, 15:18

Joined

Oct 29, 2018

Messages

21,473

• Oct 22, 2019

• #6

Tera said:

I think they offer only creating a web site. Not a page that connects to a local sql server to search/edit data.

Click to expand...

Hi. You may be right, but there's got to be something available you can use. If not, it shouldn't take too long to create a simple CRUD site.