Replies

Thank You, Any suggestions where I can search for the proper code to accomplish this? I really am not sure where to start looking with this one. I have a lot of the basic books, “Access 97 VBAPrograming” by Smith and Sussman and one of the “Unleashed books as well as the “Que” book by Jennings. None of which even hint on how to accomplish this.

Thanks
Kevin

Thanks Mark,
I took your reply into consideration and developed queries that first append the information and then flag the archieve tag. How do I get the total from the query to display in the message box you described in the loop process. Would I add a count function in the query (if thats possible) and then just display that result or should I capure that some other way. As you can see, I’m kinda confused about that part. Thanks
Kevin

The problem is that the environment that this program exists requires current information. There are several people using the program who consistantly roll back their system clocks to give the perseption that the reports/work to generate the reports happened prior to certain key signatures needed on paperwork. This stuff is audited regularly. We are using NT4.0 and have for the most part taken that ability away from the majority of the employees through NT security. The problem employees are required to be administrators and have realized as such are allowed to change ther settings. I don’t think I have a requirement to be up to the second, but just to keep anyone from rolling the dates back several weeks. If you have any other suggestions I would really appreciate them. I don’t do the IT here where I work but am just the developer of this program which has taken off and progressed far more than anticipated and am trying to keep pace. The program prices out contract changes and this really becomes an issue when the change is authorized and there is no pricing data to back up the price the contractor submits. I am hoping by doing this, all required information will be present and on time should an audit take place.

Thanks for your help and response to my post.

Paul,
I can’t get this thing to compact or zip. Compacting gives me an error message and zipping only compresses about 3%. Can I email this to you. It looks to be about 4.7KB.

Kevin

Thanks CHarlotte and Paul,
Here is what I have done based on your help/guidance. I have tried to join the .mdw as chorlotte suggested. I thought I was getting somewhere when I went to tools and security and found 3 additional users listed in the text box. I must clarify that at no time since I started to try and figure this out have I been prompted for a password. After seeing the additional names I tried to use one of them to change the permissions. It did not work and still said I didn’t have permission. In total the permissions text box had four entries. Admin, and three other new ones. From this point I tried to create a brand new Workgroup and new unsecured .mdw. This did not work because it overwrote (my fault) the .mdw that had all the permissions and groups that I just joined. I hope someone at this point doesn’t tell me its toast. Where did I mess up? Can this still be saved or do I need to go back to the computer it came from and start all over?

Thanks

Kevin

Charlotte,
Interesting enough as I am reading through ACCESS 97 Unleashed, I realize that the database never asked for a password when I opened it. To clarify my import procedure, I opened a blank database and imported all the objects. I got an error message on the four queries that are protected that told me I could not import them. So they are stuck in the original database. When I try to change the owner, it appears I am already in as Admin, but it still won’t let me change the ownership. In the manual mentioned above it tells me that I can log in using the system.mdw or some other mdw. How do I do this? Is this the key to my problem?

HELP!!!!!!
Kevin

Hi Charlotte,
I tried this approach based on the help file in Access. I was not successfull. I got a message stating that I didn’t have the permission to change the owner. There is however a copy of an MDW file on the floppy that was given to me. Is there a way to access this file since it is probably the one used on the database?

Thanks for your help

Kevin

OK, at the risk of sounding really stupid, I had heard many times that the Office Developer Edition is the way to go when you want to create these data bases. I had designed a couple, mostly basic, but one is fairly complicated (to me). I do not own or have not used this edition. What will it get me over and above say the Office 97 Professional version I have now if I invest in it? Are the benifits significant? I don’t program full time but am required to maintain the ones I have created. Any input is appreciated. Thanks

Kevin

Hi, I am doing the same thing. It seems to work very well. I have a main table and three other tables all supporting a main form and three subforms. When I archive a record from the main table/main form I run a query which adds it to the archive table. Another query takes the supporting information from the subforms records and adds them to there own archive tables. Finally i run queries which delete the newly archived records from the current tables. I have examples I can email to you if you would like. I also am reversing the archive by reversing the query steps. I perform all of this as the user logs on it picks up the records assigned to them and allows the user to pick and choose the records he/she wants to archive. All the user does is check a box on a form next to the record they want to archive.

Kevin