Trying to use a backup

Hello, I`m trying to use a backup I did a while ago, but are getting an error message when trying to store it on the server.
The file is stored locally at my computer, in this way, 2009-08-23-18-16-13.bck.dbk.
I can view what is inside this file, and if I drag and drop it to the server, I chose table name, and copy data and "allow bulk copy"
Then the process starts, but then I get an error message after a second or two, saiyng cannot access the table and error inserting into table, and the process fails.
Does this have anything to do with permission? A bit strange because the table is created, but it fails before anything is stored in the database.
The server I am copying it to should be sql2000.