Kill Datase Error

[Sorrells]

Gentlefolk,

I have created a temporary database to do some work in for a form. When the form closes I receiving a Runtime Error 75: File/Path Access Error.

The form opens and works fine but when I close it, I cannot Kill the datbase!

I've been over the code many times and cannot figure out what is causing the error. The filepath is fine, I think access is the problem. Like I have some object open that is stopping the command from being executed. In the OnClose I am performing the following:
1) Removing the temp db's tables from listbox RowSources
2) Closing the recordsets to the temp db
3) Closing the temp db
4) Refreshing current db's tabledefs
5) Setting temp db recordsets to nothing
6) Setting the temp db to nothing
7) deleting links to temp db in current db
and finally failing at Killing the temp db

This is driving me crazy. Does anyone have any thoughts to share?

 

[WayneRyan]

Sorrels,

Any spaces in your path name?

Wayne

 

[Sorrells]

Hi Wayne,

No, There are no spaces. Here is what it looks like in debug:

C:\ACCESS97\HOME_MGT\DEVELO~1\HMS97_Rev11temp.mdb

The very good man I got the code from has a demo database that I attached. His temp table in debug looks like this:

C:\ACCESS97\TECHTO~1\TempTables temp.mdb

an yet the code executes without a flaw. I emailed him a few days ago but he has not replied.

See what you think.

 

[WayneRyan]

Sorrells,

I download and ran the s/w with no problem.

Your path:

C:\ACCESS97\HOME_MGT\DEVELO~1\HMS97_Rev11temp.mdb

has the MS-DOS tilda in it. I don't know if
the Kill statement handles that properly.

Also there should be a space before the
"temp.mdb" in your filespec.

Will research further.

Wayne

 

[Sorrells]

Wayne,

I agree about the tilde, I didn't like it either but note that it is in the demo mdb and works fine there.

When I first ran across the error, I had the space before the temp but thought that was what was killing me so I took it out.

It is actually just the way he concatenated the filename string.

I am running 8 temporary tables to his one but I have gone over and over the steps he took and believe I faithfully replicated them. There is an enormous amount of code created.

I am progressing forward with the form by commenting out the Kill statement. Tomorrow, with a day away from it, I will review all my steps with his to find what I must be missing.

The error 75 is "File/Path Access not Filepath. I wish Microsoft had been a little more expressive. I've spent a few hours searching forums and newsgroups for this error and only found one thread remotely like this situation. I think however, that the emphasis is on access - like something is keeping the temp db open so that it cannot be accessed to delete it. The path is OK but it is like it is still actively linked in some way to the current dB that I have either overlooked or that I have code for that is not giving an error but also not doing its job.

I'll reply to this thread sometime tomorrow after a fresh review.

Thanks for your help, Sorrells

 

[WayneRyan]

Sorrells,

I don't remember seeing the tilde in the demo.

Why not try "hard-wiring" the full filespec and then see what
it does?

I still don't like the current spec with the tilde.

Wayne

 

[Sorrells]

Wayne,

Although I have not gone through the logic again, I did check out the tilde. I made the path "C:\HMS_temp.mdb and followed the variable through to the kill statement. The string was OK, nothing wrong with the path or filename but still the same 75 error.

It has to be something with either the way I ordered the actions on the objects or a statement I missed. I am facing a Dec. 10th deadline for some sort of deliverable so most likely will not get back to this till the 11th or 12th.

I appreciate the interaction. One main problem with home development is the lack of peer review. Your comments are most helpful as they provide that outside perspective that includes aspects that one to close to a project can tend to repeatedly overlook!