Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This weekend i started on a new asp classic project and managed to get a connect and read from Access 2007. however, on attempting INSERT INTO, the system gives me a syntax error on the SQL. I copy the SQL from the asp page and open Access 2007 and do a query with the SQL, works fine...

    so, is there something i need to do specifically with respect to Access 2007 to get around this? I did save as... to 2003. one thing i noticed, and this is why i'm thinking it's Access, is 2007 auto-blocks objects on open unless I specifically tell it not to do that (if that makes sense).

    Access file permissions currently sent to EVERYONE -- all settings available. development machine is Vista/latest SP and IIS 7.0. this will be deployed out to the webserver which is likely not to be Vista

    TIA!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    What format is your 2007 database, ACCDB or MDB?
    Also, have you set the trust settings and the Macro Security? That is probably what is going on with the "auto block."
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •