Hello everybody,



I recently made a DTS-package from importing external data in my sql2k
server.
I linked my access file to the sql server to make some reports.

Right now, my clients run the dtsrun utility through a batch file
themselves. I gave them permissions to be the dbase owner.

Now when you link from access to sql server as admin, your names are :
dbo_Tablename.
If it's another user, the names get pvanmoer_Tablename and for another user
it's cvanho_Tablename.
(Validation through NT)
So my linked tablenames aren't valid anymore in my access file. So I need
to relink them each time.

How can I avoid this problem ? I've been trying to create tables without
dbaseowner, but this doesn't seem to work.

Can anyone help me ?

Thanks,


Bjorn