CODEWITHSUNDEEP
htmldatabasems-access
Yusaf Khaliq
Yusaf Khaliq

Reputation: 3393

Embed MS Access Form To Website Oline

I have a website online with just HTML and I am not willing to use any other programming language apart from Javascript. All I need to do is connect my Microsoft Access database on my computer to a form hosted online so when information is submitted online it is updated on MS access the next time I open the file up. Is this possible and how can it be done?

Upvotes: 2

Views: 12978

Answers (2)

Albert D. Kallal
Albert D. Kallal

Reputation: 49039

Turns out, you can do this with zero code. If you use office 365, and publish an Access web forms.

Any information entered into the Access web form will automatic appear in your local database. The synchronizing of data from the web site and pulling down of the records to a local copy works automatic and without the need to write any code. In fact the sync starts automatic when you launch the client application. (it runs in disconnected mode). And any records you enter in the client application will also sync up and appear on the web site.

So, you can use Access and write zero code, and this two way sync feature is built in.

You need Access 2010, and either SharePoint 2010 (enterprise), or you can use office 365 and the $6 per month p1 plan which also does support Access web publishing.

However, I suspect issues of user logons and security may well be a greater issue here, and thus office 365 might not be correct from a user logon point of view. You can invite up to 50 users to that site for the basic $6 per month, but all users of the site will require a logon (which can be due to being invited to the site).

There are two videos of mine here showing this setup in action here:

http://www.youtube.com/playlist?list=PL27E956A1537FE1C5&feature=plcp

Upvotes: 1

HK1
HK1

Reputation: 12210

I think what you are trying to do is very impractical. You'll need to use Server Side Javascript to insert your data into a database, preferably SQL Server, and then you'll have to write some kind of code to sync the SQL Server Database to your Access database.

Alternately, you could setup your Access database so it connects to the same instance of SQL Server as your website using ODBC linked tables or ADO. I cannot really recommend this, especially if the data you have in your Access database is anything you wouldn't want to be public. Also, using MS Access to access a database across the WAN/Internet is really not recommended although it can certainly be done, as long as you aren't working with large amounts of data, large quantity of records, etc.

I am not willing to use any other programming language apart from Javascript.

And why aren't you willing to use something else? I don't think you're going to get anywhere if you don't open your mind to using the right tools for the right job.

Here's something that might help you get connected to SQL from Javascript: How to connect to SQL Server database from JavaScript in the browser?

Upvotes: 1

Related Questions