I've used a similar approach, but you can also rename the TableDefs
manually, if there are not too many.
Some, however, think the "dbo_" serves nicely to distinguish between server
tables and local (usually "lookup") tables. If that's not a consideration,
then the "dbo_" prefix is contentless and can be dispensed with. In one
client's application, all the local tables were prefixed with "tlkp" because
of the project's naming standard, so any table without "tlkp" was, by
convention, a server table.
Larry Linson
Microsoft Access MVP
"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
The answer is yes; you'll have to change the name of the table in any
Access based queries. Use a good find and replace utility like Rick Fisher's
Find and Replace for Access (www.rickworld.com) to save yourself oodles of
time.
Hi Steve and Patrick,
There is also a possibility to just rename the linked tables.
I had the same problem with a complicated app when the backend was upsized
to SQL-server. I made a function (so you can call this in a macro) to do so (DAO-code)
Function RenameODBC()
Dim db as DAO.Database
Dim i As Integer
Set db = CurrentDb
db.TableDefs.Refresh
For i = 0 To db.TableDefs.Count - 1
If Not db.TableDefs(i).SourceTableName = "" Then 'ivm MSys*
If Left(db.TableDefs(i).Name, 4) = "dbo_" Then
DoCmd.Rename Mid(db.TableDefs(i).Name, 5), acTable,
db.TableDefs(i).Name End If
End If
Next i
db.TableDefs.Refresh
End Function
--
Hope this helps
Arno R