[ILUG] yet another sql (access) question
B.Skelton at emuse.ie
Mon Jul 16 10:53:51 IST 2001
>> I have a table. It has a number of fields. One if these fields is
>> called 'ProjectName'. It is a String. Another one is called
>> 'Date'. It is a Date. What I want to do is to not allow duplicate
>> entries in the table for these two fields. An example to clarify:
>> I am using access. Is there a way of doing this without actually
>> looking for a previous entry with the same project name and date
>> before adding a new entry to the table?
>Oh, come *on*. This has nothing whatsoever to do with Linux. It's an
>operation on a toy "database" frontend on a system which is not only
>incompatible with Linux, it's diametrically opposed in philosophy.
>This is not a homework support group, it's a *Linux* *Users* *Group*.
>Yes, the topics of conversation tend to wander all over the place,
>into areas not directly connected with Linux, but this is ridiculous.
(putting my oar in)
I agree with the sentiment Colm, but would like to mellow the righteous
indignation by mentioning that Access (& most MS databases) can converse
with/be ported to LINUX via odbc. & Access, though a toy database, can be
useful for quick experiments / for generating test data. OTOH, pgaccess
(access like front end for postgreSQL) may develop over time to be just as
An interesting anecdote that may be of use to some of you: In the past I
have misused the MS SQL Server 'Data Transformation Services' to quickly
transfer Access / SQL Server Databases to PostgreSQL. Guess the same could
to transfer to MySQL - just need a MySQL windows ODBC driver.
More information about the ILUG