If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unable to access database after moving to another computer
We are currently have 3 computers on the network, all
computers have Office XP installed. One computer had an Access database that we used to place all our customer information in. That database was then shared to the other machines using mapped network drives. The drive letter was labeled F:. We recently purchased a new machine that will house all our important files and will no longer have it shareable on the network. We copyed the database to this new computer, but when ever we try to open the database it gives us an error that states "Fatabase.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides." The problem I have is this is not a shortcut to the database, but the database itself. Filesizes match perfectly and we copyed all the files that are in the folder that it was created in. Can anyone give me any advice on this? |
#2
|
|||
|
|||
Hi Joel, A couple of things to look at: Did you map the drive letter F: to the new computer? Alternatively, you can also correct this by refreshing the linked tables to the new location in the new computer. HTH, Immanuel Sibero "joel" wrote in message ... We are currently have 3 computers on the network, all computers have Office XP installed. One computer had an Access database that we used to place all our customer information in. That database was then shared to the other machines using mapped network drives. The drive letter was labeled F:. We recently purchased a new machine that will house all our important files and will no longer have it shareable on the network. We copyed the database to this new computer, but when ever we try to open the database it gives us an error that states "Fatabase.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides." The problem I have is this is not a shortcut to the database, but the database itself. Filesizes match perfectly and we copyed all the files that are in the folder that it was created in. Can anyone give me any advice on this? |
#3
|
|||
|
|||
The new computer will not be on the network and is
actually located in an office that is appart from the main one. There is no way to map a network drive. I am unable to open the database to be able to change anything because of this error. |
#4
|
|||
|
|||
Hi, Joel.
Your database application has some startup automation executing in which it attempts to open a form bound to a table that is located in another database file, which *used to be* stored on the F:\ drive, which is not a valid path on your new computer. On this new computer that is not networked, open this database while holding down the SHIFT key to prevent any startup Form from opening or Autoexec Macro from executing. If Access security has been added, then after you enter the password, hold down the SHIFT key while you're clicking on the "OK" button. Use the Tools menu - Database Utilities - Linked Table Manager to open the Linked Table Manager Wizard. Here, you'll see a list of linked tables and their paths. These paths are likely all identical and, if so, then you can just select the "Select All" button on the right side of the dialog window and then make sure that the "Always prompt for a new location" check box is checked on the bottom left corner before selecting the "OK" button. You'll next browse for a new location for where the database file containing these linked tables is now located on your new computer. If there are differing paths and file names in the Linked Table Manager Wizard list, then you'll have to manually go through the list to make sure that each linked table gets mapped to the new location of the file that contains the table. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. wrote in message ... The new computer will not be on the network and is actually located in an office that is appart from the main one. There is no way to map a network drive. I am unable to open the database to be able to change anything because of this error. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access user profile | Michael Breitsameter | General Discussion | 7 | July 23rd, 2004 07:47 AM |
What do I use to input data thru the Internet to an Access Database? | linda | Using Forms | 3 | July 20th, 2004 07:25 AM |
Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |
In a multi-user database, how to restrict access to records | Bikerman | Database Design | 2 | July 11th, 2004 01:51 AM |
Opening Access database from Excel | Tim Poirier | Links and Linking | 7 | May 11th, 2004 02:10 PM |