Forum Replies Created

Viewing 15 posts - 76 through 90 (of 144 total)

  • RE: For ERWIN gurus

    You can only use complete compare if you have access to the source databases.  The "Quote Names" option will take care of most of the problems that you was running...

  • RE: Training software ?

    It is called MSDE and it is included free with Office 2000 and higher.  You can use the 120 day eval to install the client tools to use with it. ...

  • RE: Change MSAccess Background

    Since an Access program should NEVER have end users using the database window, this would, if it could be done, be a BAD idea.  Having said that, the answer is...

  • RE: Historical data in datawarehouse

    What you have, from the description, is what is called a slowly changing dimension.  In other words, the information can change, but not all that often.

    You have to make a...

  • RE: .DAT and .NDX files

    DAT was never used for Clipper or dBase.  DBF was the data file extension.

    If it is Btrieve, then you will need the file you mentioned or you will never be...

  • RE: Difference between varchar, varchar2, char datatypes

    Char is fixed length.  If you put ANIMAL in a char(15) field, 9 spaces will be appended onto the end of ANIMAL.

    Varchar is variable length.  In the same example, only...

  • RE: Dynamic Query HELP!

    There is a UDF posted on this site that will do what you want to WITHOUT creating a table for the data.  You will have to search for it because...

  • RE: New View not available

    Well, you should not be creating VIEWS.  You should be using a stored procedure and passing the parameters into it for execution.

    Also, either you are missing some of the SQL...

  • RE: REMOVE 0 from begining of column - MS access

    Since this is MS Access, you need to do the following:

    Create a query for the table with the field with 000000035 in it.

    Create a User Defined field:   NewKey: CLng([OldKey])  This...

  • RE: PRimary key & Performance dilemma!!

    "only 1 customer is not allowed to have the same two modelnames, but multiple customers can have the same modelname"

    Based on your statement earlier, it is a many to many.

    Based...

  • RE: PRimary key & Performance dilemma!!

    Alternate Key means just that, and alternate unique key.  Don't use ERWin or other modleing tools do you> 

  • RE: PRimary key & Performance dilemma!!

    Oh, one more thing, I would structure the intersection table like this

     

    tblCustomerModel

    CustomerModelID  (PK)

    ModelID  (index, AK1)

    CustomerID (index, AK1)

    PK - Primary Key

    AK9 - Alternate key + the number of the index

    I am...

  • RE: PRimary key & Performance dilemma!!

    The three table solution is the correct one.  To keep the data integrity, you simply create a unique index on the combination of customer id and model id.

     

    And, it is...

  • RE: IDENTITY Field Problems!

    I am not at work this week so I can look at our model on this, but I think the correct model for it would be:

    tblParty

    PartyID Identity, PK

    PartyTypeCode char(1), FK

    tlkpPartyType

    PartyTypeCode...

  • RE: Need suggestions on database design

    The design I gave was the correct one.  For the employees that are gone, you will have to keep them for a minimum of 7 to 12 years any way...

Viewing 15 posts - 76 through 90 (of 144 total)