Please Help Acc97 Database has Got the Better of me

[David Holmes]

I have been developing a commercial Access Application for some four years
now, the mde file is over 30Mb without data, I have recently been approached
to make some additions, but due to my poor attempts at DB design in the
beginning this is proving to drive me crazy.

I have used a lot of vb to open/read/append tables and am concerned that I
may not of Closed all the dB's is there a way at runtime I can tell which
tables are still open ?

Thanks in advance, to anyone willing to help.

Regards

Dave

[PC Datasheet]

David,

Tables are never opened as such; you merely extract data from them in different
ways. However, database objects can be left open after executing a procedure.
Look at each procedure in your database. If you followed standard practice, all
your Dim statements should be at the beginning of the procedure. If you dimmed
an object you probably created it with a Set statement. When you find a
procedure where an object has been dimmed, look at the end of the procedure to
see if it has been set to Nothing. If it hasn't been set to Nothing, it's open.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"David Holmes" <Dh*****@aol.com> wrote in message
news:cc**********@sparta.btinternet.com...

I have been developing a commercial Access Application for some four years
now, the mde file is over 30Mb without data, I have recently been approached
to make some additions, but due to my poor attempts at DB design in the
beginning this is proving to drive me crazy.

I have used a lot of vb to open/read/append tables and am concerned that I
may not of Closed all the dB's is there a way at runtime I can tell which
tables are still open ?

Thanks in advance, to anyone willing to help.

Regards

Dave

[Jack MacDonald]

Nothing automatic that I am aware of. I had the same situation arise
(smaller scale, tho... FE is about 11 MB). I methodically searched
every module for an instance of Dim .... AS Database, and manually
looked for a corresponding ... Nothing statement.

I suggest you also look for closing and ... Nothing for any Recordset
objects.

Not much help, but eliminating the unclosed objects does improve the
application's stability.
On Wed, 7 Jul 2004 23:35:33 +0000 (UTC), "David Holmes"
<Dh*****@aol.com> wrote:

I have been developing a commercial Access Application for some four years
now, the mde file is over 30Mb without data, I have recently been approached
to make some additions, but due to my poor attempts at DB design in the
beginning this is proving to drive me crazy.

I have used a lot of vb to open/read/append tables and am concerned that I
may not of Closed all the dB's is there a way at runtime I can tell which
tables are still open ?

Thanks in advance, to anyone willing to help.

Regards

Dave

**********************
ja**************@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

[david epsom dot com dot au]

You can iterate through the open workspaces (you probably
only have one open workspace) and databases (you probably
only have one open database) and open recordsets (you probably
haven't got any open: they go out of scope and close
automatically)

application.DBEngine.workspaces(i).Databases(j).Re cordsets(k)

using Count and i,j,k or using For Each

(david)
"David Holmes" <Dh*****@aol.com> wrote in message
news:cc**********@sparta.btinternet.com...

I have been developing a commercial Access Application for some four years
now, the mde file is over 30Mb without data, I have recently been approached to make some additions, but due to my poor attempts at DB design in the
beginning this is proving to drive me crazy.

I have used a lot of vb to open/read/append tables and am concerned that I
may not of Closed all the dB's is there a way at runtime I can tell which
tables are still open ?

Thanks in advance, to anyone willing to help.

Regards

Dave