Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Using MS Access Data Pages with Joomla

Posted on 2009-07-10
8
Medium Priority
?
2,283 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
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.

 
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 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

705 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