Results 1 to 7 of 7
  1. #1
    kaschlegel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    10

    What's wrong with my database??


    I made a database on my work computer, and stored it in an "operations" folder on our common drive. It will be used only by one operations agent at a time, and I will collect data from it for my reports. The whole thing works beautifully for me, when I try to access it on my set. When anyone (including me) tries to access it from the operations computer, the main form won't open. We just get a grayed out, blank version of the opening screen. I have the main form set to pop up to the person at the OPS desk, so they wouldnt have to go into anything but the form they need. I was able to access the navigation bar from the ops desk, and open everything except the one main form. Any ideas why this form is a problem, and how I can fix it?
    I did try going back to a back-up version and splitting it, and that didnt work for me, either. It seems like something to do with the macros or security, but i'm very new to making databases.
    Thanks for whatever you can tell me.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you set the Trusted Locations for the operations computer? http://www.btabdevelopment.com/ts/de...aspx?PageId=13

  3. #3
    kaschlegel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    10
    Yes. I just deleted it as a trusted location, and added it back in. I'll try the other set and see if that helps.
    Thank you.

  4. #4
    kaschlegel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    10
    I just realized that I work on two sets, and this one form always opens on the second set. I can't figure out how to get back into design view or get properties up, to see if I can fix that. It might be just off the screen when we use the ops set.

  5. #5
    kaschlegel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    10
    This is the DB that I split, and I can't figure out how to edit the form that's on the front end. It has only datasheet and form view accessible, and I don't see any option for getting design view or properties. From the back end version, I can't even see the form. Is that an easy fix (I hope)?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Can you open the FrontEnd while holding down a <SHIFT> key?

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by kaschlegel View Post

    ...From the back end version, I can't even see the form...
    The Back End component of a Split Access Database is only supposed to contain the raw data, aka the Tables, so not 'seeing the form' is normal and doesn't need to be 'fixed!'

    Do you mean, perhaps, that you can't get Access to display the Tables, themselves, when you click on them in the Navigation Pane?

    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-02-2012, 02:31 PM
  2. What's wrong!
    By khalid in forum Programming
    Replies: 15
    Last Post: 06-27-2011, 06:38 AM
  3. can't figure out what i'm doing wrong
    By m0use in forum Queries
    Replies: 4
    Last Post: 06-16-2011, 09:18 AM
  4. What is wrong with this IFF?
    By bburton in forum Reports
    Replies: 2
    Last Post: 03-16-2011, 10:42 AM
  5. What am I doing wrong?
    By brandon in forum Access
    Replies: 2
    Last Post: 08-03-2008, 10:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums