Dear friends,
in access 2003 Pass word protected
how to close (all running, or other databases i want ) from another .mdb or
from VB6 file

i am using this code but not working.

DIM dbs as database
dim oacc as new access.application

for each dbs in oacc.dbengine.workspaces(0).databases
dbs.close
next
end sub
this code i used both from with in access and VB6
but not yielding ,
any help please if any damo/ link will help me great

Hi,
try to use this approach:
http://www.mvps.org/access/api/api0025.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"balu" <(E-Mail Removed)> wrote in message
news:3CAD80E7-7384-4623-8B98-(E-Mail Removed)...
> Dear friends,
> in access 2003 Pass word protected
> how to close (all running, or other databases i want ) from another .mdb
> or
> from VB6 file
>
> i am using this code but not working.
>
> DIM dbs as database
> dim oacc as new access.application
>
> for each dbs in oacc.dbengine.workspaces(0).databases
> dbs.close
> next
> end sub
> this code i used both from with in access and VB6
> but not yielding ,
> any help please if any damo/ link will help me great
>