Results 1 to 4 of 4
  1. #1
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28

    Missing object references after move to Win7

    I just move an Access DB from Windows XP to Windows 7 - and it stopped working! Lots of missing references to objects, which I cannot find on the system.


    How can I get the references straighten out?

    Help most appreciated.

  2. #2
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Did you change versions of Access? The most likely cause of your problem would be configuration changes to Access and not anything to do with your version of Windows.

    It's generally considered poor programming practice to do this, but there's an option in MS's Visual Basic Studio that lets you use variables without first declaring them. I'd try setting that and see if it helps.

    In Visual Basic Studio, go to the Tools menu and then to Options.
    In the first Tab there, uncheck "Require Variable Declaration".

    If that doesn't help, then you're looking at having to track down each Object manually. . .

  3. #3
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28

    No change in Office version

    Thank you for your quick reply.
    No change in Office version (2010). could it be that some options in Office were not installed on the Win7 machine, and this caused the references issue?
    BTW, I explicitly declare all variables, so I know that is not an issue.

    Also, where are all the ActiveX objects I had on XP? Now I open a form in design mode and get "There is no object in this control", and the list of ActiveX control on teh ribbon is tiny compare to what I had on XP.
    I am obviously missing something! Any ideas?

    Help would be most appreciated.

  4. #4
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Sorry for the delay in responding, but all this stuff comes to my work e-mail so I don't see when someone replies to me after I go home for the weekend

    Just about the only thing you can do now is to go through your code and figure out where the missing References are. The easiest way to do this is to just run the code and, every time you get an error, choose "Debug" to see which variable Access can't find. If you don't have a "Debug" option, just hit [CTRL]+[BREAK] once the error pops up to get it.

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

Similar Threads

  1. Move records between tables
    By rogueakula in forum Access
    Replies: 1
    Last Post: 04-09-2010, 12:35 PM
  2. Open a form using a query that references a combo
    By accessbobp646 in forum Access
    Replies: 1
    Last Post: 02-22-2009, 09:50 AM
  3. DataBase References
    By stormypara in forum Access
    Replies: 1
    Last Post: 03-03-2008, 11:27 AM
  4. Multiple References in one Record
    By bpkcjgorr in forum Access
    Replies: 0
    Last Post: 01-10-2008, 09:29 AM
  5. Multiple cross-references from one record
    By bpkcjgorr in forum Database Design
    Replies: 0
    Last Post: 01-03-2008, 02:33 PM

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