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?
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.