GSquared -

thanks very much for the code and explaination. I'm out sick today so was kindo slow responding, but I wanted you to know that I really...

GSquared -

yes, I'd already set up target tables to use more effecient types/sizes:

CREATE TABLE [dbo].[Vehicle_Info](

[Counter] [int] not null

,[Year] [nvarchar](5) null

,[Make] [nvarchar](20) null

,[License_State] [nvarchar](15) null

,[VIN] [nvarchar](20) null

,[Comments] [nvarchar](max) null

,[License_Plate] [nvarchar](30)...

excellent. Thanks Ron.

I had looked at information_schema.TABLES, but missed the Information_Schema.Columns.

here's how I'm going to use it:

Select TABLE_NAME

, COLUMN_NAME

, DATA_TYPE

, CHARACTER_MAXIMUM_LENGTH

, IS_NULLABLE

From Information_Schema.Columns

...

just as an aside, I would use combo boxes on your search form. Populate them with a sql query that pulls values that are in your DB and limit them...

by golly, that seems to have worked. I thought the go would force the drop to complete before moving on.

THANKS!

I've found that when I use a remote desktop connection to the server xp_cmdshell runs fine. When I use QA from my own workstation it doesn't. All other queries...

I think he probably gave up because you still haven't filled the request for easily consumable create table statements and test data. When I looked at the file you...

thanks again. The quoted identifiers setting sounds very likely to be the culprit.

Obviously, I'm a fairly new reluctant DBA that's just transfered from applications.

'preciate all help.

ahhhh, thanks for that. I just tested single quotes and that also works. I'd already changed the sp (all 3157 lines of the beast) to use nulls.

...so... I'm...

never mind. That wasn't the offending line, it was the two prior:

Make ="",

Model ="",

didn't like empty string. Used 'null' instead and it works.

Thanks

that was my first thought.... didn't work, same errors

I work for a State Police agency. I have access to their training academy gym and flexible schedule so that I can take a 1.5-2hr lunch to workout. I've...

Since MS Access doesn't support views, it lets you call queries from queries. It's not uncommon to have query1 do some joins and manipulation, then use that result set...

On small scale, I've used something similar to dschubel, but I also used a bit field and bitmasks for access control. Makes a clean select case that doesn't have...

I guess my first big ah-HA! moment was learning hot key functions - not leaving the keyboard seemed SO convenient vs. grabbing for the mouse.

Now... the roofer in the graphic...