Preventing duplicates prior to insert

I would like to prevent duplicate entries from being inserted to a table (MS Access). Is there a way to do this without querying the database and comparing the "pre-inserted data" with data currently in the table? Any leads in the right direction is most appreciated. -- Lisa

What am I doing wrong?

I am trying to insert data into a table and get the following errors. I provided the semicolon, yet I still get the errors. What am I doing wrong? TIA, Lisa ODBC Error Code 37000 (Syntax error or access violation) [ODBC Mircosoft Access Driver] Missing semicolon (;) at end of SQL

Re: What am I doing wrong?-solved

Bearer wrote: You don't want to use a where clause in an insert statement, if you are updating data, you want to use a update statement. -Jeff Lisa Greenberg wrote: I am trying to insert data into a table and get the following errors. I provided the semicolon, yet I still get

cflocation and fusebox methodology

I'm trying to use cflocation with the fusebox methodology and need a little guidance on the syntax. Can someone please provide me with a simple example? TIA, Lisa -- Archives: http://www.eGroups.com/list/cf-talk To

Re: cflocation and fusebox methodology-ignore (solved)

--2CB85D7A9F478E630939F985 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I figured it out. -Never Mind Lisa Greenberg wrote: I'm trying to use cflocation with the fusebox methodology and need a little guidance on the syntax. Can someone please

[Fwd: [CFUGTALK] Increasing Speed {01}]

: (private information removed) Message-ID: [EMAIL PROTECTED] Date: Mon, 05 Jun 2000 11:32:04 -0700 From: Lisa Greenberg [EMAIL PROTECTED] Organization: Agouron Pharmaceuticals X-Mailer: Mozilla 4.61 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: "CFUGTALK List Member" [EMAIL

Re: SCALABILITY -- So. Cal. Users Group -- Tuesday 6/6/2000 7pm

--DE97268356699096C28C8D56 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm very interested in this presentation. However, I have a previous commitment with the San Diego American Statistical Association. I'm working on removing myself from this

Fusebox Methodology and #s?

I'm studying the Fusebox methodology and am a bit confuse as to why the # signs are necessary. In the example provide at fusebox.org, for example, where the DSN is set in the app_globals, I get a diagnostic error stating the odbc source can't be located. If I follow the example: cfquery

Verity Wizard Error

I am trying to use the Verity Wizard and keep getting the following error "Error reading txtSummary.Lines.Strings: RichEdit line insertion error." How do I resolve this error? - Lisa -- Archives:

Re: CF tags for SAS

--F87DB1634D05711533B0B307 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am very interested in this topic! Randy Hogg wrote: Does anyone know of any custom tags to work with SAS datasets, call SAS routines realtime, or any other interaction? Many

Advice on Setup

The CF application I've developed employs a session variable to distinguish one user from another by storing a unique value for each users in a table called "Users". Every query within the application filters on this value for each unique user. I'd need to set up one "global user account" that