A 2010 Table name change

[Dick7Access]

Trying to update my huge db. I change the table name from “Churches” to “tblChurches”. I then made a new query based on the new name table, “tblChurches” with the same name as the old query . Not only did the form base on the query not open properly but when I tried to make changes it said I did not have exclusive rights and could not save changes. No other copy of the db was open. When I changed it back to the old table name “Churches” that I saved a copy of, it works fine. Does anybody have any idea what I am doing wrong? Sorry for so many dumb question. I know I am in over my head, but I have a great desire to learn.

 

[Khalid_Afridi]

Hi!
Is your dabase is back-end split database? if so then re-link your tables and try to compact & repair your front end application:

 

[Dick7Access]

Hi thanks for answering. No it is not split.
Dick S.

 

[boblarson]

Dick:

1. If you have a database file and you have anything open that the other object uses (like a table) in design view, and sometimes just open, it will give you that error message.

2. An easier way to rename things is to download and use the free V-Tools and the tool in there called Total Deep Search. An even better one (but costs about $37) is Rick Fisher's Find & Replace. I use that one at work and it is great. In that one you can have it automatically rename but you can have the option to have it pop up a dialog when it finds the name you are wanting renamed and then you can choose whether to let it change it or move on. This can be helpful if you don't want to rename everything named something to something else.

 

[Dick7Access]

Thanks Bob, I will download the tools and take a look at. I have another post under queries that I need to convert a txt field with x's in it to a new yes/no field. Will the free v-tools help there? I have about five more fields that need to be converted I did the first one manually, by putting the txt field side by side with the yes/no toggle and putting a check mark in the toggle everywhere that the was an x. There were over 300 records. That is when I decided to look for a better way
. I

 

[boblarson]

For your checkbox situation you would simply just add the checkbox fields and then run an update query:

UPDATE TableNameHere Set CheckBoxFieldNameHere = True
WHERE theTextFieldName = "x"

but you will need to run that for one of the fields and then change the names of the fields in the query and run it for those names and so on for each as you can't update multiple fields for this at a time since the Where Clause is key on only a single field at a time.

 

[Dick7Access]

Many, many, many thanks Bob. I will pray the tooth fairy will be good to you <G>