>> 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.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!