Hi, as an attempt to improve database performance, I have split a MS Access 2003 database. I have successfully split the database and saved the backend onto the server. My question is, where is the front end. or do I have to create it?
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 need help making a front and back end to my database. How should I do it!?!? All I know is what I should put in the front end and what goes in the back end. The rest needs to be explained to me somehow...
What is the best solution for sharing a front end DB as me having the BE installed at my pc, giving all user the FE and then refreshing table link with BE installed at pc but the problem is that the shared FE becoming slow any option ? as only 5 users using this at a time.
I have a database system into the back end and front end and then created the accde file with the front end file to give this to users on their computer. The back end being placed on a server with a path of type servernamefolder..I have used the Linked Table Manager to point to the tables server name folderfilename.accdb
but in doing this I get a message Windows cannot access servernamefolder..is this to do Network Rights on the server that I don't have permission to access the server and folder.
I have a split database. When the front end db is updated, i am attempting to delete the end users copy and replace with the updated version.
I have gotten as far as being able to open Database A, Open Database B with A and Close Database A, but it will not let me delete Database A from B because the procedure originated from Database A.
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.
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?
I created a database in Microsoft Access and then upsized it to SQL Server afterwards.
I now need to add a new column to a table in the database. So I added the new column in SQL Server using ALTER TABLE command. This column is a foreign key which has an associated parent key in another table which contains a description of the column. e.g. Main_Table Case_ID Foreign_Key_Field_ID 1234 78
New_Foreign_Key_Table Foreign_Key_Field_ID Foreign_Key_Field_Desc 78 Describes the ID 78
I also setup a CONSTRAINTREFERENCE between the fields in these 2 tables.
I then relinked my tables using the Linked Table Manager to pick up the change to the table I altered (Main_Table). I also linked to the new table I created (New_Foreign_Key_Table).
My problem: In Access if I create a new table I can select the lookup value for a field in the Table Design view Lookup tab. However, I altered my table in SQL Server and then linked to it again to pick up the change. Now when I view the linked table in Access it does not have any lookup value AND it's not possible to change this for a linked table.
Is there some piece of SQL I can use in SQL Server to change the lookup value for the field in my table OR have I approached this the wrong way. Should I have modified the local table in Access and upsized it again?
Otherwise if I select all values from my Main_Table in a form it displays the Foreign_Key_Field_ID instead of the Foreign_Key_Field_Desc because the lookup value has not been set to Foreign_Key_Field_Desc
This posting is a bit long - I hope it makes sense.
Any ideas or suggestions would be greatly appreciated.
I've prepared a front end database with forms that allow data to be keyed into linked tables to my main databse.
However, currently the front end database only allows 1 user to do it at 1 time and when another user tries to open the file, an error "The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked'
Is there anyway to allow multiple users to use the front end database at the same time?
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?