G
gagecres
I have a project where I have created a database for some users. As I
continue to get feedback from the users I make updates and changes to the
database. Now I want to send out an updated version of the database. The
issue is that I don't want the users to have to re-enter into the new version
all the data that they've already entered in the older. I would like to
setup an easy way for them to do this automatically. I believe the way to do
this is to create an append query and attach it to a button. I think the
query would be something like this:
INSERT INTO XXX
SELECT *
FROM XXX IN 'C:\My Folder\subfolder\database.mdb';
My question is since I don't know what folder on their PC the users are
storing the older version of the database, how do I use this same query but
let the user input the source folder? (i.e. the user enters 'C:\My
Folder\subfolder\database.mdb') I know normally you'd use brackets in the
criteria section in order for Access to prompt the user for the criteria, but
this won't work on an append query, will it?
continue to get feedback from the users I make updates and changes to the
database. Now I want to send out an updated version of the database. The
issue is that I don't want the users to have to re-enter into the new version
all the data that they've already entered in the older. I would like to
setup an easy way for them to do this automatically. I believe the way to do
this is to create an append query and attach it to a button. I think the
query would be something like this:
INSERT INTO XXX
SELECT *
FROM XXX IN 'C:\My Folder\subfolder\database.mdb';
My question is since I don't know what folder on their PC the users are
storing the older version of the database, how do I use this same query but
let the user input the source folder? (i.e. the user enters 'C:\My
Folder\subfolder\database.mdb') I know normally you'd use brackets in the
criteria section in order for Access to prompt the user for the criteria, but
this won't work on an append query, will it?