Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    145

    Unanswered: programatically creating tables on server

    Search isn't working so I can't look for this topic. Anyway I am new to the multiuser aspect of Access. It is what I have to use so please no criticism. My question is: I use VBA to create tables dynamically, but they are created on whatever machine runs the code. What I want is to create the tables on the server machine only no matter what workstation runs the code. Is this possible?
    Thanks, GG

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You would need to provide more information on the environment you're currently running.

    You obviously have some sort of client/server relationship going on here, exactly how have you set it up?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jan 2004
    Posts
    145
    All machines are running MS Access 2003 on XP Pro. So far I just split the DB. The regular tables reside on the server, but the dynamic ones are created on the local machine with the code I'm using now.

Posting Permissions

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