Creating a broken reference

[dandoescode]

I'm trying to test the functionality of some code I wrote to check for broken reference code and fix it as required. How do I create a broken reference, simply deleting the file doesn't seem to be possible; I have to close access to delete the file and upon opening access the installer fixes it..

[help_me_with_access]

why can't you just raise an error on purpose to do this? if you don't know how the windows file system operates and interacts with access, just produce the error on purpose.

[dandoescode]

I don't understand what you mean create an error.. I think that's what I'm trying to do, how do I do it?

[help_me_with_access]

I don't understand what you mean create an error.. I think that's what I'm trying to do, how do I do it?

the ERR object in vb has a .raise method.

so to raise and error, type ERR.RAISE(args). or you could probably just assign the appropriate err num directly to err.number and run the code through an err handler...??