×
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

Multiple User Database Application
2

Multiple User Database Application

Multiple User Database Application

(OP)
This is just a general question with regards to design. I want to create a program that has a VB front-end and an Access back-end. The program will reside on multiple computers but connect to the same database on a network drive. There will be more than one user using the program at a time. Is this possible?

RE: Multiple User Database Application

It is possible but it has some limitations, do not try to connect too much users at a time. Access is a Desk-top system which will work fine for one user. Consider moving to SQL-Server or other RDBMS

Regards

S. van Els
SAvanEls@cq-link.sr

RE: Multiple User Database Application

I would like to disagree with the above post.  I've created several multi-user database solutions with Access.  The general rule of thumb is that if you have more than 20 concurrent users and the database is updated often, seriously consider using SQL Server as your backend database.  With 20 or less users, Access seems to work fine if your application is programmed properly.

RE: Multiple User Database Application

With 20 users or less on a small office lan, not in an industrial environment, with heavy network traffic, real time processing, internet connections, real database servers, and bussiness applications.

S. van Els
SAvanEls@cq-link.sr

RE: Multiple User Database Application

(OP)
I had thought about using another RDBMS but the person that I am making this database for does not want to purchase one. Therefore I am stuck using access. There are only 6 users and the network does not have very much traffic at all. Thanks for the help, I will try to do this with Access.

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