VBA to close all Connections/Recordset opened.

[pedie]

Hi, is there a way for a VBA to close all connections/Recordset opened.
I am wanting this because i do not want any user to lock the database maybe/due to any error etc. and prevent other users from access the main database.


Thanks in advance.
Pedie

 

[pedie]

Pedie

Why not try it with the current project?

It is employee feedback tool where all the manager gives feedback for thier team members and document/feedback/eascalate issues etc....where one leaders should not see other leaders data information..... lots more...

 

[Norie]

Pedie

So you can't try it without code?

 

[pedie]

Pedie

So you can't try it without code?

I think no, Norie. Because to the front end i retrive the data only req. data as per current user requirements etc. and if want to work with linking tables to maindb, it is not possible to hide/prevent users from linking to the frontend table....etc etc...