Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-18-2019, 12:25 PM   #1
lisarmj
Newly Registered User
 
Join Date: Jun 2006
Location: Albany, NY
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
lisarmj is on a distinguished road
Using PHP Powered Website as Front-End?

Hello!

Please be patient as I'm not sure the best way to phrase this question. My client has been using an Access database (split into FE and BE) for several years. The client now wants their own customers to submit data from a PHP powered website directly into the database. The client will be assigned a user name and password and validated upon sign-on.


1 - Can a website be used as a front-end? The dropdown down boxes will still need to be populated from existing tables and the new submission will need to be saved to the database.

2 - The backend is currently housed on the client's in-house server and will remain there.

3 - Can an OBDC connection string be used to link the website and backend together or is there a better method?

4 - Will an Access database be sufficient or does the whole thing need to be updated to SQL Server?

The long-term goal is that each client will have a portal where they can check on their job submissions, status, and run some reports of past jobs.

Any advice you all can offer would be appreciated. I can get back to the web-developers with specific questions.

Thank you!

lisarmj is offline   Reply With Quote
Old 03-18-2019, 03:34 PM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,365
Thanks: 555
Thanked 948 Times in 897 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Using PHP Powered Website as Front-End?

You might find this useful:-

https://docs.microsoft.com/en-us/sql...ql-server-2017

Sent from my SM-G925F using Tapatalk
__________________
Code:
                 |||||
               @(~‘^‘~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
|      
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 03-18-2019, 03:49 PM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,580
Thanks: 58
Thanked 1,443 Times in 1,424 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Using PHP Powered Website as Front-End?

Hi. Once you start talking about web access, you really need to start leaving Access out of it. With a php web server, you’re better off using MySQL or SQL Server as the back end. However, once you have the new back end, you can still continue to use an Access front end. Don’t be confused though, I am talking about having two separate front ends here.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Other users can't access their front end when I am editing a different front end cricketbird General 6 08-14-2013 12:12 PM
Access Front End vs VB.Net front end ions General 2 10-08-2009 05:55 PM
Web front-end Vs Access front-end? VegaLA SQL Server 2 04-28-2008 08:36 AM
Running 97 Back-End with one 97 front end and a 2000 front end Swannie General 1 11-15-2002 07:14 AM




All times are GMT -8. The time now is 08:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World