Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   How to move Microsoft office 2007 database file to another computer (https://www.askmehelpdesk.com/showthread.php?t=817930)

  • Nov 5, 2015, 08:51 AM
    Eddiemillion
    How to move Microsoft office 2007 database file to another computer
    I have just finished my database and wants to deploy it to another computer.I past it on the c:\user\user\documents directory, when I launch the program I cant log in and I can only see the database though the nav pane, but cant make entries and selection. Please can anyone help me out
  • Nov 5, 2015, 09:02 AM
    ScottGem
    First, is this a stand alone database meaning a single accdb file? Second, did you set up a Trusted Location on the second computer? Do you see an Enable option when the database loads? Third, you said:

    Quote:

    when I launch the program I cant log in and I can only see the database though the nav pane
    Do you have a separate login form? Does that form appear? Do you get any error messages?
  • Nov 5, 2015, 09:42 AM
    Eddiemillion
    Yes I have a form called (Login Dialog) I can select employee list and also enter password but when I press the enter key it does nothing, this happens on the new computer only but I can move around the database freely on the main computer where it was originally created
  • Nov 5, 2015, 10:05 AM
    ScottGem
    Is the login Dialog form set (in Options) as the default form? What is the code behind the after Update event of the password control?

    Did you set the folder as a Trusted Location?
  • Nov 6, 2015, 06:50 AM
    Eddiemillion
    Yes after update I have selected the [Event Procedure] also before update [Event Procedure]
    As for the trusted location I don't know how?
  • Nov 6, 2015, 09:12 AM
    ScottGem
    That doesn't tell me what the code actually is. Event Procedure just tells you there is a VBA procedure behind the event. I need to know what the code is.

    Also Trusted locations are set in File>Options. When you first load the app, it should prompt you to enable the app if its not in a Trusted Location. Did you do that? If not the code you have won't run.

  • All times are GMT -7. The time now is 08:50 PM.