Creating a table in another database using VBA code

[klnlsu]

I am trying to create a table in another database in another directory using VBA code. The problem is both the database and the directory it is in have spaces in the names (U:\Material Control\Misc Tables.mdb). I have tried using single quotes and I have tried using brackets around that full location and name, and I receive syntax errors. What is the correct syntax please?

Follow up question...I have linked this table in this other database in my local database. This table is recreated every time we run this process. When the table is deleted and recreated, will my link be lost?



Thanks in advance!

[June7]

Try it and find out. My test shows the link is restored. However, better process would be to just delete records and then insert new set.

[klnlsu]

Good idea. I will do that. Thanks!