Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    converting access tablenames (2000)

    Hi,
    How does one go about converting tables that have space, too non-spaced ones?. eg tbl sheets to tblsheets. Its just not a simple matter of renaming them and renaming all the queries and vbcode that has them, as I get error messages. I need to do this so I can use asp pages to access the tables.
    Thankyou in advance
    Mark

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: converting access tablenames (2000)

    As far as I know, it IS a simple matter of renaming them and renaming all references in queries and code. "I get error messages" is too vague to provide any direction. If you tell us what problem you're actually having and what error messages you receive, someone can help. There are products like SpeedFerret and Rick Fisher's Find and Replace that can do this for you, but it isn't clear what you are looking for.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: converting access tablenames (2000)

    Thanks Charlotte, I actually figured it out after many hours, the error message was a duplication in the current scope, but it was more like the variable was not dimmed before it was set. Which I dont know how it made a difference, as it worked fine when the 'tbl sheets' stayed as it was. But renaming it and placing the dim before the setting allowed a smooth progress of the dbs functionality.
    I also downloaded speedferret, and I have to admit, its quite a nifty tool. I could see alot of use for it in future. What do you know, one learns something new everyday, except for me, it seems to be at the rate of every hour <img src=/S/newbrain.gif border=0 alt=newbrain width=21 height=22>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: converting access tablenames (2000)

    Do yourself a favor and use Tools-->Options from any code window to turn on the Require variable declaration option. That will automagically insert Option Explicit at the head of each new module you create. Then your code wil always break if you forget to declare a variable before you use it, but it will do so in the compile of the code, not just at runtime.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    May 2003
    Location
    Perth, Western Australia, Australia
    Posts
    150
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: converting access tablenames (2000)

    Yep, thanks Charlotte. It's the simple things I tend to overlook [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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