Maybe a stupid question, but right now I have no idea how to solve this.
Whenever a user creates a table in SQL server 2000 the [domain\username] is added to the tablename. Don't know for sure how it works, but other user see it.
Does the tablename really have to be 'prefix' with the [domain\username].
Different users need to be able to create the same table from time to time. We have a few queries that use tablenames. But whenever the table's created by a different user, the query doesn't work.
Is there a way to make query work without the need to change them.
Maybe I should add a little to my question. Tables are created by importing them from an Access table or somtimes a DBF-table.
All this is done in Access by using the menu options.
I don't know how to change the username or write it different.