×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Use of Access database on website

Use of Access database on website

Use of Access database on website

(OP)
Hi all,
I'm looking for help with how to make an Access database up and work on a web page which is developed from Front Page HTML.
The access database is simply for input data, search existing and generate reports.
Does it cause me any problem if I just have a link to Access   file?
What if people click on the link at the same time, are they be able to open Access file and input data at once?
Please help.

GelC   

RE: Use of Access database on website

I think you really want to have a form that will input data to the access database, rather than the Access database to be 'downloaded' and then uploaded again.

You might be better looking in a web forum for this to be quite honest.

Fee

The question should be Is it worth trying to do? not Can it be done?

RE: Use of Access database on website

Hello

Using an Access database as the back end to a website is perfectly feasible. However, do consider the following:

1. The MDB format doesn't cope well with lots of concurrent users. Consider SQL Server/MSDE if you're going to be having lots of users or large amounts of data.

2. You say you have a link to download the Access DB and input data - if any authorised user has the rights to upload data to the site in order to let this data persist, this creates a big security issue (especially if you've got sensitive information in there) that needs to be addressed.

By using an HTML and ASP form with the MDB file in a location outside the web root you can still save data to the Access database and report on data from this. It also means that the users don't need MS Access on their PC.

John

RE: Use of Access database on website

(OP)
Thanks for all response.
Those gave me some ideas though

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close