Updating the structure of a linked database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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)
 
OK Doug - thanks for the assist.

Douglas J. Steele said:
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)
Click to expand...
 
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?
 
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?
Click to expand...

' 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
 
Helps a lot!

Thanks

Tim Ferguson said:
' 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
Click to expand...
 
Back
Top