Search results

oft, I know what I done wrong, Thanks for the help

Hi folks, I'm using the DB password to secure the DB and thought that when I secured the BE and relinked the BE tables to the FE it would work, I'm getting an "Invalid Password" when I try relink. Don't know what I'm doing wrong. Can anyone help me? Thanks

Having listen to everyone here and with my own experience of using auto PKs pretty much exclusivly, I have to say I'll stick with what I'm used to... auto PKs. I still can't quite get,,, when an auto number is so easy to use in my opinion, why I'd want to use a long natural key, especially...

Hey Tylar! wow, that's more than I could ask for, thanks for that... it's much appreciated. Paul

Thanks, that's a relief. What I meant in my badly explained dilemma is that, I was either going to use the long natural PK and put the long natural PK where the line manager names are or just leave the line managers the way they are and still use the natural PK geez, that is madness, what...

Hi folks, I have a form and use code to filter the records with varius drop down lists, for example, a name drop down list to filter records with only that name. At the end of the code I just use docmd.Applyfilter, strwhere I want to use two dates to filter the records. I've only ever done...

Hi There, I'm sure we all know of the Northwind self join, "employees" and the "reports to" field I have a question about the same situation. The DB I'm working on has the exact same situation, the only difference is that it's not a autonumber PK but a natural PK, one that's quite a bit...

Thanks Brian, I'll look into that. users will be typing into the field a lot and they want the easiest way of migrating that data into Excel without having to do much work themselves if you know what I mean Thanks

Hi there, I've got a question I hope someone can help me with. Basically, I have a field in Access that allows 90 characters. I want to move the data in this field to Excel. However, the field has to be broken up in to three fields in Excel. so that some characters are in one field and so...

Thanks for the reply. Yeah, I heard sendKeys is unpredictable. I'll try it and see if I have any problems Thanks

Hi there I was just wondering if there was a way to access F1 Programmatically through a command button. The reason is (and I could be doing this completely wrong) that I want to access my help file without having to press F1. I'm sure there's other code to do this, but I just can't find...

thanks for all the help folks. I've made it thus far, having secured the FE so that know one can access the DB directly without the shortcut. Now I'm securing the BE by using a copy of the FE DB as the backend. I'll let you know how I get on soon. Paul

Hi I've just created another test DB, set up the workgroup administrator, set a password for admin created another user, put in admins group, took admin user away from admins group... Set up the wizard and moved all ownership of objects to the new user and revoked all admin users rights...

I don't understand, if you're refering to the fact that I possibly overwrote the default system.mdw when working with a test database only to overwrite that one with a new system.mdw without any passwords and with no WID so that it resembeld the original system.mdw? I've created a new...

Ok, Let me know if I've got this correct. I assign permissions for my database, taking away the permissions for admin (including a password for this accout) and replacing this user acount with another (PowerAdmin is something) for the admins group. Using the security wizard to assigning the...

Hi, thanks for all your help on this folks. I'm actually struggling to understand this. I'll have to get back to you about how I get on once I've worked on it more. paul

Hey Gemma, how are you? I created a new workgroup file without a password to overwite the one I created. I'm not really sure how to deploy the frontend file to all PC's so that so that it will use the created workgroup file see the thread...

First of all, I'll tell a bad joke... What's green, has four legs and falls from trees? (answer at bottom) I've made a workgroup file for security and have the backend file on the server, and I want to deploy the frontend to all the PC's. however, I'm not really sure how to deploy the...

Hi there I really hope someone can help me. I used a test database to work on security. I didn't think it would effect other databases. Now I've locked myself out and can't open any databases. I keep getting asked my logon and password for ALL databases. What can I do? I don't understand why...

hello, I really hope someone can help me here. I have two dates fields - FundingFrom and FundingTo - on a report. I'm using both as criteria in an input form. I want to use the Between, And function but I've only used this function on the one date field to filter the records. does anyone...