Solved

Access Web front-End

Posted on 2009-04-06
5
1,210 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
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 125 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 125 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 250 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

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

867 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

21 Experts available now in Live!

Get 1:1 Help Now