473,326 Members | 2,128 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

logging as administrator into a secured database

I secured a database using the Security Wizard and left the default admin login information generated by Access in place(it was my Windows login ID). But when I try to access the database from the same computer 30 seconds later, I am only getting the user group functions and no admin functions. How do you log in as an admin onto a database?
Aug 12 '10 #1
6 1583
ADezii
8,834 Expert 8TB
I think the Default is UserName = Admin, Password is blank.
Aug 12 '10 #2
How do you get to the screen where it asks you for a password? The database never prompts me to enter a password when I open it
Aug 13 '10 #3
NeoPa
32,556 Expert Mod 16PB
It should happen automatically if either :
  1. There are more than one available accounts to choose from.
  2. The only account available has a non-blank password.
I think this means you are already signed in as Admin and that your problem is probably elsewhere.
Aug 13 '10 #4
ADezii
8,834 Expert 8TB
I honestly cannot understand how the Database can be 'Secured' without a UserName/Password Login.
Aug 13 '10 #5
NeoPa
32,556 Expert Mod 16PB
There may be scope for other methods of security, but essentially if no account or password is entered then it would not be described as 'Secured'.
Aug 13 '10 #6
Apparently, the original file itself was secured, but you couldn't gain admin access to it. There was a copy of the database automatically created by the wizard on the desktop; and if you clicked on that file, the database prompted you for a username and password
Aug 16 '10 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Therese A. Sorna | last post by:
Hello all, Is there a way to add users to a secured database without having to go into Security -> User and Group Accounts? I have a table for all employees on a secure database, and want to be...
1
by: Lee Rouse | last post by:
I have a secured Access 2000 database. There are approximately 30 user accounts already set up. Each user logs into their copy of the front-end by via a desktop shortcut which includes their...
4
by: xunitinmullik | last post by:
Hello ppl: I am facing a problem that I ahve never experienced before with the secured database. I created an MS Access 2000 application (.mdb) using MS Access 2002 and secured it using exactly...
3
by: alijsyed | last post by:
I am trying to change an existing database password from VB 6. The database is an MS Access 2000 database if this helps How do I do this? Any help is appreciated.
5
by: MLH | last post by:
Is there a quick way to do it? I'm logged in as the superuser and owner of database and all database objects. I would like to export it to a completely un- secured application. Do I have to...
5
by: Spook | last post by:
Hi. I have created a secured database which lots of my colleagues use. However when I want to make changes I can't because invariably there is somebody using it. Is there a way of either...
13
by: Jan | last post by:
Hi: I've used the /decompile switch lots of times when working with troublesome databases. Now, though, I have a database that is secured, and I can't get the /decompile switch to work with the...
1
by: pcard | last post by:
Hello, I ran the User-Level Security Wizard to try to secure an Access database that I created. But after I finished the steps, saved the report that contains all the important user/group info, and...
4
by: Jamey Shuemaker | last post by:
A2k2 with user-level security and all preventive measures, vis a vis, Security FAQ enabled or enacted. I've got three DBs, which due to size constraints can't, or rather, probably shouldn't be...
3
by: timekeepumd | last post by:
Hello, I am running Access 2000 and have 2 databases. From database 1 I need to open database 2. The problem is that I set up user level security using the Access wizard so I have a workgroup...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.