Solved

Using MS Access Data Pages with Joomla

Posted on 2009-07-10
8
2,249 Views
Last Modified: 2013-11-29
I'm very new to the Joomla world, but I have a DB that I would like to try and link to my website using Joomla. Could someone tell me whether this is possible, and point me to some instructions? I would definitely appreciate it. Thanks.
0
Comment
Question by:lorenda
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 85
ID: 24827770
Define what you mean by "link to my website" ... do you mean you want to show Access forms and reports on your site? If so then you can't do this regardless of the WIKI software you use.
0
 
LVL 11

Expert Comment

by:j-b-t
ID: 24828145
Yes perhaps be more specific - what are you exactly trying to do?
0
 
LVL 6

Author Comment

by:lorenda
ID: 24830990
I would like to load my data access pages - from MS Access - and have them show up as pages - I guess as articles in Joomla. Before using Joomla, this was easy, just upload the htm file and use it, but I'm not sure how to find my htm file in Joomla. Can I import it from joomla's ftp? Where can I manage it?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 11

Expert Comment

by:j-b-t
ID: 24831069
Hmm - is this a changing data base?

If not _ I think you best try to import it to a mysql database - if these are simply pages already in html = you may be able to  import them into the jos_content page of joomla

Unless you are tryin to upload forms to search and enter..?

Access itself is a different database to joomla - which is mysql
0
 
LVL 11

Expert Comment

by:j-b-t
ID: 24831100
addendum - you may like to check out thsi database - joomla integration component -
http://www.gmitc.biz/products/lfrm.html
0
 
LVL 6

Author Comment

by:lorenda
ID: 24862166
My forms are to enter new information that will be stored in MS Access tables.
0
 
LVL 11

Accepted Solution

by:
j-b-t earned 500 total points
ID: 24866028
I think your best bet would be to have a look and if need be post a question at the "Can LFRM do ..." forum -http://www.gmitc.biz/support.html?board=14.0

Alternatively if there are not too many such pages you could create them statically and use the joomla wrapper function to wrap them within the page.

But , you can embed forms directly into Joomla articles - just do so with the editor turned off in global configuration - as the editor may strip dome form data - but I am just not sure how you are going to get the form data to connect to the access data base directly - but if you have done this before on a static htm page I would think should be able to do this in a Joomla article also.

I do worry about security in this case - not my area of expertise - and depends I guess where your access db physically is and how well protected it is..
0
 
LVL 6

Author Closing Comment

by:lorenda
ID: 31604196
I appreciate the time you spent on this - Desktop applications are the only thing I am used to - so anytime I am doing anything Web - I'm lost. I will definitely take a look at the websites you mentioned. Thanks.
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question