Lettronics Support

The place for free support for our software and systems.
Welcome to Lettronics Support Sign in | Join | Help
in Search

Error Code -2147217900 (80040e14) v3.5.0 install

Last post 11-23-2007, 8:41 AM by Lettronics. 12 replies.
Sort Posts: Previous Next
  •  11-20-2007, 8:25 PM 489

    Error Code -2147217900 (80040e14) v3.5.0 install

    when Itry to install v3.5.0 it wants to update db to v9 I say okay and get thie folling error message

    Run Time Error '-2147217900 (80040e14)'

    Syntax error in CREATE TABLE statement

    this is using a fresh download of stock.mdb from website

    please help!!

     

  •  11-20-2007, 8:30 PM 490 in reply to 489

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    You got the latest MDAC, plus Jet 4 SP8 installed (downloadable from MS)?
    Get free EPoS software at http://www.lettronics.com
  •  11-22-2007, 10:40 AM 491 in reply to 490

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    I too have this problem, am running Vista with all the latest updates and latest version of Msjet40.dll and MDAC according to microsoft, I am also running on this Pc Access 2003 SP3.

     

    Thanks

  •  11-22-2007, 12:59 PM 492 in reply to 491

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Is it a fresh install of SCM, or an upgrade from earlier version?
    Get free EPoS software at http://www.lettronics.com
  •  11-22-2007, 2:07 PM 493 in reply to 492

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    I have tried it as an upgrade on this PC and as a fresh install on a PC running XP with access 2000 again with the up to date files.

    I get the same error on both PC's

  •  11-22-2007, 2:13 PM 494 in reply to 489

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    OK, I'll try to see if I get the same error.
    Get free EPoS software at http://www.lettronics.com
  •  11-22-2007, 3:01 PM 495 in reply to 494

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Try Beta 3 Wink
    Get free EPoS software at http://www.lettronics.com
  •  11-22-2007, 3:52 PM 496 in reply to 495

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Now get the following error if upgrading current database

     Error Code -2147217900 (80040e14)

     Table 'Repairs' already exists.

     However if I do a fresh install it works, I will try to import the data across

    Very pleased with the current version, have been testing it for a few weeks and will go live tomorrow, have created an additional database which links to the stock database and this produces custom reports from the data collected.

    Now want to explore the additional features of the test version.

     We find you till perfect for our business, simple to use and set up, and we can get useful data from it in the running of our volunteer ran museum

    Regards

    Mark

    RAF Millom Aviation & Military Museum - www.raf-millom.co.uk

  •  11-22-2007, 4:02 PM 497 in reply to 496

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Just tried it again on a copy of my current database as I thought there was an earlier error, which was, only happens once then you get the table error as above.

     Error Code -21472179887 (80040e21)

     scaling of decimal value resulted in data truncation

     Importing the data is messy, so a straight upgrade would be best.

  •  11-22-2007, 4:03 PM 498 in reply to 496

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Glad you're now working OK.

    V3.5.0 is still beta, but it sounds like you understand the risks that entails, and understand about keeping good backups, and how to retrieve data from the database should something unexpected happen Yes


    Get free EPoS software at http://www.lettronics.com
  •  11-22-2007, 4:04 PM 499 in reply to 497

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    If I send you an email address, can you zip up the mdb and send to me, along with your Licence details?
    Get free EPoS software at http://www.lettronics.com
  •  11-22-2007, 4:20 PM 500 in reply to 499

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Will do
  •  11-23-2007, 8:41 AM 505 in reply to 500

    Re: Error Code -2147217900 (80040e14) v3.5.0 install

    Try Beta 4.  Test thoroughly, as its currently had about 30mins of testing!
    Get free EPoS software at http://www.lettronics.com
View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems