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

FILENAME field locked in Access 2007

P: 2
Hi All

I have an interesting problem that has just arrived. I have an MS Access database created in 95 format which until now would load up with Access 2007 and allow me to change the table and/or filenames. Today I load it up, go to DESIGN VIEW and the fieldnames are LOCKED and consequently i cannot change a filename, add a filename or change its general settings. I would appreciate any help or advice on this one. The database is not read only.

thanks in anticipation.
Dec 12 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,661
What is a "filename" in relation to your question?
Dec 13 '07 #2

P: 2
so sorry...it should read FIELD NAME
Dec 13 '07 #3

NeoPa
Expert Mod 15k+
P: 31,661
If it's a general problem being unable to make changes in Design-mode, this can sometimes come about when another process has the file locked, or it can happen when you're using an old database from a newer version of Access.
When you first open up a database from an earlier version it will always warn you that there are things you cannot do unless and until you upgrade the database.

With the number of issues still prevalent in Access 2007 I would make sure to keep a copy of the original if you do decide to upgrade your database.
Dec 13 '07 #4

Post your reply

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