Getting error " '' is not a valid name... [Error 3125]

[patjones]

Hi:

I've got a backend database, with several tables linked together via one-to-many relationships, and a front end database that links to those tables.

The problem is, when I attempt to look at the relationships from the front end, I get '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. According to the help window, this is Error 3125.

Any ideas? Thank you ...

Pat

[patjones]

The problem turned out to be an apostrophe in a folder name that is part of the path to the back end file. Kind of dumb of me to use an apostrophe in a folder name I suppose. Be there it is for anyone else having the same issue!

[Scott Price]

LOL, as I've said before, programming gives all of us plenty of opportunities to do dumb things :-) Doesn't mean that we are dumb people!

Thanks for posting back with what the problem was!

Regards,
Scott

[Chicanoy]

hi zepphead80,

Have the same problem. I am using Access 2007 which is link to Access 2003 table. You mention that "The problem turned out to be an apostrophe in a folder name that is part of the path to the back end file".. I know I have to remove the apostrophe BUT HOW?? is it in a code? VBA? or something else? I am just a beginner so please bear with me.. Thanks

[patjones]

Hi Chicanoy -

I just saw your post now and you've probably already solved your problem, but...what I would do is simply change the location of your back end or rename the current location to a name that is more convenient to use (i.e. a name that doesn't have apostrophes!).

Good luck.

Pat

[Spud]

Thanks Pat, just about to give up with the same problem and revert back from Access 2007 to Access 2003, when I found your post. You saved the day!

Regards,