Results 1 to 2 of 2

Thread: Help!! :-)

  1. Mar 22nd, 2000, 08:47 PM #1
    netSurfer
    netSurfer is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 1999
    Location
    Calgary Alberta
    Posts
    359
    I'm trying to create a table for Access 97 (using dao 3.51) via code. I'm setting the table info in a string and then
    using dbsData.execute string to make it. The problem I'm having is that using this method, I'm not able to use "-" in the field names and I have to. Any ideas? Do I have to put " around the field names or something like that? I hope someone can help.
    Reply With Quote Reply With Quote
  2. Mar 22nd, 2000, 09:37 PM #2
    netSurfer
    netSurfer is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 1999
    Location
    Calgary Alberta
    Posts
    359
    Never mind. Using the Creat Table wouldn't allow me to use - in the field name but if I use createtabledef and fields.append with .createfield it will. It does't make sense to me. But it works.
    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