Results 1 to 8 of 8

Thread: Couple of questions

  1. Dec 1st, 2001, 08:07 AM #1
    mbaker33
    mbaker33 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Northern Maine
    Posts
    281

    Couple of questions

    I have a couple of problems that I can't seem to get through and I need some help.

    The first question is a simple one. Can you have multiple users in an Access 2000 MDB file?? I have a program with about 8 users (all adding and deleting records at will) and I want to make sure it is going to allow that.

    The second question is, I have a list box and I am using a text box to search the contents of the list box. As I type in the TextBox it compares the text to that of the ListBox. However, this is where my problem arises. I have approximatly 200 items in the listbox and if you don't know the exact name you can't find it. Is there any way to use a wild card to search through the listbox?? I think I would need to use the Like function in VB but I'm not sure how to use that. If anyone could help it would be appreciated.

    Any questions please ask.
    Reply With Quote Reply With Quote
  2. Dec 1st, 2001, 09:18 AM #2
    mbaker33
    mbaker33 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Northern Maine
    Posts
    281
    Help????
    Reply With Quote Reply With Quote
  3. Dec 1st, 2001, 09:26 AM #3
    AIS_DK
    Guest
    Question 1:
    Yes, it's possible, but not easy. I would recommend, that you buy a book on creating databases for Enterprise use, since the deal with the issues surronding this area.

    Question 2:
    You will need to create your own way here, but I would go for a method based on, that when the used presses ENTER, and the wildcard is pressent, you go thorugh each element in the list, and see if whatever the user typed is part of any of the elements by using then "INSTR" function.
    Reply With Quote Reply With Quote
  4. Dec 1st, 2001, 09:42 AM #4
    mbaker33
    mbaker33 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Northern Maine
    Posts
    281
    As far as the database is concerned, would it be easier to use the new Microsoft Database (I believe MSDE or something like that)??
    Reply With Quote Reply With Quote
  6. Dec 1st, 2001, 09:45 AM #5
    AIS_DK
    Guest
    The problems about multiusers enviroments, has nothing to do with the database, it's purely in your program, and the way it handles the data, that the problem arises.
    Reply With Quote Reply With Quote
  7. Dec 1st, 2001, 09:51 AM #6
    mbaker33
    mbaker33 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Northern Maine
    Posts
    281
    I see, would you happen to have any advice on where to start with a solution??
    Reply With Quote Reply With Quote
  8. Dec 1st, 2001, 09:54 AM #7
    AIS_DK
    Guest
    I'm not an Enterprise Database developer, I just know of the problems, not the solutions.

    I would recommend, that you got a book like:

    Professional VB6 Database Programming, published by WROX Press.
    Reply With Quote Reply With Quote
  9. Dec 1st, 2001, 10:00 AM #8
    mbaker33
    mbaker33 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    Northern Maine
    Posts
    281
    Cool....thanks alot for you help...I'll look into that book.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width