Re: Cannot create table in eVB - "cannot open the device or file specified"

From: Earl (brikshoe)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 18:42:14 -0500

You did add the Microsoft CE ADO Control 3.0 to your References I hope? And
then actually install the package so that the registry knows where things
are?

"Paul Perkins" <paul.perkins@nospam.logicacmg.com> wrote in message
news:1074074597.548266@ernani.logica.co.uk...
> Hello all,
>
> This is really driving me mad.
>
> I've got a eVB app that needs to create tables in the object store. My
> code runs fine under the emulator, but on the device it fails with the
> error message
>
> The system cannot open the device or file specified.
>
> The code is:
>
> Set rsRecordset = CreateObject("ADOCE.Recordset.3.0")
>
> rsRecordset.Open strTableDef, , , 1
>
> Set rsRecordset = Nothing
>
>
> The actual code is a little more sophisticated, but this is the essence
> of it. Using the Open without the Options parameter set yields that same
> results.
>
> The tables that I'm trying to create have existed previously and have
> been deleted programmatically. Could it be that msystables and its
> friends have got into a state?
>
> As an aside, I've also tried using the Execute method of the Connection
> object, but this always fails with an 'object expected' error.
>
> Please help!
>
> Paul.
>

Relevant Pages

  • Re: Calling .Net dll from Fox
    ... I have a class "ImageProcessing.captcha" it works correctly on the development box but fails on the target machine. ... Error message "OLE error code 0x80070002: The system cannot find the file specified" ... VFP doesn't know where the assembly registry is so you have to make a local copy of the dll available to your VFP program. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Decimal fieldss precision is too small to accept the numeric you attempted to add
    ... I don't know the Scale and Precision of your Decimal fields, ... case something is actually overflowing (as the error message suggests). ... both of those, still fails. ...
    (microsoft.public.access.queries)
  • Re: Unparsable Record
    ... I tried simply importing 1 column - deleting all the rest. ... Method 'ExecuteTempImexSpec' of object '_WizHook' failed error message. ... If that fails, delete 11 more columns so only the first 11 ... importing the first column - skipping all the other columns, ...
    (microsoft.public.access.externaldata)
  • Re: Closing Form Produces "Runtime Error 2585"
    ... My main concern is that you should NEVER store an easily calculatable entity ... calculated field to give you the Full Name from its component parts as and ... > I'm getting the above referenced error (error message: ... DoCmd, it still fails. ...
    (microsoft.public.access.formscoding)
  • Re: Permanently Disabling Content Advisor
    ... If that fails, post the exact error message to a newsgroup about IE. ...
    (microsoft.public.security)