ADO database closure

[mhardine]

I have this routine that I've adapted which inserts data from an access database into a table within the drawing. My problem is that although the routine seems to be closing the connection to the database, if I try to access the database either again using the same routine or via any other method I get a "File Already In Use" error until I close AutoCAD and restart it.
Anyone have a clue what I've got jacked up here?
(file attached)
Thanks in advance

[Anonymous]

Sorry, wrong group. Please try the Customization
group.

Joe ...

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

<zale-86> wrote in message
href="news:6140585@discussion.autodesk.com">news:6140585@discussion.autodesk.com...

I
have this routine that I've adapted which inserts data from an access database
into a table within the drawing. My problem is that although the routine seems
to be closing the connection to the database, if I try to access the database
either again using the same routine or via any other method I get a "File
Already In Use" error until I close AutoCAD and restart it. Anyone have a clue
what I've got jacked up here? (file attached) Thanks in advance