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??
I have created a database in Access 2010 and I am not able to open the same database in Access 2007. I have read somewhere that it is possible to open. I get the message, " Unrecognized database format". In Access options, the default file format is, "Access 2007".
Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances.
Most functionality appears to be working ok...
Many of my database objects, especially queries, were given meaningful descriptions.
For example, a number of queries might have been described as "Accounts Data Validation".
When I wanted to run validation of the Accounts data, I would simply sort the database queries window by description, then scroll to the relevant section and run all of the tagged queries in turn.
However, having migrated to Access 2013, although the descriptions are still shown, I can no longer sort by them !
Medium term, I could probably assign different database objects to "Groups", but we are talking hundreds, perhaps even thousands of different objects and that would be a laborious and extremely tedious process.
Any way of sorting the database window by description in Access 2013 ?
I have tried to create an MDE database and receive the message "Microsoft Access was unable to create an MDE database" I deleted all unnecessary tables, queries, forms and reports and still receive this message.
I have upsized from Access 2003 to SQL Server 2008 R2 using upsizing wizard. Everything works fine. But I don't see relationship in SQL SErver 2008 R2 if I go to database. But I set relationship in Access 2003 before upsizing it.
Amso I don't see relationship (diagram) in Access 2003 , which I was able to see before.
So do I need to again recreate the relationship amongst the table in Access 2003 Or SQL SErver 2008 R2 ? I thought, if you link tables, everything should be taken care but i don't see relationship structure any more.
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
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?
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.
I have two databases. One is 'live', one is for development. Once i get something working in the latter, I import it into the former. This has been working fine for just over two months.
Today, however, i'm trying to import a form and get one of the following messages:
I have created a database with approx ten tables with many queries (make table and append and delete queries). I need to compact this database as I would normally do (usually deal with databases of 500MB and more with no issue) however after over an hour I still get the message 'not responding'. I have tried creating a new one from scrath and get the same issue. Can anyone help please?
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....
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.
I have found myself with a big problem, One of my databases has managed to become rather large in size, 1,084,576kb
Unfortunatley i am unable to compact the database, as i get the following error on compact "record(s) can't be read; no read permission on L:database name"
The size of the database now seems to be the reason why reports and queries are failing,
I have tried "database utilities" Repair Database - and this has no affect. I have also tried temporally removing some of the tables and queries into another database, but the Db size remains the same.
Does anyone have any ideas as i'm stumped? p.s. the database in running on ACCESS 97
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
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?
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...
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?
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.
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:
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?