Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Reconnecting (?) a database (2000)

    Over the past few weeks, I've posted many questions about the database I was building for a college foundation fundraiser auction. I take this opportunity to thank all of you who shared your knowledge to help me with this project. HansV, Charlotte, Wendell, Shane, Mark Liquorman...I'm sure I haven't named everyone who responded to my cries for help, but rest assurred that I am very grateful to you all. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> By the way, the event was a big success, and the users were pretty impressed with the DB.

    One more question: The event is over, and now we need to update some of the records. Here's the problem: We built the DB at one location using desktop computers. Then we took a copy of the unsplit DB to the site, where we loaded the DB onto one laptop computer. Next we split the DB and put a copy of the FE onto three other computers. Then we networked the four machines with a wireless connection. The fellow who set up the network mapped the DB to a "z:" drive.

    That setup worked beautifully. At the end of the event, we removed the entire setup from those four laptop computers--they were borrowed from the college, and we needed to return them to their pre-event state. Of course, we kept a copy of everything: FE and BE. We brought the copy back to our natural habitat and put it all back onto a desktop computer. To be more precise, we put both FE and BE into a folder on our local shared directory, s:brcc.

    We can open the BE, and we can open the FE. We can add and modify records directly in the tables in the BE. Trouble is, when we try to open a receipt (a report), we get an error message about how "z:xxxx... is not a valid path...." Seems the DB still "thinks" it's working with the wireless network we used Saturday night. There's no more Z: drive, but I can't figure out how to convince the DB to work. The guy who set up the wireless network can't figure it out either. What now?

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reconnecting (?) a database (2000)

    Open the FE, Select Tools|Database Utilities|Linked Table Manager.

    Click the Select All button, check the Always prompt for new location check box. Click OK and browse to the BE.

    Done.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Reconnecting (?) a database (2000)

    Done indeed! That's a lot simpler than I'd thought it would be. Thanks a heep!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •