visit access2asp

Please read below before contacting support!


access2asp


      Make sure you have given read\write access to the db folder within IIS
      or Personal web server ( or ask your isp to do this)
      If you dont have this enabled then you will get errors such as

      error 500 or 'operation must use an updateable query.....'


      You may experience warning's

      warning codes

      wrng:1 - front end wont work administration wont work - asp files not created
      -usual cause no primary key defined in that table.
      solution - make sure you have a primary key - recommended to create a field as an autonumber and use that field as your primary key.

      wrng:2 - front end will work - administration may not work expect java script errors and
      errors on insert and update. - usual cause - badly named fields

      doesnt support OLE Object fields (blob field - commonly used for storing pictures or files)
      doesnt support joined keys
      doesnt work on password protected databases

      javascript validation
      In the administration section you will notice that little red stars denote fields that are required.
      A field is deemed required if it's property is set to 'required' in the database table.
      OR if the property 'allow zero length' is set to NO.

      date validation
      although date fields are detected during the generate asp routine - java script validation of dates is not included. this is due in main to regional variations and differing formats being so wide as it was deemed wisest to allow
      the individual developer to do validation for this.

      numeric values
      these are defaulted to 0 if nothing is added and they are not 'required'
      this prevents an error.


      asp links

      aspmessageboard
      an invaluable resource for solving problems.

      vbscript reference
      whats was that function...?

      allaire homesite
      The best asp\html editor out there - integrates seamlesly with dreamweaver.

      Has an integrated snippets utility for storing useful code and loads of useful plugin functions that you can download from here - (make sure you check out the response.writer, comment and uncommenter and the function browser are 3 plugins that i use a whole lot.)

      click here to email support