X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Access In A Website, Access 2010 (Office 2010 Pro)    
post Nov 23 2016, 04:58 AM

Posts: 411
Joined: 28-April 02
From: Heathfield, England

Hi, I want to develop a website using Access as the database. (I'm using Access simply because I don't know SQL nor website languages so am trying to limit my learning to one thing and not both!) I will not always be able to connect to the internet when developing the website such as on a plane or staying in out of the way places or hotels that still charge and arm and a leg for the privilege of connecting to their £20 router if they have one and it works at an acceptable speed! What changes would I need to make, if any, to my laptop so that I can develop the website on the laptop and then copy everything to a server later? This is if that is possible!
Go to the top of the page
Start new topic
post Nov 23 2016, 05:38 AM

Posts: 429
Joined: 17-April 12
From: Germany

To make it short: It is not possible to use Access as database for a website.

You can connect an Access application to a database Server over the internet, but that would be something like MySQL or MS SQL-Server.

Or you can create a desktop application and connect to it via remote desktop.

What is your database supposed to do? And who will be using it?
Go to the top of the page
post Mar 1 2019, 11:20 AM

Posts: 216
Joined: 1-June 10

Don't despair, I am running a site using Access married with FrontPage 2000 @ CountyRealty.com.
Explore if you want.
Use the "Find Homes" tab and login using Firlands and Farm.
Database populates search results.

I need to dash to an appointment right now. Let me know what you think.

Self taught newbie just trying to remember that fields are in tables and controls are on forms.
Go to the top of the page
post Mar 2 2019, 08:14 AM

Posts: 112
Joined: 9-November 14

That's pretty interesting. I haven't heard of Front Page for years, not that I understand anything about web databases anyway:)

Oops, didn't notice there was a page 2 on the thread. I am referring to the countyrealty post.
This post has been edited by stevep: Mar 2 2019, 08:25 AM
Go to the top of the page
post May 14 2019, 07:17 PM

UA Admin
Posts: 37,237
Joined: 20-June 02
From: Newcastle, WA

"I haven't heard of Front Page for years, ..."

Microsoft deprecated Front Page years ago, so I'm not even sure you'd be able to find and obtain a copy to install.

If you go in the direction of creating a web app, go with Albert's recommendation, IMO. Visual Studio Express is a good deal.

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
post May 25 2019, 05:54 AM

Posts: 411
Joined: 28-April 02
From: Heathfield, England

Hey, this topic has suddenly sprung back into life and it's timely ... I didn't pursue the reason for the OP but I'm now back in the game with an SQL 2008 R2 database that I use with an Access 2016 (Office365) FE that contains some complimentary tables. I still can't do SQL 'properly' and I am constantly frustrated that it either won't/can't/I don't know how to do what I want or it makes it so complicated that I can't be bothered and resort back to the Access FE. So I would prefer to use the Access front end for everything and maybe gradually translate the Access SQL to Transact SQL over time. So I guess Visual Studio Express is the way to go, yes? Is there a good teaching website that can be recommended?

Thanks for the links sumosoftware I've looked at Zoho before and glanced at Caspio but couldn't find much about incorporating them in a website and if they will talk to SQL Server. Myabe I just missing it. frown.gif

And TinyGiant2010 ... I can't believe how cheap your property is! I used to have Frontpage 2003 but rather stupidly got shot of it when Microsoft launched Expression Web, that was a disaster!

Grover, there are many sites you can download Frontpage from (not suggesting you do!). 2003 was the last version and it is not on any offical compatability list for Win10 butmany say they still use it without any problem. I must admit the thought/product never crossed my mind.

Never doubt the courage of the French - they discovered that snails are edible!
Go to the top of the page
post May 25 2019, 12:12 PM

Posts: 411
Joined: 28-April 02
From: Heathfield, England

Thanks again George ...

"First, I am not sure whether you are thinking of using Access behind a website because you refer to an Access FE with a SQL Server BE. Are you actually planning to put this SQL Server BE behind a website as well? Access FE would mean a desktop, Windows environment." Well we are actually talking of the same setup as my other thread you are helping on so yes, it will consist of Access and an SQL database. But not the same one, just an identical copy (the license I have allows two installs). I was thinking (hoping) I could use Access with the SQL tables linked within the website using Visual Studio Express.

"There are no interface elements available in SQL Server." Yes, I know, that's why I find SQL an absolute pain by introducing an extra layer of complication! I'm an old dog who cannot be taught new SQL tricks. I've tried and find SQL completely incoherient, I've raised queries here that couldn't be answered ... that's not a pleasure it's purgatory. What I'm asking may not be the most perfect solution but a walking stick is faster for a blind man than a car! And an earlier post by Albert said he thought "for someone with VBA and Access experience then the free Edition of Visual Studio express is the path of least effort"

"If you want to use SQL Server as the data layer in an application, you need a tool to develop the interface and most of the logic." that's my question above ... Access FE with linked Access BE and SQL tables and Visual Studio?

I have never suggested nor considered using Frontpage, I was simply responding to your comment that you were "not even sure you'd be able to find and obtain a copy to install".

"you'll probably find most offer more recent versions of SQL Server, like 2017 or 2019" I'm sure they will but my use of 2008 is tied to the app that installed it and updates the database in it. I have no control whatsoever over it, I only want to read the tables anyway, I don't want to interfer with someone else's setup that works. But I have already established that if I install the app on a (Windows) VPS it installs 2008 as it should and automatically downloads updates an it should.

Never doubt the courage of the French - they discovered that snails are edible!
Go to the top of the page
post Sep 5 2019, 11:24 AM

Posts: 216
Joined: 1-June 10

Deep cleansing breath...... okay here goes.
If someone today told you they have an Access 2000 mdb with 25000 records in one table, 1000 in a second table, and 500 in a third table; and they needed to display this on the internet, how would you recommend they do this?
All three tables get updated daily. Database gets uploaded to webhost daily.

User visits website, has to login, and their login username and password are in the 1000 table.

Once logged in, user can specify up to 10 search parameters; all of which are fixed. (Out of these 10, select whatever is relevant. This is not "pick 10 random things you can search by")

Once parameters are keyed in, hit the "search" button and see a roster of results that fit the parameter limits. This search hits the 25000 table, and certain elements in this table lookup returns from the 500 table.

While looking at the roster, user is able to click on one result and see full data for this specific item (aka record).

End of objectives.

What current tools do you recommend that would accomplish this?
I'm thinking I need "something" to hold the data itself; something easily updated by one person. (Today I am using .mdb file)
I also need something to slice the data down to fit the parameters. (Today I am using FrontPage 2000 as an html editor only - I do not "publish to web" but transfer files individually. These pages run VB scripting to retrieve fields out of 25000 table and linked 500 table.)
I also need something to display the results. (Today I also use FP2k for this, with html coding. This page also runs with VB scripting, and includes SQL statement to retrieve appropriate fields).

I guess if I had to mimic all of this, using tool(s) available today - I guess I am asking what tools should I use to do this?

I've read answers over the years that suggest using MySQL (and variants) married with an editor. Problem is, I am very comfy creating/inputting/using info in Access and I would love to continue to do so. If I could "easily export" to another db like MySQL; I've not seen any "easy" way to do this. I know it's a snap to export tables from one Access DB into another DB file; and I do this daily. Last time I looked into this, and it's been awhile, the issue of exporting out of Access into MySQL overwhelmed me.

For my next trick - currently I maintain 25000/1000/500 myself and in the future, if a visitor (or secure visitor) wants to supplement these records themselves (I don't have to touch it, but can monitor closely for quality control as well as specify what data they can put where (thinking combo-box strategies); would these tool recommendations still be the same, or would they change?

I may be in way over my head and I'm gulping some water on this - but I am not quite dead yet. Any insights would be appreciated.
-To be truthful, I start with a 25000 record table of records, but after I pare out what I don't want, it slims down to about 650 records. I actually transfer 650/1000/500 tables in one database to my webhost daily. It's under 6MB.

This post has been edited by TinyGiant2010: Sep 5 2019, 11:32 AM

Self taught newbie just trying to remember that fields are in tables and controls are on forms.
Go to the top of the page
post Nov 10 2019, 12:13 AM

UtterAccess VIP
Posts: 3,053
Joined: 12-April 07
From: Edmonton, Alberta Canada

Ok, I’ll bite on this!

User visits website, has to login, and their login username and password are in the 1000 table.

This is one area where most go wrong! Logons and user authentication is a HUGE topic. Sure, let’s have some logons! While near every web development tool supports some type of security model, this issue is oh so often overlooked, it close to leaving out the fact that all cars with a gas motor need gasoline!

So, while near every web site has some type of system, it is a REALLY huge issue, and one that needs MUCH thought.

For example, when Access web hit the scene, one HUGE issue was the logon system it used. (It required windows domain users). The problem is public facing web sites don’t all work well with this setup. So, if you have internal SharePoint, then great. But for a public facing web site, SharePoint’s authentication model does not have a good system in which users can sign up, logon, reset password etc. So even simple things like what happens if a user forgets their password? If the site is for 10 people, then they can email you. If it is for 10,000 people, then obviosity users need that option to “self-serve” that process.

Or perhaps you adopt Facebook or google logons. So, the kind of security system you use for a web site is kind of like cars and that those gas motors need gasoline. We just “assume” that this part of the choice we make. However, are you going to setup a refinery, and make that gasoline? Now this becomes a very complex topic.

My only point here is that talking about logons for a web site is a big topic. Who and how will we add new users? Who and how will we disable existing users?

If you choose the wrong kind of authentication provider for your web site, then you going to wind up with a system that may not work at all for your needs. The Access web setup is a perfect example of this (The logon system was not appropriate for public facing web sites – only internal company ones).

Now, you can attempt to roll your own logon system. (From that table of 1000 users). My recommend?


Web servers has security systems built in. The internet is a VERY nasty place. So, can you tie your existing table INTO the existing security system? Well, yes, you can in most cases. But that means you are swapping out a TRUCKLOAD of software that designed around an existing security table. And how the security table looks will often be “different” then what you have.

How such sites work is similar to how workgroup security worked for Access. You don’t write a whole bunch of if/then/else code when a web page is loading. What you do is say that all users who are a member of security group “customers” can only view the web page. Now, the page either loads, or does not if the user lacks rights to that page. And if they don’t have rights, then all of the pre-built in systems that DIRECT the users to another page, or tell them they can’t do this does NOT have to written by you!

Now I apologies for already having written too much about security, since like cars, every web site has a security system. But, say you choose a web hosting provider that don’t support the type of security model you need? Well, then you can’t use that web hosting. So, just like SharePoint is rotten at public facing web sites, you need caution in this area.

I sounds oh so simple. User logs in. But really it is a complex issue. Which of these users are allowed to view and user certain web pages? What about web pages before they have logged in?

Ok, so at the end of the day? Yes, you can use that table of 1’000 users. But I would in fact move them into the existing security tables, since THEN the huge amount of features like re-set passwords, logging in, logging out. Session timeouts – all the gazillion features in regards to authenticated users on that web site will NOW run from the existing infrastructure.

The moral of the story here?
Don’t’ take web security and authentication systems for granted. It is a huge subject. Now of course how you refine gasoline is a huge subject, but everyone drives cars with gas, and everyone users web sites with logons!

What current tools do you recommend that would accomplish this?

Well, it really comes down to what skills you have now. If you have Access and VBA skills? Well then hands down would be to use Visual Studio, vb.net + asp.net.

On the other hand, does your web hosting support windows software and asp.net?

So, if you go out and say learn PHP, and MySQL? Well, if you’re current web hosting don’t support that database, and programming language, then that will not work. Remember, web hosting is just a server computer. And any software you choose to write code with MUST be installed and supported on that server.

So, there are Linux servers, Windows servers, IBM WebSphere servers. They all run and have different software. They are NOT compatible with each other.

So, you either:
Look at what tools and systems you current web hosting supports, and then go off and learn those tools. It is of no use for me to suggest to go out and learn product X to develop with to ONLY then find out your web hosting don’t support that programming language or development tools.

Now, perhaps changing web hosting is a possible choice for you. So, now, you would choose a web hosting provider that supports the web programming languages and systems you are familiar with (or want to learn, or have learned).

So choosing web hosting system is really like choosing a laptop. If you choose an Apple mac laptop, then it not going to run Access, is it? Same thing for web systems.

Ok, now that I noted the above?

I would migrate the data to SQL server. Keep the Access front end. I would then setup a server, and run the web hosting from that box. That way, the web site, and your Access program both share the same database at the same time. A solution with searching, user logons etc.? You really want a common database.

If hosting your own internet server is out of the question? I would still consider SQL server for your data. So one setup could be that you purchase lower cost web hosting but still have the SQL server on site. All I am suggesting here that “half baked” solutions in which you attempt to shuffle data between two database systems are REALLY bad, lots of extra work, and they tend to not be extensible over time. Again, avoid solutions in which you have to shuffle data between two database systems if possible.

It really comes down to what tools you want to learn and adopt. They all have considerable learning curves. But, at least with asp.net, you can adopt tools that are “reasonable” familiar with how you work now.

And how complex is the existing application? If it not complex, then why not the whole thing to 100% web move based?

Anyway I have typed on for far too long.

As noted, check out this UA post of mine:

It’s the same one I referenced earlier on in this thread.

I recommend hosting your own web server on site if you have the IT people for this. If not, then consider going 100% web based if your existing desktop application is not rich in features.

And you could consider still hosting free SQL server on your local network, and have the web site pull from that.

Good luck!

Albert D. Kallal (Access MVP 2003-2017)
Edmonton, Alberta Canada
Go to the top of the page

Posts in this topic
- firlandsfarm   Access In A Website   Nov 23 2016, 04:58 AM
- - Marsupilami72   To make it short: It is not possible to use Access...   Nov 23 2016, 05:38 AM
|- - firlandsfarm   Hi Marsupilami and thanks for replying. I have a ...   Nov 23 2016, 06:28 AM
||- - ScottGem   To understand your previous answer you need to und...   Nov 23 2016, 07:26 AM
||- - firlandsfarm   Ahhh, OK, thanks ScottGem I think I get it now ......   Nov 23 2016, 07:47 AM
||- - ScottGem   MySQL is a database engine, PHP is a programming l...   Nov 23 2016, 08:40 AM
||- - GroverParkGeorge   It might help to understand that ALL database appl...   Nov 23 2016, 08:59 AM
|- - TinyGiant2010   Don't despair, I am running a site using Acces...   Mar 1 2019, 11:20 AM
|- - stevep   That's pretty interesting. I haven't heard...   Mar 2 2019, 08:14 AM
|- - sumosoftware   You could also look at other low code options like...   May 14 2019, 06:35 PM
|- - GroverParkGeorge   "I haven't heard of Front Page for years,...   May 14 2019, 07:17 PM
|- - firlandsfarm   Hey, this topic has suddenly sprung back into life...   May 25 2019, 05:54 AM
|- - GroverParkGeorge   First, I am not sure whether you are thinking of u...   May 25 2019, 08:18 AM
|- - firlandsfarm   Thanks again George ... "First, I am not sur...   May 25 2019, 12:12 PM
|- - TinyGiant2010   Deep cleansing breath...... okay here goes. If som...   Sep 5 2019, 11:24 AM
|- - AlbertKallal   Ok, I’ll bite on this! QUOTE User visits webs...   Nov 10 2019, 12:13 AM
- - DanielPineault   As others have said Access is not the right techno...   Nov 23 2016, 10:19 AM
- - Marsupilami72   You can install a complete webserver on your lapto...   Nov 23 2016, 10:37 AM
- - GroverParkGeorge   MS SQL Server Express is the free version of MS SQ...   Nov 23 2016, 10:44 AM
- - firlandsfarm   Thanks everybody ... I know and understand just ab...   Nov 23 2016, 12:31 PM
- - GroverParkGeorge   I have to take exception to your statement: ...   Nov 23 2016, 12:38 PM
- - firlandsfarm   Well to cite two ... Firstly if you want to open ...   Nov 23 2016, 12:51 PM
- - DanielPineault   You can create Web Database using Office365.com (a...   Nov 23 2016, 01:05 PM
|- - firlandsfarm   Thanks Daniel, that's the message I'm gett...   Nov 23 2016, 01:09 PM
|- - DanielPineault   It isn't too hard to put together a Web Databa...   Nov 23 2016, 01:22 PM
- - GroverParkGeorge   Note that neither of those is a promise that you c...   Nov 23 2016, 02:15 PM
- - firlandsfarm   Grover, I don't care how broad the sense, you ...   Nov 23 2016, 05:01 PM
|- - AlbertKallal   I think for someone with VBA and Access experience...   Mar 1 2019, 06:25 PM
- - DanielPineault   Sorry George, there is no disputing that MS seems ...   Nov 23 2016, 07:35 PM

Custom Search

RSSSearch   Top   Lo-Fi    25th May 2020 - 07:12 AM