Results 1 to 1 of 1

Thread: Access Table Column naming problems.

  1. Apr 25th, 2005, 06:09 AM #1
    taxes
    taxes is offline

    Thread Starter
    PowerPoster
    Join Date
    Dec 2003
    Location
    Bristol, England (but heart is in Virginia)
    Posts
    2,949

    Access Table Column naming problems.

    Hi,

    I have just struggled with an Access updating problem which gave me the error "Syntax error in Insert Command"

    The cause turned out to be that some characters which are permitted by Access in the naming of table columns are NOT permitted when using VB.NET. I don't know how many characters fall into this category but my problem was caused by the use of "(". I had a column named "RAM(Gb)" and I had to change it to "RAM".

    Also the use of "-" is NOT permitted but the use of "_" is.
    Last edited by taxes; Apr 26th, 2005 at 09:15 AM.
    Taxes
    The more I learn about VB.NET the more I like dBaseIII Plus

    The foregoing, whilst believed to be correct, is given without guarantee as to it's accuracy and entirely without recourse. You are required to decide for yourself whether or not it is suitable for your purposes and no liability for loss of any nature can be entertained.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width