Solved

Access Web front-End

Posted on 2009-04-06
5
1,200 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
  • 2
5 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 250 total points
Comment Utility
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 125 total points
Comment Utility
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 125 total points
Comment Utility
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 250 total points
Comment Utility
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

IT, Stop Being Called Into Every Meeting

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!

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

744 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

15 Experts available now in Live!

Get 1:1 Help Now