Hello All!
I am running Access 2003 on XP SP2. Developing a small application for a client running Access 2000.
The developed database (‘Main Application’) consists of a front end residing on users machines and the back end residing on the server.
I now need to make some changes to the backend and am trying to develop a solution that enables me to e-mail a file (with some instructions) to enable the user to update the back-end at the click (or clicks!) of a button.
Currently I am writing a small Access database (‘Updater’) that will do this, but as this is taking a little time, wondered if I am missing a quick and easy trick?
I essentially need to modify one table in the back end (add an extra field) and then run a couple of queries to populate this field with data.
The approach I am taking is, in essence:
Check all users are out of database (‘Main Application be’)
Lock database (‘Main Application be’) to prevent users re-going in whilst the changes are made.
Backup the ‘Main Application be’ from the ‘Updater’
Import a table from the ‘Main Application be’ to the ‘Updater’
Inside the ‘Updater’ –
• add the extra field / column to the imported table,
• run the queries insider the ‘Updater’ on the new data,
• delete the original table in the ‘Main Application be’,
• export the modified table back from the Updater to the ‘Main Application be’,
• release the lock on the ‘Main Application be’.
The users will update their own front ends by creating a new mde to replace their existing one.
The reason I am exploring this approach is that the user already has tables populated with data which need preserving.
Besides I thought it would be useful to develop an approach for remotely updating database – I have only been ‘programming’ for a year so am relatively new to this…
As I read the forum (and having tried to search for an alternative approach before posting this) I become increasingly aware of how little I know, so thought it worth asking the question before I re-invent the wheel…
Any responses gratefully received!
(I hope this makes sense? I know what I am talking about!)
I am running Access 2003 on XP SP2. Developing a small application for a client running Access 2000.
The developed database (‘Main Application’) consists of a front end residing on users machines and the back end residing on the server.
I now need to make some changes to the backend and am trying to develop a solution that enables me to e-mail a file (with some instructions) to enable the user to update the back-end at the click (or clicks!) of a button.
Currently I am writing a small Access database (‘Updater’) that will do this, but as this is taking a little time, wondered if I am missing a quick and easy trick?
I essentially need to modify one table in the back end (add an extra field) and then run a couple of queries to populate this field with data.
The approach I am taking is, in essence:
Check all users are out of database (‘Main Application be’)
Lock database (‘Main Application be’) to prevent users re-going in whilst the changes are made.
Backup the ‘Main Application be’ from the ‘Updater’
Import a table from the ‘Main Application be’ to the ‘Updater’
Inside the ‘Updater’ –
• add the extra field / column to the imported table,
• run the queries insider the ‘Updater’ on the new data,
• delete the original table in the ‘Main Application be’,
• export the modified table back from the Updater to the ‘Main Application be’,
• release the lock on the ‘Main Application be’.
The users will update their own front ends by creating a new mde to replace their existing one.
The reason I am exploring this approach is that the user already has tables populated with data which need preserving.
Besides I thought it would be useful to develop an approach for remotely updating database – I have only been ‘programming’ for a year so am relatively new to this…
As I read the forum (and having tried to search for an alternative approach before posting this) I become increasingly aware of how little I know, so thought it worth asking the question before I re-invent the wheel…
Any responses gratefully received!
(I hope this makes sense? I know what I am talking about!)
