Solved

Using MS Access Data Pages with Joomla

Posted on 2009-07-10
8
2,171 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

747 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

11 Experts available now in Live!

Get 1:1 Help Now