How to view a BD Access form directly on a website?

Asked

Viewed 1,160 times

0

I want to put the information of a .mdb on a website, to make it available to the public.

When opened in Access, it has forms to carry out queries.

I can have a website that directly displays these forms on the screen?

Or I would have to create new forms and pull the information directly from the queries?

ms-access asp

  • It is possible if you use Sharepoint.

  • But in Sharepoint you have to be a user, right? It seems that it is not possible to have anonymous access, and I would need this to open for the general public.

  • You can make it available for anonymous access. But Sharepoint is not as "affordable" as you need to invest in your environment or use Sharepoint online (which is not very cheap)

  • I see here that Sharepoint online charges per user. It means that I will have to pay for every user who accesses anonymously?

  • Unfortunately I don’t know much about Sharepoint online, I can’t answer you.

  • If the structure is not large and your access demand is low convert your base to sql express or my-sql, access is not made for web access.

  • Want to open a query form or to fill with data in the database?

Show 2 more comments

1 answer

1

From what I understand you would like to display the access form directly on a web page in correct ASP?

If that is what I say is not possible, what you can do is convert the data either from an access table or query to the static HTML format by choosing an HTML document template or using the proper access layout, just right-click on the table/query and select to export data to HTML format.

Now if you want something dynamic, you can create a server linked in SQL SERVER with your MDB and from there create reports with REPORTING SERVICES and make them available on your site.

Browser other questions tagged ms-access asp

You are not signed in. Login or sign up in order to post.