Re: Access db accessibility (permissions??)

"Object variable or with block variable not set" is a simple
programming error. It indicates that the programmer is trying to use an
object variable, but that variable has not been set.

For example:

dim o as object
set o = createobject("access.application")
msgbox o.name

If the createobject did not return a value (for some reason), the next
line would get that error, or something similar. The programmer should
have coded a check along the following lines:

if o is nothing then 'oops, didn't work.

I'm not saying that createobject /can/ return no value, or that your vb
app /would be/ using "access.application" to access the database. That
code is just for the purpose of showing you how the error in question,
occurs.

So, my bet is, that the locked-down environment is causing a
createobject or similar statement to fail, & the vb code does not check
the success of the statement concerned. So the app trundles on, until
it tries to /use/ the unitialized object variable, at which point, the
error occurs.

If you have access to the vb sourcecode, it should be easy to find from
here.

Cheers,
TC

.

Relevant Pages

  • Re: Help for a novice
    ... I have no experience in building COMs add-ins. ... I'm not a programmer and had this landed on me. ... Outlook VBA includes an intrinsic Application object, so you don't need to use CreateObject to create another one. ...
    (microsoft.public.outlook.program_forms)
  • Re: Installing MS Java VM for VS6 Pro destroyed Windows 2000
    ... system or system32 folder during VS6 installation on my W2k+sp4 OS. ... I'm sorry to have to say this, but my feeling is that you shouldn't be a programmer. ... "specific" reasons like stated in MS's article. ... without showing the exact evidences ...
    (microsoft.public.vb.general.discussion)
  • Re: Academic research aimed at improving programmer productivity?
    ... > Nowadays I think I'm at least an average programmer ... > guru-ism, like mastering arcana of computerdom, making themselves ... best you can be and that is all the showing off you need. ...
    (comp.programming)
  • Re: why define this kind of variable?
    ... The use of the underscore more than like means the programmer is showing ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Newbie: Show that function might throw exception
    ... Italo ... > Is there any way of clearly showing to the programmer that an exception ...
    (microsoft.public.dotnet.languages.csharp)
Loading