I want to use VB to add /remove/ display data table records "by hand".
When I type a line like
SET myDbs = CurrentDB
the debugger informs me that CurrentDB is an unknown object.

Thinking that this meant that ADO objects had not been installed on my PC I
downloaded MDAC_TYP.exe from the MSDN site and tried to install it. The
installation aborted after telling me that XP PRO Service Pack 2 already
current in the OS.

I also cannot use the older DAO way of doing things because it has no idea
what a 'Database' type object is.

Thanks in advance

CurrentDb is a DAO-related function, not ADO. Likely you need to set
reference to DAO library in your ACCESS file. Do this by switching to Visual
Basic Editor (Alt-F11), then click Tools | References, and set a reference
to DAO library.

--

Ken Snell
<MS ACCESS MVP>

"Steve Laycock" <slaycock (AT) bigpond (DOT) net.au> wrote

Thanks for that Ken - it's the little things that'll drive you crazy

"Ken Snell" <kthsneisllis9 (AT) ncoomcastt (DOT) renaetl> wrote