Just to complete this. The cause of this problem was SP3 for Office 2003. Access.adp bit fields no longer work with SQL Server.

Paul

Dear Both

Thanks for your replies here - and really apologise for not replying directly. I had to make a quick work-around and run. I've only just had the...

Hi Russell

I started this thread and became a big supporter of Access.adp. The ability to deal natively with SQL tables is fantastic. Access started as a little desktop...

Thanks, Jason, I much appreciate your reply.

It's good to hear that you aren't experiencing too many problems.  However, to add something extra into the mix, the word on the Internet...

Thanks, Otto

I appreciate the openquery tip and will bear that well in mind.

As I say the script

Update LS..DB.OracleTable

Set fieldname = 'TT'

where id = '12345'

works on...

Hi PorkNBeans

Thanks for the link.  I've read it through and it still seems that linked server is the best way to go.  It's a shame it's so slow.

Thanks again

Paul

Thanks, Camilo

Sorry for the late reply - I've been on vacation.

Yes, I now realise that I do use it with the indicated schema as you suggest.  However, for some unremembered...

Thanks for your help, Ben.

However, I'm not sure where to run this from.  I don't have access to whatever the Oracle version of QA is.

Also, I tried again what Camilo...

Hi

Thanks for helping.  I really don't know anything much about Oracle, and generally only take data from it.  However, for convenience, we would like to do very limited updates.

How...

Hi Camilo

It certainly tried to do something...

However, it returned the error message:

Server: Msg 7317, Level 16, State 1, Line 1

OLE DB provider 'MSDAORA' returned an invalid schema definition.

OLE DB error...

Thanks, Perry

I agree, the mdb does provide more useful ways of resolving problems.

As I've run out of ideas, I'm importing from an earlier version where this facility worked.  There seems...

Hi Perry and thanks for the reply.

Yes, it is linked to a ID number on the main form.

Paul

Thanks, Arthi

I had to do a lot of unnesessary work to achieve this originally.  When I have to do it again, I'll give your indicated method a try.

Very many thanks...

Hi Perry

Thanks for your reply.

I am using sps with parameters.  I was looking to quickly add filter for a certain purpose.  However, you've set me off on a further line...

Hi Perry

It doesn't get to the Access db (if that is what you mean).  I change the macro security for Access to low by editing the Registry on the fly...