Strange error whent rying to delete table

[Montez659]

And the keyword is trying, because it won't let me delete the table. The table was named tblAssignTypes, and then renamed to "1" just for kicks, but I keep getting an error that

" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

No matter everything that I have tried, I can't delete it! Any ideas? Thanks!

And if I try to Compact and Repair, this shows up in the MySysCompactError table:

'|' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

with a reference to -1002 for an error code and a location of MSysRelationships which incidentally has nothing in it (that I can see)!

 

[xenou]

Try importing all your database objects into a new Access database, but leaving out this table of course.

You want all tables names to begin with a letter or an underscore, and to have only letters, numbers, and underscores in them (no spaces). Same with your file paths and file names too, if it's not too late.

 

[Montez659]

I apprecaite the info. I will definitely keep that in mind. Interestingly (and maybe because of) this seemed to happen after I split the database. When I went back to work with the original, there wasn't a problem. I did see that my file name (fe and be) had the "&" character in there, so maybe that was throwing it off.

But it was definitely frustrating. Thanks for the help.