Hi,
I am using the following piece of code to allow users to update their databases.
Basically I have 5 users who all have their own databases in different locations. To save them from having to email the databse, me completing an update and then emailing it back I have written an "updating database" that contains all of the new items.
I have a button that uses "On Click" and then runs the following code :
DoCmd.TransferDatabase acExport, "Microsoft Access", stDocName, acForm, "frmsplash", "frmsplash", False
MsgBox "Update has been completed to version 1.3", vbOKOnly,
I am using Access 2003 but have written the update in an Access 2000 format as some of the users are running A2000. For the users who have A2003 the update works 100%.
The users on A2000 they get a message saying that the update has completed. However the coding behind the forms is not being transferred so when they try and open the database they get various error messages.
Is there a way to transfer the code with the form or even export the class files seperately ?
I am using the following piece of code to allow users to update their databases.
Basically I have 5 users who all have their own databases in different locations. To save them from having to email the databse, me completing an update and then emailing it back I have written an "updating database" that contains all of the new items.
I have a button that uses "On Click" and then runs the following code :
DoCmd.TransferDatabase acExport, "Microsoft Access", stDocName, acForm, "frmsplash", "frmsplash", False
MsgBox "Update has been completed to version 1.3", vbOKOnly,
I am using Access 2003 but have written the update in an Access 2000 format as some of the users are running A2000. For the users who have A2003 the update works 100%.
The users on A2000 they get a message saying that the update has completed. However the coding behind the forms is not being transferred so when they try and open the database they get various error messages.
Is there a way to transfer the code with the form or even export the class files seperately ?
