Search results for query: *

tgikristi, I wish I could give you a better answer, but the only thing I can tell you is : 1. Use a desktop shortcut that routes folks through the workgroup information file you created for the database. 2. If you've secured the database properly, then people shouldn't be able to log in as...

Hey All, I have a query : select [empid] from TABLE_A where [empid] NOT IN (select [empid] from TABLE_B); I get NO results even though there are differing values between the 2 tables. I tried reversing the query, e.g.-- select [empid] from TABLE_B where [empid] NOT IN (select [empid] from...

Good Afternoon All, Is there any way in MS Access 2000 to display a message to the user when they have accessed a record that is currently "locked" ? As of now, I have record locking for a form set to "Edited Record" only, and when a user loads a record into a form that...

Jim, God Bless You ! I had been struggling with the same error. (rs.recordcount > 0) did the trick.

Good Evening All, I've searched Microsoft's Technet as well as this site and can't find anything that *exactly* addresses the issue, so please bear with me. Is there any way you can use a SQL query in the expression builder that references fields in the table as well as fields/controls in the...

Good Afternoon, I have a simple form with a primary key field "Employee ID" and other fields that need to be filled in. What I'd like to do is create an unbound text box at the bottom of the form, and simply print the results of a query in that text box as the "Employee ID&quot...

Dave, What about the other users on your network ? When they tried to open the database WITHOUT specifying your new .mdw file via WRKGADMN.exe, were they prompted for a password ? If so, maybe I'm doing something wrong, but if I interpret all of the white-papers correctly : IN ORDER TO link...

Dave, Yes, I've followed the general procedures from Microsoft's very own "technet" knowledge base. I think what I'd like to know is this : Is there a way to force the users on the network to use my new workgroup information file without them having to run the "WRKGADM.exe&quot...

Good Afternoon All, Okay--- I gave Admin a password in the database. But I still have users who can launch MS Access and the database comes up WITHOUT prompting them for a password. I suspect that their default "system.mdw" file is coming into play. When I take away...

Maggie (? I presume ?), No, Admin is no longer the owner of the db & all objects. I created a new Administrative user who owns everything after I imported all of the objects into a database while logged in as that new user). The problem is this--- I want everybody to be prompted for a...

Mike, Thanks for the info. But is there some way to enforce use of the .mdw file without use of a shortcut or users joining the workgroup ? The problem I'm having is that even after I change the password for "Admin" in the database, users are still able to log in as "Admin&quot...

Good Afternoon Everyone, I'm Paul, I'm new to this service, and it looks like a tremendous resource ! Thanks in advance for your help. Here's my situation : ------------------------------- I have an MS Access 2000 DB, and I've followed all of the standard "Secure An Access DB&quot...