B
Beth
Hello,
In my Access 2000 database I have a switchboard form. On the form, I would
like a button that would export all the records in one of my tables to an
Excel file that is then password protected for opening. The application
will be given to some end users and I want them to be able to generate the
Excel file to send to the administration, but I don't want the users to be
able to open the Excel file and view the data.
The table is "tblStudents"
I saw something about the transferdatabase method, but I don't know exactly
how to use it and I didn't see anything about the password protection.
Thanks in advance for the help. I've been stuck on this for awhile now.
Beth
In my Access 2000 database I have a switchboard form. On the form, I would
like a button that would export all the records in one of my tables to an
Excel file that is then password protected for opening. The application
will be given to some end users and I want them to be able to generate the
Excel file to send to the administration, but I don't want the users to be
able to open the Excel file and view the data.
The table is "tblStudents"
I saw something about the transferdatabase method, but I don't know exactly
how to use it and I didn't see anything about the password protection.
Thanks in advance for the help. I've been stuck on this for awhile now.
Beth