Please Help, How To Stop Database Window Poping Up

Mar 22, 2006

Hi
We have recently upgraded our computers and therefore reinstalled Office on the new machines. The opreating system is Win XP + patch 2. The version of MS Access is 2002

For all our databases I have chosen to hide the database window, so other user don't accedentally change tables and queries etc. Now the problem is, with the new computers, whenever I minize the database and then open it, the database weindow pops up right on top of every thing else automatically.

I have no idea why this happens and how to stop it. Could any one please shed some light. Your help would be apprecialted.

Regards

Airdesign

View Replies


ADVERTISEMENT

General :: How To Stop Users From Ever Seeing Database Window

Feb 28, 2014

I have included some code to disable the access PassKey (holding shift down as you open the database so that the database window appears). It is password protected and it works pretty well for normal users.

However, I have realised that even in this restricted mode you can go to File-Options-Current database and enable Access Keys. This then lets you open the database window by pressing F12.

My question is, is there a way to absolutely stop anyone from ever viewing the database window at all? All my code is password protected, but I still don't want an ICT person fiddling with my tables and queries!

View 4 Replies View Related

Forms :: Command Button - Stop Window From Popping Up

Sep 9, 2014

I created a command button from using the wizard so when I click to delete the record the button is for, a window pops up asking if I am sure I want to delete the record. Is there a way to not have the button pop up?

Here is the code:

Private Sub cmdCompleted_Click()
On Error GoTo Err_cmdCompleted_Click
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord

Exit_cmdCompleted_Click:
Exit Sub

Err_cmdCompleted_Click:
MsgBox Err.Description
Resume Exit_cmdCompleted_Click

End Sub

View 3 Replies View Related

Disable Datasheet From Poping Up After Query Execution

Sep 24, 2007

I am trying to take input for my reports based on a query result dynamically for which i dont want to display the Datasheet after the execution of Query ,inturn i am displaying results in Report. Any help on this would be appreciated.

View 14 Replies View Related

Stop The Editing Of The Backend Database

May 12, 2006

How can you stop people editing the data in the backend database from the linked table in the front end?

The back end is passworded but you can still change data manually from the front end.

Can this be stopped?

View 6 Replies View Related

Database Closes On Save Of Query: How Do I Stop This Happening

Nov 3, 2005

I've got a database, which has been working fine for the last 6 months, it's nt spectacularly large, or complex (abotu 10mb, 15 tables, (5 of which are lookups), about 20 forms, 40 reports, and 30 or so queries).

I've tried to add a new query today, again nothing special:

all comes from one table:
column 1 - group by
column 2 - max
column 3 - if = "No"
column 4 is an expression: iif (a=1,col_a,iif(a=2,col_b,iif(a=3,col_c, .... ))) and so on for 8 col_*'s

The query creates happily enough, and is viewable.
When I try to save it, access shuts down completely with no warnings.

creating the query apart from the last column, saving it then works, but on adding the final column the database shuts down every time.

any ideas? I'm at a loss on this.

Cheers
Kev

View 2 Replies View Related

Database Window Help

Mar 12, 2006

hi

ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables

help any1 pleassse

View 1 Replies View Related

Database Window

Mar 13, 2007

I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?

scratch

View 1 Replies View Related

Database Window?

Apr 14, 2008

This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.

View 6 Replies View Related

How Unhide Database Window

Sep 13, 2006

Dear Friends I made my a stupid mistake and I don't know how to rectify it.

There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is

a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also

I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....

View 2 Replies View Related

Database Window Not Opening

Dec 13, 2006

I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.

I tried that database on 3 different PC's with the same effect.

Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.

Thanks for any help and advice

Josef

View 2 Replies View Related

Hide Database Window

May 9, 2006

I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this?

Thanks

View 5 Replies View Related

Hiding The Database Window.

Jun 20, 2006

Think I've seen this posted on here recently but cant find it.

Is there a way to hide the database window so that only a form is visible?

Then if you need to view the database window you can press F11 to make it appear?

View 1 Replies View Related

Database Window Missing

Mar 29, 2006

Hi,

Can anyone tell me how to display the database window that shows all the forms, queries, tables etc in a database?

I have an Access database with startup restrictions and startup login screen. I can open the database by holding down the SHIFT key to bypass the startup options but when Access opens there appears to be no Database Window. I can create new objects in the database ok its just that there is no main database window from where I can browse objects. This is driving me mad - i know it's probably something simple but I rarely work with access

thanks
Maracatu

View 5 Replies View Related

Hide Database Window

Feb 23, 2007

I am looking to minimize the access window when my database is opened. I already set it to do that from the startup menu, but all that did was open my specified form on open. I want it to actually only show my form w/ acces on the startup tray. Any suggestions?

View 14 Replies View Related

Get The Database Window Back After Hiding It.

Aug 31, 2005

Hi,

I have a question;

If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup


The next time I open the application how can I get them back?

Any help will be very appreciated,
Thanks,
CS.

View 1 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Preventing Access To Database Window

Oct 13, 2005

I have an Access FE app with an Access BE.

I need urgent suggestions as to how to prevent access to the database window even when the SHIFT key is pressed when loading the app.

This is very important so as to increase data security and prevent unauthorised data change by users.

Thanks for the expected response.

Peter
Nigeria

View 2 Replies View Related

Start Up Database Window Problem

Jan 18, 2006

I recently created a database to be posted on a network. In order to eliminate users prying into the mechanics of the database, I unclicked some menus on start up. The database is also password protected. I did such a good job that now I can't get into the database window myself. I used shift while opening the database, which used to work, but now I get the password box which brings me to the switchboard form. F11 doesn't work either.

Does anyone know how I can reverse this process so I can get into my database window and get full menus again?

View 3 Replies View Related

Database Window Not Coming To Front

Sep 15, 2006

This is I think a very simple query.

with a number of forms/ queries etc open and you click on at the back it is not coming to the front for amendment.

It is probably an indicator somewhere but I just can't find it

any help appreciated

Ta

humph

View 3 Replies View Related

Database Window Showing Problem

Feb 21, 2007

Hi All,

I have a database that is locked down with user-level security, and also have my startup settings set so Display Databse Window is unchecked.

This all works fine, and when the user opens the database, the form I want them to see appears, and everything else is locked down.

EXCEPT - if anyone minimizes Access, then maximises it again, the Data Window appears in the windows taskbar!! So anyone can click on it to display it in Access and can view all the macros, forms, tables etc that I've tried to prevent access to! :confused:

Anyone come across this before??

Thanks in advance, dglover

View 2 Replies View Related

Show The Database Window When Closing

May 31, 2007

Hi,

When the user open the database, the database window will be hided. But, when the user close the database with one form opening, it will show the database window for a while, and then close it.

How to prevent the database window to show at the moment?

View 1 Replies View Related

My Database Window Has Half Disappeared!

Aug 2, 2007

Can anyone help with this ANNOYING problem?!

The Database Window within Access on my computer seems to have kinda half disappeared under all the toobars at the top of the screen. Each time i open it it seems to have moved further up. The problem is, that because it is underneath the toolbars, I can't click on the window of it to drag it back down! Now, its got so far up that i can't even select any of my tables, forms, queries or reports because i can't see them!

Its SOOO annoying! and i have no idea what to do about it!

Help please.....:confused:

View 3 Replies View Related

Unable To Access Database Window.

Oct 2, 2004

I have a .mdb that opens up to a form (a splash screen I would assume). However, I can not access the form design view or even get the database window. I thought limiting access to design view was done with .mde, even then you have access to the database window. Any explanation on this or help??

Thanks

View 2 Replies View Related

Surpress Database Window On Print

Dec 27, 2004

Hi all~

I have a few forms that have a command button on them which prints the form utilizing the following code:

Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOfut acSelection
DoCmd.SelectObject acForm, MyForm.Name, False

I have the Database window hidden from the users. However, when the user clicks the button to print the current form, it prints correctly, but it also displays the Database Window.

Is there any way to disable the database window showing up when the print button is clicked?

View 7 Replies View Related

How To Get Database Window To Show In Access2003

Aug 16, 2007

Hi,

I am used to access 2000 but at the moment I am using access 2003. When I first started using it, I had the usual database window showing - by this I mean the one that has the table, forrms etc listed on the left and when clicking on one of them the created tables, forms etc are listed as will as the option to create.

Somehow, this has disappeared. I have made sure that in the startup "Show Database window" is ticked, but after searching the net, have not been able to find any other suggestions as to how to fix this.

Hope some kind person can point me in the right direction so I can see the tables, queries that I have created.

Thank you for your time

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved