Solved

Using MS Access Data Pages with Joomla

Posted on 2009-07-10
8
2,176 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
  • 4
  • 3
8 Comments
 
LVL 84
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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

861 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now