How to create multiuser data entry application in VB6 and MS Access?

Posted on 2005-04-10
Last Modified: 2008-03-10
How to create multiuser data entry application in VB6 and MS Access?

I want to create a mutiuser data entry application and my databse (of ms access) will be stored on a remote machine.

1. How to connect to that machine and hence databse(dynamically)?

2. How to create users and give them rights.(i.e. full access/readonly etc.)

3. Backing up database and avoiding corruption

Please provide links to tutorials/codesamplea/working projext example or internet resources.

Question by:omyurs
    LVL 2

    Accepted Solution

    I use oracle, so I have very little info on the use of access, but I can help with some of the rest.

    2: creating users and providing access is pretty basic stuff. I will assume you have the knowledge to create the forms for creating new users and changing rights, so I will skip that part here. As for the permissions, build a database table with the following fields:

    I would name the permissions something you will remember rather than the "permission1" used in the example.
    When you have the user login, check the un/pw against the database and place the permissions into global variables.

    When you come to a section that you want only certain people to be able to see/do, perform an if statement against the global variables created earlier and control usage that way.

    3: to back up an access database, simply make a copy of the mdb file, run access' backup, or schedule a backup using a 3rd party software.

    I hope this helps, I am not sure of your skill level, but if you need more help, just ask.

    Author Comment

    Respected ASTROHELP,

    First of all, thanks for taking your valueable time to answer my question.

    Well I can use oracle9ibut even dont know a,b,c, of oracle9i. If you can tell/help me in oracle9i then its also fine.
    My main requirements will be the same.
    In oracle9i
    1. How to create database/tables and hence user permissions.
    2. How to make connections.
    3. Is window domain is nesessary.
    these are some additional questions.

    sorry...actually i am not a programmer.

    Please tell me where can i get all these stuff/tutorials

    My email

    looking for ur next post...............
    LVL 2

    Expert Comment

    if you are not a programmer, I would recommend starting with an easier project than this. Most of what you are trying to do is not overly complex, but there are other issues you may run into that you will be better off if you get some practice in.
    LVL 2

    Expert Comment

    I dont really have any web based examples, I could write a small example program for you, but that is going to take some time as I am pretty busy. If you would like I will do this for you though. Let me know if you still need help.

    Author Comment

    Respected astrohelp,

    Thanx very much for your kind attention.
    If you please write one small example then it would be very helpful to me.
     Please look again to my question(part 1) beacause, i want to link database on remote machine on my LAN network.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    728 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

    18 Experts available now in Live!

    Get 1:1 Help Now