Results 1 to 4 of 4
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Converting Ms Access To PHP/SQL Server

    Well 18 months ago I started using MS Access for the first time. and with a lot of hard work and an immense amount of help from everyone here I built a decent database for the non profit I help run.
    but unfortunately it has outgrown Access, or more accurately, should never have been built in Access (no local, or central server, and heavy on MAC users)

    so I now need to start the process of turning this thing into a web type application and from the very little I know, I think that I understand the way to do that is through PHP.


    but I am again starting at ground zero, and hoping someone might give me a good jumping off point, and maybe even a general path to follow. I have zero experience with HTML or PHP (but I understand the different concepts of the two) and have never actually learned an entire programing language. just snippets of different things, mostly vba, enough to get some things done.

    i would like to know How much HTML I will need to learn, and should I conquer HTML before even looking at PHP?
    or do I learn PHP first and then add HTML on top. or do they need to be leaned in tandem.

    what is a good starting point for PHP for a complete beginner, recommended books, websites, tutorials.

    I am just trying to find a way to get my first foothold.

    any advise or pointers would be greatly appreciated.

    and a sincere thank you to all the wonderful people here who take the time to help.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    With zero knowledge of PHP, I would start with youtube tutorials. I have found that a good resource to get started with almost any issue. From data analysis to repairing microwave and removing console from a 2005 Pontiac.....

    Try youtube "intro to php programming" as a base and go from there.

    You are in an interesting position. You know the business and processes/workflows etc. You built a database to support same. You have designed/built the logic involved.
    Good luck.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    it will be a long journey but good luck.

    You may already have considered the following, if so, then please ignore

    Have you considered using terminal server or citrix? access apps will run on any device that supports remote desktop (which includes macs) - the app you use to connect to the server. Can also be run from anywhere that has an internet connection. And performance wise pretty much the same as having the back end on your local drive. Moving access to TS should be as simply as copying to the server and relinking front ends to back end

    It comes at a cost of course but probably not much different for 10-12 users than web hosting and all the paraphernalia required to run a web hosted back end (a rough guess on my part)

    The other thing to look at is online database application generators. Suggest review those as well. A couple of links

    https://www.lifewire.com/best-free-o...eators-3486264

    https://comparecamp.com/microsoft-access-alternatives/

  4. #4
    dblife's Avatar
    dblife is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    South Shields, UK
    Posts
    95
    Speaking as someone who went from Access to PHP/MySQL and HTML, it is a hard journey but interesting and very fulfilling. You have done the hard part by getting your head around databases and how data is send, retrieved and manipulated. That is the hard part and as long as you have the time and enough enthusiasm, it will come to you like it did with me.
    I say, go for it and start with HTML.
    Flirt with CSS, enough to keep your styles central and not having to update every page you create.
    Find out how to integrate PHP with HTML and this will naturally lead to db management.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 12
    Last Post: 01-19-2020, 04:34 PM
  2. Replies: 5
    Last Post: 06-12-2014, 11:51 AM
  3. Converting from Access db to SQL Server
    By Hardhat4u in forum Programming
    Replies: 9
    Last Post: 12-26-2013, 11:01 AM
  4. Replies: 3
    Last Post: 07-13-2013, 01:36 PM
  5. Replies: 3
    Last Post: 05-23-2010, 05:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums