Search:

Type: Posts; User: schwenzerp; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    356

    Let me start by saying searching for txt is never...

    Let me start by saying searching for txt is never a good idea. If someone accidentally enters two spaces betweem street_number and street name, that data may never be found. Same can be true if...
  2. Replies
    9
    Views
    578

    I am not that familiar with Access, but in the...

    I am not that familiar with Access, but in the real database world, you are usually better of truncating a table that deleting it and starting over, because you do not lose your indexes when you...
  3. Replies
    7
    Views
    1,757

    Please identify the database system you are...

    Please identify the database system you are trying to use, perhaps I can help you, or at least verify that you are setting things up correctly.
    Peter
  4. Replies
    7
    Views
    1,757

    The first thing you must do in designing a...

    The first thing you must do in designing a database is to identify the ENTITIES. You have patients, Dr.'s and appointments to start. Each patient has a one to many relationship with appointments...
  5. Replies
    3
    Views
    493

    Password protect folders

    Thanxx in advance to everyone that views / responds to my post..

    Does anyone know of a good program that will allow me to password protect an entire folder, so that prying eyes can nor open, view,...
  6. Replies
    7
    Views
    1,022

    Once you have the data problem corrected, I...

    Once you have the data problem corrected, I suggest the following:
    Use all 3 fields as a primary key. This will insure uniqueness, and not allow any row to be duplicated. Fields may be duplicated,...
  7. Replies
    7
    Views
    1,022

    ID is NOT A PRIMARY KEY

    An unmatched query does not work well with fields that contain duplicates and are not required. Please post the SQL that is executed, and we may be able to solve your problem with a distinct clause,...
  8. Replies
    7
    Views
    1,022

    Unique Identifier

    The use of a text field for a unique identifier is a very poor choice. There are too many chances of accidently inserting a leading space, control code, etc in the data. I would suggest to first...
Results 1 to 8 of 8