" is not a valid name error

[Montez659]

This is gonna be the life of me, I swear. I keep getting this message whenever I split the db and then compact and repair. I've tried splitting by the wizard, splitting manually, making sure that the relationships were intact on the b/e. I've tried moving everything to a new db, split that with wizard and manually, and yet this stinking error comes about offering me no way to delete ANY of the linked tables.

I am sure that this will cause all kinds of problems in the future too, so I am not content on just leaving it as is.

There are no invalid characters in the table names or fields in the tables. I built this thing from the ground up.

Any suggestions?

EDIT: Ok, yeah, big problems. Hardly any of my queries work now.

 

[Montez659]

Ok, got it. But I ask you one question; What IT department in this modern world would create a folder that has an apostrophe in it?

Apparently, mine.

 

[boblarson]

Well, usually that means that it can't find something. What is your project name? Go to the VBA window and look up in the object browser to see what it shows. Just above the object browser and before the toolbar it says PROJECT - xxxx and your project name. I've seen a badly named project as the source of some of these issues.

EDIT: Never mind, I guess that wasn't it, eh?

 

[Montez659]

Lol, I appreciate your willingness to help anyways Bob. It always tickles me that I will search and search and search for an answer to a problem and then I will find it within 2.3 minutes of posting! Ah, well, such is life!