I've done something and now nothing works HELP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CD Tom
    Contributor
    • Feb 2009
    • 495

    I've done something and now nothing works HELP

    I don't know what happened but let me see if I can explain.
    I have a skydrive, I copied my access program and database to the skydrive. I was doing some work on the program and went to Make accde it created the accde program but when I run it the basic program comes up but there is no database connected. If I go back and open the accdb everything comes up fine. I've look at the link master and the database show up there like it's should. I've even relinked the database and that doesn't help with I run the make accde and run it.
    I don't know if the skydrive has anything to do with this, but that's the only thing I can think of.
    If anybody has any ideas I sure could use them.
    Thanks
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    I'd bet that it is because of the security issues.

    Try the following:
    Move your ACCDE to a folder on your local drive.
    Move the back end files to that same folder on the local drive.
    Now start your ACCDE file and re-link the tables to the local copy.
    Tell us what happens.

    Comment

    • CD Tom
      Contributor
      • Feb 2009
      • 495

      #3
      The problem is that nothing works in the accde program I have a relink module in the program but when I bring it up and try to run it nothing happens. Is there another way to relink from the ACCDE program? My program has a feature that if it can't find the database it will ask for the location and then do a relink. When I rename the back end file to something else and start the program it doesn't even know the file is missing. I spent most of the day yesterday trying different things and found that if I start with a blank database and using the External Data and import all the data from the file ACCDB file that I was having problems with I was able to get the problem solved. I still have the problem ACCDB file so I can still try different things.
      Thanks

      Comment

      • zmbd
        Recognized Expert Moderator Expert
        • Mar 2012
        • 5501

        #4
        1) Please do as I have asked. It is very importaint to know if the file is being blocked due to the inbuilt security or there is some other issue at work here.

        2) To determine if there is an issue with your program: please go to the following thread: Can I connect my database(...) I have a database in post#7 that you should download and unpack to a LOCAL drive directory. Start the the ACCDE front end and report back any errors.

        3) We'll need to see the code behind your relinker before we can help you; however, please read and follow this first: > Before Posting (VBA or SQL) Code

        4)
        (Post#1)(...) If I go back and open the accdb everything comes up fine. (...)
        (Post#3)(...) External Data and import all the data from the file ACCDB file that I was having problems with I was able to get the problem solved. (...)
        Here you have me confused.
        Are you refering to the same files here?
        In Post#1, I thought you were refering to the front end file that you created the ACCDE from; however, now it seems like you have switched up what it you're working on.
        Is the new ACCDB on the local drive or the skydrive?
        Last edited by zmbd; Mar 6 '13, 02:13 PM. Reason: [z{added #4}]

        Comment

        • CD Tom
          Contributor
          • Feb 2009
          • 495

          #5
          Ok, I moved the ACCDE and the Back end to a new folder when I run the program I get the same thing I don't know how to relink from the ACCDE I don't have any options to relink. Can you explain how I should do this?

          Comment

          • zmbd
            Recognized Expert Moderator Expert
            • Mar 2012
            • 5501

            #6
            Hmm, could still be a security thing; however, I doubt it at this point.
            Please go ahead and work thru the remaining requests in my last post.

            Comment

            • CD Tom
              Contributor
              • Feb 2009
              • 495

              #7
              Let me see if I can explain this better. The original program ACCDB connected to the back end works fine I can make modifications and everything looks good. I then make the ACCDE and with I run it the main menu of my database comes up but none of the buttons I have on the main menu do anything, also the main menu comes up larger than the normal one on the screen. I do have a relink in the program but because none of the options I have on the main menu I can't select it.
              So what I did was to create a blank database and using the external data on the new database I linked to the original DB and imported all tables forms reports macros and modules into the new DB. I add all the references that the original DB had. I then tested the new DB and it worked fine, so I created the ACCDE from the new DB and when I ran it the program worked as normal.
              I hope this explains better what happened and how I corrected the problem.
              I tried many different ways until I came up with this one. In the original program before creating the ACCDE I could relink the DB, I tried renaming the DB to something else and then relinking it but when I created the ACCDE and run it I would get the same problem.
              Thanks for all your help I've looked and your other posts and will try some of those.

              Comment

              Working...