close all access application

B

balu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Message from Access 2007 on sub function 3
Opencurrentdatabase (without open a new database) 0
Late binding Access from Excel 5
Do until Loop question 3
run-time error '3121' no current record 2
QueryDefs - DAO vs ADO 4
Password not being saved when I create a link to a SQL table 5
Setting the Startup Options for an Access 2007 database using VBA 13

Top