Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1256
  • Last Modified:

Access Web front-End

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
idajagne
Asked:
idajagne
  • 2
4 Solutions
 
rockiroadsCommented:
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
 
humbleamateurCommented:
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
 
khufford19Commented:
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
 
rockiroadsCommented:
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now