Changing a Field Name in a Table

[colemanj4]

Hello,

I have a [Sold?] field in a table that I need changed to [Sold] due to
some barcode scanning software that will be using the ODBC link to
this database that does not like to work with '?' in the field name,
that my lovely predecessor left there for me.

This field is used in a great many of the queries, reports and forms
that we have here for this database. So, I was wondering if there is a
way to change that field name and have all the places that it shows up
change as well so that I don't have to spend a week going through the
Database by hand.

Thank you,

--Jason Coleman

[tina]

one product that i've seen recommended numerous times in these newsgroups is
Speed Ferret. here's a link to one such post, by MVP Doug Steele.
http://groups.google.com/group/micro...c5bff380fe4bb1
if you do an Advanced Search in Google Groups for "Speed Ferret", you'll get
hundreds of posts, many that also mention other solutions in addition to
Speed Ferret.

hth
"colemanj4" <co*******@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

Hello,

I have a [Sold?] field in a table that I need changed to [Sold] due to
some barcode scanning software that will be using the ODBC link to
this database that does not like to work with '?' in the field name,
that my lovely predecessor left there for me.

This field is used in a great many of the queries, reports and forms
that we have here for this database. So, I was wondering if there is a
way to change that field name and have all the places that it shows up
change as well so that I don't have to spend a week going through the
Database by hand.

Thank you,

--Jason Coleman

[Yitzak]

--Jason Coleman

try on a backup of your MDB - you might get lucky...

CurrentDb.TableDefs("TABLE_NAME").Fields("[Sold?]").Name = "Sold"

I was surprised it actually cascaded change into queries. HOWEVER
changing other fields didn't work ALL the time.
But thats the Access way I'm starting to find out, does it sometimes
works and leaves it when its too difficult...

[tina]

sounds like you have the Name Autocorrect option turned ON in your database.
i strongly recommend that you turn it OFF; for more information, see
http://allenbrowne.com/bug-03.html

hth
"Yitzak" <te*********@yahoo.co.ukwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...

>

--Jason Coleman

try on a backup of your MDB - you might get lucky...

CurrentDb.TableDefs("TABLE_NAME").Fields("[Sold?]").Name = "Sold"

I was surprised it actually cascaded change into queries. HOWEVER
changing other fields didn't work ALL the time.
But thats the Access way I'm starting to find out, does it sometimes
works and leaves it when its too difficult...

[Yitzak]

Thanks Tina I didn't know, you are correct I had this switched on.

Actually not a big issue with my mdb, I've since moved all data to
MSSQL server and all VBA code to VB app. And just left with virtually
a shell of an mdb no forms etc.

Would like to bin Access completely but its front end is excellent
(the only part) and the power users at my place are quite adept at
designing their own querries - damm shame that...

[colemanj4]

All that did was change the one field... it didn't propogate up
through all the queries, forms, reports, etc.
On Jul 4, 12:55 pm, Yitzak <[e-mail]:

--Jason Coleman

try on a backup of your MDB - you might get lucky...

CurrentDb.TableDefs("TABLE_NAME").Fields("[Sold?]").Name = "Sold"

I was surprised it actually cascaded change into queries. HOWEVER
changing other fields didn't work ALL the time.
But thats the Access way I'm starting to find out, does it sometimes
works and leaves it when its too difficult...

[Yitzak]

On 4 Jul, 18:53, colemanj4 <[e-mail]:
see Tina's previous post - that one liner worked because of an option
selected. But it is a dodgy thing to have enabled...

[Tim Marshall]

Yitzak wrote:

Would like to bin Access completely but its front end is excellent
(the only part) and the power users at my place are quite adept at
designing their own querries - damm shame that...

That's why I use it as an FE for Oracle. Nothing worng with Access in
that capacity at all, nor with its Jet file server back end , if it's
used properly.

As Tina says, turn off auto-corrupt. Speed Ferret is fine and suggested
often by many high level users here. I use another one, Rick Fisher's
excellent Find and Replace http://www.rickworld.com/
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[colemanj4]

Tim:

Thank you so much. That Find and Replace by Rick worked beautifully!
Just saved me about a weeks worth of combing through queries, forms
and reports! Thank you!

--Jason Coleman
On Jul 5, 12:00 am, Tim Marshall
<[e-mail]:

Yitzak wrote:

Would like to bin Access completely but its front end is excellent
(the only part) and the power users at my place are quite adept at
designing their own querries - damm shame that...

That's why I use it as an FE for Oracle. Nothing worng with Access in
that capacity at all, nor with its Jet file server back end , if it's
used properly.

As Tina says, turn off auto-corrupt. Speed Ferret is fine and suggested
often by many high level users here. I use another one, Rick Fisher's
excellent Find and Replacehttp://www.rickworld.com/
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto