Hi

Thanks for the reply, that whole post is a little above my head, but I will give it another read to see if I can make sense out of it.

Cheers

Dj

Hi opc.three

Perfect that worked, I just had to modify it slightly to change the 722 to @SearchNo which was a parameter.

Cheers

Douglas Bell

Hi All

Sorry for the late reply, first of me getting a chance to look at this particular database.

PERSONNUM is NVARCHAR(15)

I have taken away the order by clause as to be...

@mark-3

All I can say is AWESOME. Worked the code in with my query and it works without a hitch.

Thankyou

DJ

Hi Laurie

Spent a bit of time on this, this morning. I couldnt figure out why your example worked but my query didnt. Looked through all the data in my tables...

Hi

Both tables are far to large as this is a running system to give a copy, I am just trying to create a query for a report.

Your Select Statement is...

Hi Yvan

Thanks for the info. To be honest I have never used VB.net to write to SQL only Access but its probably only a change of connection strings needed. So...

Hi Yvan / All

Thanks for the replys, I have had a play with SSIS, but having problems, I have created my connections ect but had to install the Access Driver...

Excellent, thanks Anthony. I will dig out the SQL software and have a look.

Hi

Thanks for the replys.

As the application has already been designed from the ground up for use with the Access database I would rather stick with this as the backend database.

I...

Hi Abu

Thanks for the reply, adding timestamps and the such to the tables will not be an issue, and it is only one way synch, Access to SQL as its...

Hi

Thanks for the reply, I have just been reading about SQL 2012 free LocalDB that can be deployed with an application. This looks like a very good database for my...

Hi all

I am till struggling with this one, any ideas on the bet way to handle it?

Cheers

Dj

Hi

Thanks for the replys. At the moment there doesnt seem to be any real performance issues, the reports run quite quickly.

Basically what the SP does is search a table for...