Hi all,

I understand that ADO was officially introduced with A2K but you can still use ADO with 97, although it ist supported much.

Well, the problem is, as highlighted by member dcx693 also, that currentproject is not supported in 97.

How do i go about making a connection to the 'currentproject' that im in, without using the currentproject object?

Thanks...

Why would you ever want to use ADO to access Jet tables in an A97 db? Why wouldn't you just use DAO? Even with A2003, DAO is more efficient with Jet tables than ADO.

True, but you didnt answer my question Pat.

Yours is not to reason why...

Can you tell me if there is an alternative in DAO to creating the user roster (ADO) that is suggested in the Microsoft Security FAQ?

Also, I had another issue recently where i wanted to query directly some CSV files, again, with the use of ADO and micrsofts text drivers.

So... with respect, as I know you are a wealth of knowledge Pat, should we not just provide people with the answer to the question they ask? Rather than ear bash them of the inefficiencies of the method they are employing.

Cheers anyway...

DAO and ADO have similar but not identical capabilities. The fact that it is possible to use ADO in A97 at all is something of a miracle and just shows how well thought out Access really is. I haven't seen the code and you didn't post it or a link so I don't know what to tell you. If you can't convert it to DAO, you probably can't do it. Make sure all your ADO and DAO objects are properly disambiguated.

CurrentProject is an Access object which doesn't exist in A97 so there is no way to use it.

Make a program in C... call that. Problem solved :p

hey modest... what r u talking about?