Please read below before contacting support!

access2asp

tutorials/articles
getting started tutorial
asp image library tutorial
asp.net tutorial
 WYSIWYG editor

     

    access2asp requirements

    ms access 2000 or above

    MDAC 2.5 or higher - download the latest Microsoft data access components from

    http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp



    You *must* have read and write access privelages set up on your database or your db folder.
    Do this from within iis or personal web server or ask your isp to setup these privileges on the db folder.

    If you dont have these permissions set up then

      You may get errors such as
      Internal error 500

      or

      Operation must use an updateable query.

      make sure you ask your isp to set up these permissions!

      read the following to set them up locally

      settingPermissions.htm

      you can read the threads below for more information on how to fix the error ' operation must use an updateable query '

      Thread: Operation must use an updateable query
      Thread: Operation must use an updateable query. How to fix

      Field names
      If you are experiencing problems on UPDATE OR INSERT statements please make sure you have not named any of your fields as a reserved word. Typical examples are naming a field 'date' or 'time' - these are reserved words in sql and will cause errors in insert and update statements.
      For a full list of reserved sql keyword's in access 2000 click here


      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.

      server problems
      if you are receiving error such as 'cannot find server' then you will probably be having personal web server ort iis problems.

      Make sure IIS is installed by going to control panel(win2000\xp pro) and looking at add\remove programs\windows components.

      You might find this article useful for configuring iis.

      Have XP home edition and want to install IIS - You could read this?

      You could read this article on setting up personal web server.

      Make sure pws\iis is running and make sure you access your pages via a browser by http://localhost/yourDB/
      and *not* by double clicking on the file. or using file-open to go to say contactlist.asp.

      asp files must be run through http\\localhost (this means they are processed with pws or iis rather than just the browser which is what is hapenning of you just double click.


      asp links

      aspmessageboard
      an invaluable resource for solving problems.

      vbscript reference
      whats was that function...?


      find interdev to clunky? checkout allaire homesite ( macromedia )
      The best asp\html editor out there - integrates seamlesly with dreamweaver.
      Has an integrated snippets utility (excellent!) 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\uncommenter and the function browser these are 3 plugins that i use a whole lot.)
      still stuck?
      click here to email support


email access2asp