Results 1 to 11 of 11
  1. #1
    windwardmi's Avatar
    windwardmi is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Location
    NewJersey
    Posts
    46

    Access 2007 not opening table in another computer

    I use a DB in two computers or I should say I want to.



    Both computers run windows 7.

    I copied my DB to the new computer and I can not open a table nd related form.

    Any reason why this could happen when it works OK in original computer?

  2. #2
    KrisDdb is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58
    Did u check the ODBC connection on the new computer?

  3. #3
    windwardmi's Avatar
    windwardmi is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Location
    NewJersey
    Posts
    46
    explain please

  4. #4
    KrisDdb is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58
    The backend where the data is actually stored is accessed through an ODBC connection from your computer. If you have just copied your DB to a new computer and not established the ODBC connection to the same backend (as in the first case) from your new computer, then it will not work. Open Access, go to External Data. There you will find the option to either import from/link to an ODBC Database. HTH.

  5. #5
    windwardmi's Avatar
    windwardmi is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Location
    NewJersey
    Posts
    46
    So what should I do first. I will delete all files I copied in new computer.

  6. #6
    KrisDdb is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58

    Post

    Can you post the exact error message that you are getting?

    Also, what is the backend that you use?

    Not that you wouldn't know, but the important thing I would suggest is, back up all your data first, before you try to experiment with it.

  7. #7
    KrisDdb is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58
    Go through this: http://www.brighthub.com/computing/w...les/74858.aspx

    p.s: I assumed you have a SQL Server backend. If otherwise, do post the details.

    Paul and Alan have helped me out with my question. Am sure theres many more like them here to help you with your problem.

    HTH

  8. #8
    windwardmi's Avatar
    windwardmi is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Location
    NewJersey
    Posts
    46
    I used a DB from Microsoft Press - "ACCESS 2007 Inside Out".

    CONTACTs DB to be exact and modified it for my company.

    Never had SQL or Backend or Frontend.

    Where is ODBC and how can I find out where it is so I can copy.

  9. #9
    windwardmi's Avatar
    windwardmi is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Location
    NewJersey
    Posts
    46
    I created a BE and FE. Copied the FE to new computer and used linked table manager to direct to BE.

    This works fine now. As long as I'm connected to the home network.

    What if I'm at another office? How can I run DB?

  10. #10
    KrisDdb is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    58
    Glad its working out for you for now.

    When you are at a different office, what you normally do is to take remote access to the network on which the DB is present through the 'Remote Desktop Connection' feature. This is available through the 'Accessories' from the start menu. You need to know your Domain name and User credentials for this beforehand. You might want to ask your IT administrator/technician for these specs if you are not aware of them.

    Once you are connected to the system on the network, you can now access the DB from your current computer. HTH.

  11. #11
    windwardmi's Avatar
    windwardmi is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Location
    NewJersey
    Posts
    46
    for now I will consider this solved.

    Thanks

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

Similar Threads

  1. Replies: 16
    Last Post: 07-20-2011, 08:01 AM
  2. Replies: 0
    Last Post: 01-22-2011, 08:08 AM
  3. Opening Database between 2007 and 2000
    By jo15765 in forum Access
    Replies: 19
    Last Post: 11-21-2010, 06:46 PM
  4. Replies: 32
    Last Post: 09-16-2009, 10:06 AM
  5. MS Access DB will not open on new computer
    By Lunchbox in forum Access
    Replies: 3
    Last Post: 08-18-2009, 09:28 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