Updating the structure of a linked database

[Guest]

I have used the Database Splitter utility to create a "_be" version of my
database and moved that to the server. Other computers have code version
with tables linked to the server _be.
I had previously used VB code in my start up routine that checked the
current code version against the data version # stored in a table. This code
will now not run due to the restriction against updating a linked table. I'm
using a "dbs.Execute 'ALTER TABLE ... '" command to do the table change.
Any suggestions on how to update the table structure without manually doing
it to the _be on the server?

 

[Douglas J. Steele]

I don't understand what you were doing with ALTER TABLE.

If all you're trying to do is relink your tables, see
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

 

[Guest]

Thanks for your reply.

I'm using the ALTER TABLE to add new fields to an existing table. As the
system evolves I'm sure I'll also be adding new tables.

 

[Douglas J. Steele]

Ah, I see.

You don't need to use ALTER TABLE on the front end. Make the changes on the
back end, and they should be automatically reflected in the front end. (If
not, use the code I pointed to earlier to relink the tables)

 

[Guest]

OK Doug - thanks for the assist.

Ah, I see.

You don't need to use ALTER TABLE on the front end. Make the changes on the
back end, and they should be automatically reflected in the front end. (If
not, use the code I pointed to earlier to relink the tables)

 

[Guest]

I understand your question and have the same issue. Did you ever figure out
how to programmically update the backend? If the backend is not accessible
to me or is installed at 100 locations, how can you update the backend
structure when you send updated front-ends with additional features?

Any luck answering?

 

[Tim Ferguson]

I understand your question and have the same issue. Did you ever
figure out how to programmically update the backend? If the backend
is not accessible to me or is installed at 100 locations, how can you
update the backend structure when you send updated front-ends with
additional features?

' get exclusive, read-write access to the back end
set db = OpenDatabase(strPathToBackEnd, True, False)

' create the command
strSQL = "ALTER TABLE MyTable etc "

' and do it
db.Execute strSQL, dbFailOnError


The equivalent in ADO uses connection strings and command objects, but
the same sort of thing happens.

Hope that helps


Tim F

 

[Guest]

Helps a lot!

Thanks

' get exclusive, read-write access to the back end
set db = OpenDatabase(strPathToBackEnd, True, False)

' create the command
strSQL = "ALTER TABLE MyTable etc "

' and do it
db.Execute strSQL, dbFailOnError


The equivalent in ADO uses connection strings and command objects, but
the same sort of thing happens.

Hope that helps


Tim F