Search results

Thanks for the thoughts, Doc Man. I guess one just has to have this inconclusive conversation with the auditors once in a while. They seem to end up accepting the advantages of using Access, even if you can't flourish flashy documents.

Thanks for the response, Banana! I have the query at second hand so don't know for sure what the auditor is concerned about, but I took it to be not so much security as just the soundness of the program itself: when you enter data, how do you know that the data are where you think they are, that...

A client's internal auditor has asked: "You have documented the validation of your Access app., but who has validated Access itself?" In 2000, we wrote to Microsoft asking for quality assurance documentation for Access and Excel 97. A senior attorney responded that "the confidential nature of...

Pat Hartman, I'm interested in the approach you suggest but don't understand what the "basic selection criteria" would be like, to cover anything they'd want to query for, or how I'd be providing these criteria. Sorry to be slow, but can you maybe point me in a direction where I can learn more...

Good point. I'm just a little deterred by the description from starting the download and pay up process. (I let my PayPal account lapse....) But I will have a look.

The user mentioned Crystal reports. I've never used this software and don't have the hang of how it works. I thought of it as an expensive developer tool, not something an end user could manipulate. Am I confused? (I thought of posting a separate question in the Crystal Reports forum, but think...

Thanks for drawing my attention to a useful resource. I don't think this will work for me because I didn't follow the presupposed table naming convention. Maybe I can have a look at it though.

I have a database (A2003) being used by an off-site client. In order to reasonably assure that all data changes are recorded in a programmed audit trail, I have shut the users out of the db window: main menu form opens on startup and can't be unloaded unless db is shut down (form is modal and...

Happy Big Seven-Oh! from an occasional Access World Forums user.

It works! This DOES work on the client's network. Thank you so much both for getting the original code and for letting me know its source so I can cite it properly. Yay! SacValGal

True enough. I will try it, and alternatively Environ, which should be safe enough for the conditions. Thank you very much.

Any clue why the api code fails to pick up the login, if the referenced .dll is in fact standard Windows? Seems like after all there isn't anything I'd need to have them install? Does either of you see anything else that could be going wrong?

As Banana mentions, the Dev Ashish routine is essentially what I was using and couldn't get to work on outside networks. (I'm glad to have the attribution--thanks for sourcing.) I'm inclined to give Environ() a try, but am interested in further discussion.

Thank you both! Yes, it is Environ("UserName"). pdx_man, I missed your post and spent some time hunting the function down. I feel very silly not to have known about this, but I must say it was not so easy to find. So, Banana, looks like I won't need to make the elaborate code sample work, but...

Years ago, I got a nifty piece of code from someone on this forum that pulls a user's logon name from the network, so that I can stamp that name on the user's work. It works great in our office, but any time I have to develop a database for a client to use in their office, it doesn't work. I...

I have written a routine to create a daily archive database by copying tables and queries into a new db. The routine is run from within the original database. Is there any way I can program the backup routine to automatically get the database password of the current db and copy it to the archive...

Just to close the story: I proposed an easier solution to the client. We approached the problem from the audit trail end. Since the audit trail is for their convenience and doesn't need to meet strict accountability standards, we decided to put a one-hour lag on tracking. That was a lot faster...

Thanks--sounds like that would work.

I'm posting this question to Forms forum because I'm sure I can't do this with a report--though a report is really what I need to be using. My database has buttons on the forms to preview a "page printout" report based on the data in the record displayed. The reports - formatted to closely...