Search results

Thanks, JDraw. I had done some debug.print testing and they were always bypassed - never got anything in the immediate window which is why I assumed the code wasn't picking up the changes. I tried your other suggestion and am basically getting the same thing. I like how this auditing method...

Thanks, JDraw and Acropolis. Unfortunately, Acropolis' suggestion didn't work.

Hi, all - I found code online for creating an Access audit trail which seems pretty good (conceptually) but I am having a basic problem: the code isn't recognizing data edits. First of all, I am running a 2003 database through Access 2007 (which may be becoming 2013 soon). The code (at...

Hi, all - I know that Access is not generally considered HIPAA compliant. If the version through Office 365 is used, would it then be HIPAA compliant? Is there individual user access control (user name and password) to a specific database or generally would there be the encryption process...

Thanks for your responses. Spikepl, I'll try your suggesion.

Hi, all - I've successfully (with help of this forum) created a DateDiff calculation that is generated with a d:h:nn format. Now the question: How can i select or identify specific values, such as <= 2 days using those outcomes generated by the expression? Is it possible? Example: a...

Hi, all - We have an mdb database used through Access 2007 and we have a user-level security process with it. One of my users (and only one, and she is my primary onsite administrator) is having a strange recurring situation where her account will disappear so she can't log in. Then...

We have used user-level security successfully not through Access 2007 exactly but through an Access 2003 meb file opened in Access 2007. Then all of a sudden the users aren't being prompted to log in. We're not using an accdb file.

Hi, all - I have a A2003 database (mdb) being opened throughA2007. It uses user-level security with an MDW file. It is a split database with the tables and MDW file on a shared server location. For some reason, users are not being prompted to log on even though the database is still being...

Hi, all - I provide a database application to an external location that is an mdb file but used through Access 2010. After sending a new copy of the database file, that site has been getting error messages which they hadn't gotten before and which I do not get at my location. The messages...

Hi, all - I just changed an mdw from a distance (be sending it via email and accessing via WebEx. The reason for this is the users are on Access 2010 which doesn't allow for access to user level security even though it opens the mdb file. What's happening is that when I log on with...

Thanks for the quick response, namliam - I'm not sure on how to set it up. When I check the "Export data with formatting" (etc) I see nothing about choosing a fixed width format and with I export, it seems to be delimited.

Hi, all - I am trying to export a table (and possibly later a query) into a fixed width text file and I am not finding where to set the specifications. When I select Text File in the export tab, I only get the check box about Export datq with formatting and layout. Is that basically it...

Yes, I did. I put the code in the load event. It seems to have done the trick. Thanks for the suggestion.

Thanks for your response. I'll try your suggestions. In answer to your question, other locations with the database do use the FE on their hard drive. We just don't at this location. Also, it's easier to make modifications to the FE and plugging that application in without interrupting...

Greetings, all, Here's the lowdown: I have a split database as Access 2003 files accessed through Access 2010. Both files are stored on a server with the FE file being accessed on that server, not on individual hard drives. I am now getting an runtime error 2467 "the expression you...

Thanks--I'll give it a try.

Thanks for your response. I have the workgroup file pointed to via a shortcut and the users actually get the logon window showing that the ULS is working. But if I want to change or managed users or the user wants to change password, "Users and Permissions" doesn't show in the Administrater...

I have a Access 2003 database (mdb) which is used via Access 2010. In Access 2007, "Users and Permissions" was still accessible in the Administrater tab but it isn't in Access 2010. Is there a way of accessing "Users and Permissions" in Access 2010? Thanks!

Hi, all - I have been using a A2003 file through A2007 to be able to use user security. We are now in A2010 and the users and permissions component is not showing in the Administrator area as it did in A2007, although the security is still functioning. How do I get access to Users and...