473,322 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

FILENAME field locked in Access 2007

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
3 1477
NeoPa
32,556 Expert Mod 16PB
What is a "filename" in relation to your question?
Dec 13 '07 #2
timark
2
so sorry...it should read FIELD NAME
Dec 13 '07 #3
NeoPa
32,556 Expert Mod 16PB
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

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

Similar topics

2
by: Brainwave Surfer | last post by:
Am trying to grey out a field in a form depending on if there's a date in it or not, using access 2000, and i've tried vbscript and macros... I've read and tried and reread for a week... I'll be...
3
by: jen | last post by:
Hello, I'm trying to lock two fields on a form, but only for data editing/deletion. I want the user to be able to enter data, but once it's saved, it needs to be locked. Any help would be...
5
by: tsnyder | last post by:
I need to have an option button that allows editing to a field only when it is checked.
2
by: Miguel | last post by:
I have a problem in appending notes from a new notes memo field to one that is read-only, i.e., field enabled, but locked. I have seen many messages touching on this subject but cannot find the...
11
bhcob1
by: bhcob1 | last post by:
Hi, Whenever I delete a record my command button, the record deletes, a list displaying all records is updated and then a message box appears: Microsoft Access can't find the field 'I' referred to...
7
by: Ganesh | last post by:
Hi, I would like to know if there is any way I can forcefully delete a file locked by another process on Windows as well as on Linux. On windows DeleteFile returns me error code 32 (Process...
15
by: chaseexchange | last post by:
First, a brief explanation of why this has happened. I purchased, what I thought, was a fully functional program written in Access last year from a local programmer. This program was to be used as...
1
by: tricard | last post by:
Good afternoon all, I have recently been trying my hand out at the ADO model as before I have only used DAO (just thought I would expand my knowledge a bit). The problem I am having is that...
1
WyvsEyeView
by: WyvsEyeView | last post by:
I have a dataset subform on which I want to lock a field for just two specific records. Each record has a type_id and a desc field. I want to test the value of the type_id field for the current...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.