Sending update to tables etc remotely, overview needed

[ptaylor-west]

If I make a change to a form or report how can I update a remote database without them sending it to me so that I can import the new form or report? I thought that maybe sending something as a self extracting file but I have no idea how I would get it to just update the form or report.

The problem is more complex if I update a table, say add an extra field because if the solution is just to overwite the existing table, as in the case of a self extracting file, it would wipe out the data. So this needs something like an append I presume.

I will be grateful for any contributions.

 

[John.Woody]

Paul

My dbs are split Front end and Back end (tables only)

If I upgrade a front end I tend to overwrite the existing file with a whole new db. Usually there are several forms, queries reports and/or code I need to upgrade.

To update the back end either by adding tables, fields, or relationships, this has to be done with code.

I use a seperate db and attach the tables (depending on what you are doing this may not be necessary.

To add a complete table use the transferdatabase command. To add fields to an existing table, you can open a recordset, define a tabledef and a field and use .createfield to create the field from the tabledef and then .type to define what type of field it is. With relationships you need to define a relation.

If you look at your help file under Type Property you should get some info there

HTH
John

 

[ptaylor-west]

Thanks John

It has pointed me in the right direction although it will probably take me sometime to experiment with it. But I like your idea of putting the upgrades into a separate database as it makes it more logical to import it into the existing database so that you can import just the structure, this solves my overwriting data in a table problem.

 

[ptaylor-west]

Excellent, the transferdatabase method works a treat and because it is so easy it is better to transfer the whole table or from rather than adding a field.

The only problem I found is that it's all OK providing the operator at the other end hasn't moved the database to another location (as I would use the export option to overwrite a Table) and if it has been moved it falls down.

Is there a method to overcome this ie: automatically browse/search for the database?

 

[John.Woody]

Paul

I use a text box to enter the location of the data file and use that to determine the database name in the transfer database method. How are you getting on with adding fields etc?

 

[ptaylor-west]

Hi John,

Not much luck so far as I need a bit of time to do this and it is at a premium at the moment, an example would be most helpful as I find it much easier to follow exisitng code etc.

Also I'm not sure what you mean by a text box, I just type the info direct into the macro. Is this part of browsing for a database if the end user has moved it on their system?

Also is it possible to transfer more than one item at a time say export a table, a report and a new form?

 

[ptaylor-west]

Hi John

Thanks for e-mailing me your db so I could work out how to update fields. That would have taken me forever to work out, I have already used it on a test db and it has worked fine. If I find a solution to sending muiltiple forms/reports etc I will let you know.

Unfortunately the details involved are far too large to reproduce here but if there are any interested parties perhaps if they contacted you, you would be kind enough to pass on the examples you sent to me.

Very Grateful...