Update Entire MDB?

[DamianCrow]

How do i update an entire MDB file? I have a database that may need to have tables/form/queries added ata a later time, and I will not have dirrect access to the computer that needs to be updated. Is there a way to update the MDB with out Data loss? maybe by referencing a web address that would scan the MDB for updates?

 

[IGPCS]

well when i develope a database that needs to be updated all the time what i do is use 2 mdb files 1 has only the tables and the other one has the forms queris reports and modules and the tables in the second 1 are linked from the first 1 that way when my customer ask me for an update i send him a .exe file i created that inserts the new second mdb in its location in this case i dont have to be scared of loosing data

p.s. you dont need to use an exe file all it is send the customer the mdb file and ask him to put it in its directory and clicking yes on replace

hope you got it

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY