UtterAccess.com
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)    
 
   
firlandsfarm
post Nov 23 2016, 04:58 AM
Post#1



Posts: 414
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
Replies
Marsupilami72
post Nov 23 2016, 05:38 AM
Post#2



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
 
TinyGiant2010
post Mar 1 2019, 11:20 AM
Post#3



Posts: 229
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
 
stevep
post Mar 2 2019, 08:14 AM
Post#4



Posts: 123
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
 
GroverParkGeorge
post May 14 2019, 07:17 PM
Post#5


UA Admin
Posts: 37,513
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
 
firlandsfarm
post May 25 2019, 05:54 AM
Post#6



Posts: 414
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
 

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    14th July 2020 - 05:09 AM