I have a Microsoft Access Program that we distribute quarterly to our clients. In the past I have set security very tight and only allowed minimal rights to the users and compiled the file into an .mde file. Now I need to allow the users to export a file of contacts they wish to follow up with ion the next quarter's release. That means I'll need to import the file into the next quarter's file.
I have coded a point and click button to export the file and another one to import the same file, run a query to update the flags and comments from the last quarter file into this quarter's database. I tested this without setting the security like I did in the past and without compiling the code into an .mde file.
My question is:
Does anyone know if this code will work with run/read rights set during security and with the file set as an .mde file? Bryan Meek
bmeek@adelphia.net
I have coded a point and click button to export the file and another one to import the same file, run a query to update the flags and comments from the last quarter file into this quarter's database. I tested this without setting the security like I did in the past and without compiling the code into an .mde file.
My question is:
Does anyone know if this code will work with run/read rights set during security and with the file set as an .mde file? Bryan Meek
bmeek@adelphia.net
