Search results

I am working on a database in which I must check the records in one table against the records of another table, and return a list of the one's that don't match. The tables contain salary accounting information. For each employee, they can have up to 5 fund/orgn/acct combinations, with a...

I have a secure database that has users login using their oracle username/password. I've got that working great (thanks to some code I got off another thread....Thanks, Pat!), but I need to make it where my code automatically logs on a 2nd user, who has oracle access to a couple of linked...

Thanks - the batch file worked like a charm.

I have a finished secured DB that I'm trying to figure out how to distribute properly. The DB is called "New Finance Queries.mde". I've got the workgroup (mdw) file stored out on the server at "\\Fin_tools\Finance Queries\New Finance Queries.mdw". I've searched this forum on this topic, and...

I've gotten it to work! I couldn't get any of your ideas to work (anytime I modified a query, it's Run Permissions got set back to User's automatically and running the SQL via code wouldn't allow Owner's permissions either), but your ideas did get me thinking in the right directly, and I'm...

I'll give that a shot, but I read in the security FAQ that you can only use owner run permissions on a saved query, not on an SQL string that you run using DoCmd.RunSQL.

That makes sense to me, but the problem is that my users (or rather, my code that runs while my users are logged into my database) need to be able to modify queries. My entire database is built around a query that is created by the options my users choose on the attached form. When they hit...

I'm working with Access Security for the first time. I've read the FAQ, and I feel like I have a good grasp of how it works overall. The code on my main form creates a query and saves it as a queryDef. However, I need this query to be able to pull records from a table that is off-limits to my...

Not to resurrect a thread or anything...but I've been working on this very problem today, and have written a function that does this: Public Function SetRunPermissions(qryName As String, SetToOwner As Boolean) On Error GoTo SetRunPermissions_Error Dim dbs As DAO.Database Set dbs =...

Pat - thanks so much for your help. I REALLY appreciate it. I've spent my morning at work rereading the FAQ, working with Access security and generally just trying things. Here's what I've come up with which I think will work. Let me know if there's any gaping holes in this. - I've created...

I'm trying to figure out what the best way is to fully secure my database the way I want it to be. I've browsed through some of the posts and skimmed the Microsoft security FAQ, but I'm not seeing answers to my questions, and I'm unsure if that's the route I really want to take. Basically, my...

Thanks for all your help. I searched the forum and found a solution at This thread using a recordset rather than a RunSQL Insert Into statement.

I have a database that backs up a bunch of tables from our live oracle database and runs every night via a windows schedule task. I've had ongoing problems with it working some nights and not other nights, so I've decided I need to put some code into it to copy whatever errors are happening and...

You may want to just use "UNION" rather than "UNION ALL". UNION ALL will include duplicates; UNION won't.

Ok, I tried that as well....but for some reason code execution stops after it goes to design mode...is code not able to run on a form when it's in design mode? Thanks for trying to help....I really appreciate it.

No, it doesn't give an error - it just simply won't run. I've had an ongoing problem with Access making buttons, functions, etc. simply not run rather than giving me an error. I haven't been able to figure out why yet. I've already tried using different syntax to refer to my listbox...

I'd like to change the multiselect property of a listbox using code when the user clicks a button. VBA help lists a way of doing this: Forms("Order Entry").Controls("Country").MultiSelect = 2 However, this doesn't work. My code won't even run when this line is in there. When I comment it...

Is there anyway to bring a control to the front (exactly like what Format->Bring to Front does) in VBA? I have a combo box that is directly below a label, close enough that the top pixel of the combo box exactly overlaps with the bottom pixel of the label. Sometimes while I'm running my form...

Sounds great. Is there a way to use the SET keyword in a regular Access Query (as opposed to doing it through a DoCmd.RunSQL code statement)?

Jon - this is EXACTLY what I was looking for. Thank you very much. I can tell you put a lot of effort into creating the example for me - I really appreciate it! I'm pretty experienced in VB/VBA, so all the VB parts make perfect sense to me. But I'm still trying to figure out why the SQL...