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
Solved

Access Web front-End

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

860 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