Remove form from a Access Database...

[André]

Hi!

I hope someone can help me... I have the same database in
several schools. And I want to replace/update a form and
in all of MDB files in all schools, but I would like to
do this programming.

If someone have already experienced that, I would
appreciate to get some help.

Thanks,
André.

 

[Ralf Menga]

how about a replication DB ?
You make your changes in the master db and then you use the replication
function to syncronize the db

gR


Hi!

I hope someone can help me... I have the same database in
several schools. And I want to replace/update a form and
in all of MDB files in all schools, but I would like to
do this programming.

If someone have already experienced that, I would
appreciate to get some help.

Thanks,
André.

 

[Marshall Barton]

how about a replication DB ?
You make your changes in the master db and then you use the replication
function to syncronize the db

NO! Don't do that.

Replication is intended for data only. There are reports of
attempts to apply it to objects that have totally hosed the
mdb.

 

[Marshall Barton]

I hope someone can help me... I have the same database in
several schools. And I want to replace/update a form and
in all of MDB files in all schools, but I would like to
do this programming.

That is a real can of worms.

You are much better off just redristributing the front end
mdb file. You have split the database, haven't you?

 

[André]

The strutucture of the mdb it's the same... in all
places. But one form need to be change, I would like just
to remove this form and insert a new one with the code I
am going to write, is that possilbe? If it is how?

Thanks,
André.

 

[Marshall Barton]

The strutucture of the mdb it's the same... in all
places. But one form need to be change, I would like just
to remove this form and insert a new one with the code I
am going to write, is that possilbe? If it is how?

You can copy the mdb file with the new form to a place where
each machine can get to it (on a server machine or each
machine's C drive). Then go to each machine, delete the old
version of the form from each user's mdb file and import the
new form from the new mdb file.

Like I said before, this is a mess and you really should
split the db so you can just copy the front end mdb file to
each machine and be done with it.
--
Marsh
MVP [MS Access]