By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

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

patjones
Expert 100+
P: 931
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
Feb 19 '08 #1

✓ answered by 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!

Share this Question
Share on Google+
5 Replies


patjones
Expert 100+
P: 931
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!
Feb 19 '08 #2

Scott Price
Expert 100+
P: 1,384
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
Feb 20 '08 #3

P: 1
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
Oct 8 '09 #4

patjones
Expert 100+
P: 931
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
Oct 26 '09 #5

P: 1
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,
Feb 25 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.