Viewing 15 posts - 76 through 90 (of 144 total)
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...
November 15, 2004 at 7:52 am
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. ...
October 27, 2004 at 6:09 am
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...
October 27, 2004 at 6:06 am
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...
October 27, 2004 at 6:03 am
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...
October 26, 2004 at 8:12 am
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...
October 26, 2004 at 8:02 am
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...
October 21, 2004 at 2:38 pm
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...
October 21, 2004 at 2:10 pm
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...
October 21, 2004 at 1:53 pm
"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...
October 10, 2004 at 2:22 am
Alternate Key means just that, and alternate unique key. Don't use ERWin or other modleing tools do you>
October 8, 2004 at 8:43 am
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...
October 8, 2004 at 8:28 am
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...
October 8, 2004 at 8:24 am
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...
September 13, 2004 at 10:33 am
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...
September 10, 2004 at 9:45 pm
Viewing 15 posts - 76 through 90 (of 144 total)