• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

MS Access97 front end and MySQL backend

I have an MSAccess97 db (BE and FE).  The BE will converted into a MySQL db.  I want to know how I can keep using my MS Access FE (forms, reports, modules) and my MySQL BE if the database needs to be accessed from the web.
Thanks!
0
qwkslvr1999
Asked:
qwkslvr1999
  • 5
  • 3
1 Solution
 
Arthur_WoodCommented:
as far as I am aware, you SHOULD (operative phrase) be able to LINK to tables in a MySQL database.  In that case, then everything should be fine.  As long as you have the appropriate ODBC driver to allow you to create a dsn to point to your MySQL database, then you should be in business.

AW
0
 
qwkslvr1999Author Commented:
Does that mean I can save my access forms as .asp and then upload them to a website?
0
 
Arthur_WoodCommented:
no...you CANNOT save Access forms as ASP...when you EXPORT as HTML from Access, what you get is an HTML TABLE, showing ALL of the Records (with All of the fields in each record) as a Table.  Not a REAL ASP page.

Real ASP pages have JavaScript (or possibly VBScript, if you are ABSOLUTELY 100% CERTAIN that the Client Browser will ONLY EVER POSSIBLY be IE, as VBScript WILL NOT execute under ANY OTHER browser) code that runs on the Client browser, as well as VBScript the runs on the Server.

Access forms CANNOT be converted into ASP pages.  The ASP pages MUST be re-engineered, from scratch.

If you need to get to the Database from a Web site, then you will be re-writing the ENTIRE front-end functionality.  Web-based applications have an almost 100% DIFFERENT interaction model than does a typical Windows/Forms-based application.

AW
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
qwkslvr1999Author Commented:
Does that mean I can save my access forms as .asp and then upload them to a website?
0
 
qwkslvr1999Author Commented:
Will asp work well with with MySQL?

Now, I am just thinking that maybe, I can just create forms so that web users can query the database and locally, still use the existing access FE to update the database and then export the data to MySQL.

How feasible is that?

Thanks!

0
 
qwkslvr1999Author Commented:
I meant, I will create web forms (in asp)...  

Thanks again!
0
 
qwkslvr1999Author Commented:
I meant, I will create web forms (in asp)...  

Thanks again!
0
 
Arthur_WoodCommented:
as long as you can use ADO with MySQL, and I am reasonably sure that that should not be an issue, then ASP pages (which inherently use ADO as the Data Access technology) should interact with MySQL with no problems.

The latter option - using the WEB as a Viewer to the data, which is updated form the Server side, is probaly a MUCH better first step.

AW
0
 
Tom KnowltonWeb developerCommented:
qwkslvr1999,
No comment has been added lately (220 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to Arthur_Wood http:#7994962

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

knowlton
EE Cleanup Volunteer
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now