Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2008
    Posts
    117

    Unanswered: Designing Fields in Ms-Access

    Hi,
    I need the fields to be desingned in ms-access as per following request.
    CreateUser Table
    UserID (Primary Key, AutoNumber)
    UserName (Text)
    more fields to be added....

    Login Table
    LoginID
    more fields to be added....

    Profile Table
    ProfileID (i will add more fields here)
    more fields to be added....


    When i add some username in createuser table, UserID will be automatically generated and a new record is created.
    So after once the record is created in createuser, i want LoginID(Login table) and ProfileID(Profile table) fields to be updated with the same UserID from tbl_createuser with the remaining fields set to be null in login table and profile table.
    How to design this fields in Ms-Access 2003?

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    I suggest you to make a MainForm on CreateUser table, and Subform1 on Login table, and Subform2 on Profile table. In Login table and Profile table add a field UserID1 and UserID2, (number, long) as foreign key, and link them on UserID (primary key in CreateUser table). Subform1 and Subform2 put in MainForm, and link them via UserID -> UserID1, and UserID -> UserID2 (via "Link Child Fields", and "Link Master Fields properties). You don't need tu save a record in Login table and in Profile table, in the same time when yu write a record in CreateUser.

  3. #3
    Join Date
    Nov 2008
    Posts
    117
    I created a new table from Create->Table and named it as CreateUser and set the UserID field to Autonumber. Then after that how to proceed. I am new to Ms-Access. Can u pls explain in detail? I am using Ms-Access 2007

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Wait a little, I'll make a Demo.

  5. #5
    Join Date
    Nov 2008
    Posts
    117
    ok thankyou

  6. #6
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Here it is. Look at "DemoCreatUserA2000.mdb" (attachment, zip).
    Open MainForm and try.
    Look at Relationships, Tables, Forms.
    Attached Files Attached Files

  7. #7
    Join Date
    Nov 2008
    Posts
    117
    Quote Originally Posted by MStef-ZG View Post
    Here it is. Look at "DemoCreatUserA2000.mdb" (attachment, zip).
    Open MainForm and try.
    Look at Relationships, Tables, Forms.
    Ya thankyou, this is what i need...

  8. #8
    Join Date
    Nov 2008
    Posts
    117
    Quote Originally Posted by MStef-ZG View Post
    Here it is. Look at "DemoCreatUserA2000.mdb" (attachment, zip).
    Open MainForm and try.
    Look at Relationships, Tables, Forms.
    Hi,
    Please have a look at the attachment. I dont know what error i had done. I dont want the form design, i simply want the database design. I will add datas through asp.net

    db_smscoding.zip

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    DANGER WILL ROBINSON!


    What can I say to discourage you from using Access as a web-facing database? Would it be sufficient for me to mention there are well documented issues with scalability, stability, auditing and in some cases security when using Access on the web?

    I would strongly recommend looking at MSSQL (express even) or MySQL if you're gong to be hitting this with ASP.NET.

    While you're at it, you may want to look in to the Membership, Role and Profile providers. You can setup a full authentication/authorization/profile database for free using aspnet_regsql against an MSSQL database, then hit the database with the baked-in providers with no coding required.
    Last edited by Teddy; 12-17-09 at 18:32. Reason: Needs more doom.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •