Hi Travis, this must be turning into a real pain in the you-know-what Just had a quick read through your code and...

If you perform a truncate on the temporary table every week before you perform the import (assuming that you do not wish to keep a history of what has been...

One way of approaching this is to import the files into a new intermediate table (which has no constraints) and to use standard SQL on this table to perform validation...

As far as I can see, you have solved your own problem:

SELECT

d.company, d.address1, d.address2, d.city_id, d.state_id, d.country_id, d.zip, dr.directory_roletype_id, x.eng_itemdesc

FROM

T_MTSTM_DIRECTORY d INNER JOIN

T_MTSTM_DIRECTORY_ROLE dr ON...

Never seen the error.

Maybe it's worth reinstalling the client tools on your PC and see whether that resolves it.

Does this happen for all databases, or just specific ones?

Do other users experience the same error?

Regards

Phil

Thanks Kemp ... yet another requirement that I didn't quite understand

Here's another version of your query that does not require wildcards:

SELECT * FROM...

Hi Jim

As far as I know, there is no 'date last updated' property for a database, so there is no straightforward solution to your question.

The following thread may be of...

If you are inserting a date into a table, why are you not using a datetime field to store it?

If you want to select just the date part of getdate(),...

Try this:

SELECT * FROM dbo.AGSVC_Idx_Res

WHERE neighborhood = 'MM_neighborhood' AND city = 'MM_city' AND PRICE BETWEEN 'MM_price_start' AND 'MM_price_finish' AND BEDROOMS >= 'MM_bed_start' AND (HIGH_SCHOOL LIKE 'MM_school' or...

You should get a performance improvement if you take the dynamic getdate() out of the queries ...

declare @now datetime

set @now = getdate()

INSERT INTO monitordata

SELECT * FROM data (NOLOCK) WHERE DATEDIFF(hh,time_stamp,@now)...

Agree with this. Alternatively, you could create a 'Payment Number' field (1, 2, ...) in both tables and then match on Voucher Number and Payment Number to perform the...

Sounds like you are performing integer division (the result of dividing one integer by another is an integer - so if the real result is < 1, the result you...

Hmmmm ... maybe you should accelerate your migration to SQL Server and all of your problems (well, this one anyway) will go away

I'd...

Aha. No, views do not exist in Access - the closest equivalent is a straightforward query.

You will notice in Access when you are building a query (using the 'create...