Search results

I went to "Change Owner" dialog and it says the owner of the database is <Unknown>. And the 'Change Owner' button is grayed out. So i can't even change it, how do i fix this?

Ya I logged in as another user of the Admins group, but when I try to access User-Level Security with this user it lets me, but when I finishe the wizard it gives me this error: Error 'An unexpected error occured while changing the owner of the database. This problem can occur if you have (1)...

I checked this out and it's cool, but I get this error when I select User-Level Security in my database: The security wizard cannot be run on a database when you are both logged on as the Admin user and the database has been previously secured. To fix this problem, you may log on as another...

Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all...

I have a database, and I went to tools, security, user-level security. I applied some settings and tried it. Unfortunately I set it as default. Now all my databases use this, which really messes things up. How do I completely remove User-Level Security?

It seems like it's applied the security to all MS access databases

OMG MS Access is really getting me angry now. I've applied USer-Level Security now and it totally messed things up. It won't let me edit anything even when I login as admin. How do I get rid of the security now?

Ok there is this feature for User-Level Security, which allows me to create users. I think this should work, but the wizard is very unclear. But this is basically what I want. I'll see if I can figure it out to get it working properly.

lol, wow I'm such a newb.. thx

OMG... I did that, but now I'm screwed! I unchecked everything and now I can't access any of the database windows for my own editing purposes. How do I change the startup? The tools menu option is missing now.

Ok this is cool, but I don't want the user to have access to the tables. This just means every time I open the database workspace it starts up with my main form. I want a completly seperate program that only opens that form. I don't want the user to go and open my MS Access database. I'm not...

I have a database made in MS Access. It has forms that allow the user to do certain things, such as add to the database, and so on. I only want the user to be able to run a program that will run the one, main form i've created it (as well as any other form that the main for lnks to). how do I...

Open the subform as a stand alone? How do you do this? Do you mean open it as a form on it's own? But I want it to open as a subform.

I'm not exactly sure what you're talking about. Can you explain in more detail?

If you can get the value to the parent from the subform, then can you also get it from the parent to the subform? Because if you can you can make a text field in the parent form, save that data on the in the parent form. Then transfer that to the other subform. Then, since this text field is...

I'm sorry I won't be of much help, but I had the same problem when I tried to filter a form bounded by a table. I think you may need to change some of the coding you've done, I'm not exactly sure how, but try doing something like Me![Subfrom Control Name]![Controls within Subform].. That is...

I'm Somewhat new to Access, but maybe I can help if I understand this a little better. What exactly is "PSR" field? I'm guessing it's within the sfrm1 form..right?

I have a form that lets you enter text. At the end of the form, there is a 'Finish' button. When this is pressed the text that is entered needs to be saved to a text file. How do I do this in MS access with VBA coding? Or anyway possible for that matter. Help is very very very much...

I have a form with two subforms. These two subforms are bound to a different table each. How can I ApplyFilter on these subforms?

DoCmd.Maximize would maximize all dimensions. What I want to do is maximize only one dimension (the width) and the height needs to be with respect to the number of windows. So if I open 4 windows I'd say 'maxHeight'/4 or something like that. Is this what you did?