Source database

[KarlHardeman]

Hi. I need to modify a table but I'm receiving the following error. Table
'XXXXX' is a linked table whose design can't be modified. If you want to
add or remove fields or change their properties or data types, you must do so
in the source database'. How can I identify which is the source database?
Thanking you in advance for all your help in this matter

 

[Douglas J. Steele]

Open the Immediate Window (Ctrl-G), type

?CurrentDb.TableDefs("NameOfTable").Connect

(including the question mark), then hit Enter

Underneath, you should see something like

;Database=E:\Folder\File.mdb

That'll tell you where the table's located.

 

[KarlHardeman]

Hi Douglas

Thanks for the reply. I know where all the table live, but I don't know
which one is the source table. Any further thoughts.

Many thanks

Karl Hardeman

 

[John W. Vinson]

Hi Douglas

Thanks for the reply. I know where all the table live, but I don't know
which one is the source table. Any further thoughts.

The name of the table in the backend is the same as the name of the link in
the frontend. The "source table" just means "what is this linked to".

 

[Douglas J. Steele]

The name of the table in the backend is the same as the name of the link
in
the frontend. The "source table" just means "what is this linked to".

Not sure that's correct, John.

I believe you can name the linked table anything you want. In other words,
the table's Name property doesn't have to be the same as the table's
SourceTable property.

 

[Douglas J. Steele]

?CurrentDb.TableDefs("NameOfTable").SourceTableName

 

[Douglas J. Steele]

Not sure that's correct, John.

I believe you can name the linked table anything you want. In other
words, the table's Name property doesn't have to be the same as the
table's SourceTable property.

Oops, the name of the property is SourceTableName, not SourceTable

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Tony Toews [MVP]]

Open the Immediate Window (Ctrl-G), type

Or just hover over the linked table entry. A tooltip will show up
with the MDB name and path.

Tony

 

[David W. Fenton]

The name of the table in the backend is the same as the name of
the link in the frontend. The "source table" just means "what is
this linked to".

The names don't have to be the same at all. It's very common for
that to be the case, but not required. For instance, I have a client
database that was created by another developer and that's now in
heavy revision. I've changed the front-end table names to follow my
naming conventions, leaving the back end alone with the original
table names. This means all my new work uses the new naming
conventions while the old database still works (which occasionally
comes in handy for something I accidentally break when trying to add
some new features).