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

 

[Norie]

Pedie

You can just close a recordset like this:

rst.Close

and a connection like this:

conn.Close

You should do this as soon as you've finished with the recordset/connection.

 

[pedie]

Norie, thanks for quick reply.
I do that...I mean like the way you said.
I also include error trap in every code. But sometime when error happens it happends to lock my Main database and wont let me add any new records to it. Why does this happen?

 

[Norie]

Pedie

Because you are using error traps, or more likely because you haven't quite set them up properly.

 

[pedie]

Pedie

Because you are using error traps, or more likely because you haven't quite set them up properly.

Yep...maybe somewhere...
In a laymans term, pls let me know the Recordset types and cursor types; Do i always needs to specify the type of cursor? Recordset types?

what will happen if i use something like this;

[/FONT]
[LEFT][FONT=Courier New]rst.CursorLocation = adUseClient
rst.CursorType = adOpenStatic
rst.LockType = adLockBatchOptimistic[/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]or [/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]CursorType:=adOpenKeyset
CursorType:=adOpenStatic[/FONT]
[FONT=Courier New]etc[/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]

Does this lock the recordset/table till the current user is completely done with the adding/deleting/editing etc?
Does this

Thanks again in advance.[/LEFT]

 

[Norie]

Pedie

Not sure what this has to do with closing recordsets and connections.

 

[pedie]

Pedie

Not sure what this has to do with closing recordsets and connections.

Like i said earlier Norie,

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.

I thought maybe if i use the right type if cursor/recordset it won't prevent others from accessing the recordset and performing activity on it..[I could be wrong .... just a thought.].
Beside that I also want to know what Cursors mean in access....


Thanks again.

 

[Norie]

Pedie

I can't really help with cursors, especially since I've no idea whether it's ADO or DAO you are using, or what you are trying to do.

One thing you really need to consider is not using code, then you wouldn't need to worry about this sort of thing.

 

[pedie]

Thanks again Norie though...
In my future projects, 'll try to minimize the use of codes.

Pedie

 

[Norie]

Pedie

Why not try it with the current project?