Results 1 to 2 of 2

Thread: Please Help??

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 2000
    Location
    Melbourne
    Posts
    2

    Can I use Visual basic and create a single table and then a form which will allow me to search the table and then displays the results to the screen.

    The application needs to be used by 20 users. Microsoft Access doesn't supportmulti-user environments of this size. Can VB support this environment? If yes then what version of VB?

    I was thinking of placing the VB application onto a server that all the users can then access to search for customers. So once the file is on the server the VB application will automatically pick up the file and load it into a table. Users can then search this table for customers using a form where they can enter the customer's name. I would have one exe file created using VB. This application would allow the above.

    Is this possible?

    Thanks

  2. #2
    Guest

    Angry Your problem is going to be MS record locking

    MS use a thing called page lock, which locks a group of records rather than a single record.

    We can get up to thirty users running on an access database through a vb front end.

    Use vb5 or vb6 and late bind the records to achieve this, i.e don't use the database object, programmatically connect and manipulate records.

Posting Permissions

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



Click Here to Expand Forum to Full Width