invalid table name when importing excel into access project

[mike]

i have a stored procedure that imports an excel spreadsheet using
docmd.transferspreadsheet into an access project table named test.
the access project is connected to a sql database.

when i run the stored procedure everything works fine.

when another user runs the stored procedure it runs but it does not append
the spreadsheet to the table. the stored procedure creates another table and
names it test (domain\username) and then appends the spreadsheet to that
table.

i tried to do the import menu option manually as the user, not as myself,
and when i select the table test it gives an error dbo.test name is invalid.

within sql server the table test owner is dbo. i have given the person full
rights to the table and owner rights to the database but that does not help.

i've deleted the table and recreated it but that has not helped either

thanks