Using MS Access Data Pages with Joomla

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.
LVL 6
Lorenda ChristensenAccounting and VBA ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
j-b-tCommented:
Yes perhaps be more specific - what are you exactly trying to do?
0
Lorenda ChristensenAccounting and VBA ConsultantAuthor Commented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

j-b-tCommented:
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
j-b-tCommented:
addendum - you may like to check out thsi database - joomla integration component -
http://www.gmitc.biz/products/lfrm.html
0
Lorenda ChristensenAccounting and VBA ConsultantAuthor Commented:
My forms are to enter new information that will be stored in MS Access tables.
0
j-b-tCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lorenda ChristensenAccounting and VBA ConsultantAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.