Search results for query: *

Every user is logging in as Admin as default, but I have transferred the database to a new Owner and have removed many of the rights that Admin enjoys. The annoying thing about Access security is that to give Admin rights to view information on a form or report I have to give them access to...

Thank you all for your advice. In addition to the user level security I have secured the back-end with its own password Linked the front-end Removed all of the toolbar options Hidden all sensitive queries and tables (in both BE and FE) Created a "blank" pop up form for the BE (I want to...

Thank you for the responses. I have set up users permissions in the mdw file. If I were to secure the back end with the database password would I put the password in the client app via some VBA code???

Thanks Ed, What do you mean by ...access to the database window is restrictedd users won't know where the backend is so won't be able to copy it to their hard drives. ? My greatest concern is the possibility that someone will copy the back end DB to their hard drive.

Hi, This is probbly more of a networking question than an Access question, but I have always received good advice here... I have a split db. I want to place the back-end in a different Active Directory folder than the front end so as to prevent users from copying the tables to their hard...

Fantastic!!! I knew it must be something easy. Thanks for your help PHV!!!

Hi, I am trying to upgrade the security on a multi-user database located on a network. I have utilized the Access user level security. Every group's permissions have been assigned. What I need to do is to have my users enter the db via a shortcut that will take them to the necessary mdw file...

Thread 701-1065394 got me what I wanted. Thanks for your help.

Thanks for the responses. I should have clarified that [FIELD_3] has four choices. 1, 2, and 3 should return all results regardless of any value typed in [FIELD_1] and [FIELD_2]. In fact I have VB code that hides those fields unless the user selects the forth option - "xyz". At that point...

Hi, I have a query that returns results based upon a user's selection of different fields off of a form. The query works fine except for when I am trying to reference two fields to obtain results greater that [FIELD_1] but less than [FIELD_2]. It works when the Where section of the SQL only...

Thanks PHV, It brings up the form (with a few bugs, but I think I can sort those out). However, the form is "frozen." Perhaps the recordset is no longer updatable? None of my other code (e.g., navigation buttons) work now either. ???

I get a syntax error. I added " to the beginning of each SQL statement and " & _ to the end. But I still get the error.

Hi, I recently split my database and now everything runs really slow. From other posts I can see that this is a common problem. One of the solution to the slowness that I have found is to have the SQL run on Form Load instead of referencing the query in the Record Source Property. I can cut...

Hi, I am trying to make an automatic footnote function in Excel. What I would like to do is to have the user enter some notes next to a column of numbers. The note is text. These wil become footnotes. I would then like (after button click) to have the notes cut and pasted at the bottom of...

Greetings, I am new to VBA in Excel so pardon any newb questions... I would like to create a "footnote" type funcion where a user's input would be entered into a cell - copied to an adjacent worksheet - and then replaced with a footnote number. In addition two other cells on the same row...

I took the make table route. It works! Thanks. Any idea why the query was crashing the DB? Was it too big?

PHV, It just stops. No error...just "application not responding" from the Windows Task Manager. I usually use the built-in Tools>Office_Links to dump into Excel. However, when I first tried to find work arounds I tried a selct all records - copy - paste. That too caused the DB to crash. ???

Hi, I have a query with five tables -- all of them non-updatable linked ODBC. The results of my query are about 1900 rows and 42 columns. Everything is great except... When I try to dump the query into Excel the whole DB crashes. I have tried to limit the results and do a piecemeal transfer...

Thanks for the responses! lipins: I got the query to work. So far it has tested out just fine, but man...it sure takes a long time to run. Any ideas why? PHV: I got your version to work (sort of). I keep getting duplicate lines. One with a budget amount and 0 for the actual, and a second...

Hi, I need to join two tables. tbl_Budget has three fields that I need: [Fund] [Account] [Budget_Amount] tbl_Actuals also has three fields that I need: [Fund] [Account] [Actual_Amount] I need to compare like [Account] within like [Fund]. The problem is when an account exists in the first...