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

x
?
Solved

Access Web front-End

Posted on 2009-04-06
5
Medium Priority
?
1,252 Views
Last Modified: 2012-05-06
Dear Experts,

I just completed building an Access DB for Asset Tracking. However, I am looking for a solution that would provide with a front-end.

The backend will be Access and any web front-end will do as long as I can have multiple users logon and write data at the same time.

Any recommendation&.
0
Comment
Question by:idajagne
[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
  • 2
5 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 1000 total points
ID: 24081521
try using asp or asp.net. easy enough to use but you would need to learn vbscripting (similar to vba) or vb.net or c#

look in w3schools for more info about using this
0
 

Assisted Solution

by:humbleamateur
humbleamateur earned 500 total points
ID: 24082001
Does Access work as a back-end for a web application?  I thought Access would be particularly slow, because it would bring all the data down to the user's desktop when processing data.  For that reason, I thought one had to use a server db like SQL Server?
0
 

Assisted Solution

by:khufford19
khufford19 earned 500 total points
ID: 24083104
PREFACE: Please forgive me if I get too granular and simplistic here.  I can tend to get a little long-winded.  :-P

While MS Access will work for a Web site's backend, it's certainly not the ideal.  It will work in basically the same way as any server DB.  However, because Access *isn't* a true server DB, you'll likely run into some issues with record locking, database corruption, etc. if it's going to be used heavily.  You might consider looking at migrating the database to something like MySQL, PostGreSQL or MS SQL, depending on the amount of usage the database will see.

All that being said, putting together a Web interface for MS Access is just like putting together a Web interface for any relational database.  You'll need some understanding of HTML/XHTML to put the actual Web page together.  Also, as rockiroads stated, you'll need an understanding of some sort of scripting language (ASP, ASP.NET, PHP, etc.) to establish a connection to the database and retrieve/store the data contained in there.  Additionally, you'll need to have a Web server running somewhere to actually host the data and Web pages.

If all you want is a "front-end", and not necessarily a Web interface, you might consider using the tools inside of Access to create forms, reports, etc. to build the front end and have the users operate from the database file itself.  There are a number of wizards and other tools there that might give you what you're looking for.

I guess it all comes down to what "exactly" you want.  If you want an application that will help you in creating the HTML and database connections necessary to create a Web interface, Adobe Dreamweaver, Microsoft Expression Web and other WYSIWYG editors may be beneficial, but you'll still really want to have at least a basic understanding of the underlying code.  If you just want to throw together an interface for your users, and security isn't a serious concern, you might be better off just playing with the Access forms and macros.  Unfortunately there's no quick, one-shot-and-you're-done answer (at least none that I've seen).
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 1000 total points
ID: 24084295
Access has been used on the web before but agree with khufford that it is far from ideal.

I have not had much success using Access in a multi user environment but others (those asking questions here) have. Just ensure you have split the database if you intend to do so. If your users are all on the same network, it would be better to do this split. Backend on the network (data only) and supply each user a Access frontend (contains your forms etc but no data, as it is linked to the backend)

Within Access you can create data access pages. But they are difficult to maintain outside Access. I don't really rate them. This is why I suggested using ASP or ASP.Net. Also because ASP is from Microsoft so using ado is pretty easy to use. For ASP, the vbscripting would be similar to your vba code, different for asp.net of course.

0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

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.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

670 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