Copying files from outside sources

[Lou_Reed]

I copied a MS Access 2010 file from a network S drive onto my desktop of my personal computer. Everything seemed to work fine.

However, when I tried to open the file once I had pasted it on my desktop I got the following error message.

c:\users\michael.oldford\database.project\11-16-2016\Divsion_Dashboar_.datafile.accdb\ 

is not a valid path. Make sure the path is spelled correctly...

They are correct it is not the path I have for the file on my computer. I have never heard of this path and it certainly is not leading my desktop nor have I heard of the person connected with it. I just copied and pasted the file onto my desktop. How do I correct this error? It seems that somehow that I must change the path definition of the accdb file or change my path on my computer.

I choose the former.



How do I change the path that is displayed above for the correct one on my computer.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[aytee111]

It may be a table that is linked to that database. Does the database open?

[Lou_Reed]

Yes, the database opens, but I get this message immediately on opening the database.

What is going on. I can use the db after I click away the error. Why am I getting the error?

Any help appreciated.

Respectfully,

Lou Reed

[aytee111]

No linked tables?

[Micron]

It would be strange to have a front end on the network and the back end on a local C drive with the tables linked to the local drive. Not impossible - just would be a bad idea to run an FE over a network. Since you got the file from the network drive, label S, it is possible that code is running in a front end that you copied, trying to validate that the FE has not been copied and placed on some other local drive. Maybe someone there knows who Michael is and can shed light on what might be going on. Or find out if code is running and take if from there. It can be triggered by an AutoExec macro, or a form that is set to open on startup.

[aytee111]

I run into this all of the time - people using a network database and linking to files on their own drives, could be Excel files or anything. Many companies do not believe in (or understand) FE/BE setups.

[Lou_Reed]

Okay, but how do I remove this outdated path from my Access 2010 file on my laptop? It is messing up everything! Any form or table which I open sends this error message out.

It would be great if it did not do that. That path that it shows is clearly not mine. So how do I remove it?

Thanks in advance.

Respectfully,

Lou Reed

[Micron]

Suggestions were given or implied in posts 2, 3 and 4. You need to address those and advise accordingly.

[Lou_Reed]

When I moved the MS Access 2010 database from the network server to my laptop personal computer, the table and forms in the database opened up the with path error message as seen in the first post. They still had the path for the Access db file that was on the server; that is now out of date.

That clearly is the incorrect path and the software gives an error message as explained above. Now, must I remove the path for each form and table? Or is there a way to do it en mass so to speak so this old outdated path is gone from the whole database? The preferred way is the later so if it can be done explain how to delete this path in one stroke. If I must do it for each form and table then explain how to do it that way.

Either way I just want that old, outdated path out.!

Any help appreciated. thanks in advance.


Respectfully,

Lou Reed

[davegri]

Hover the mouse cursor over the table names in the navigation pane. The popup reminders will show the path to each table. Either delete the table (may not be a good idea) that is not on your computer or copy it from the indicated path to your computer. If it is an Access table, you can import it.

[Lou_Reed]

I tried that. I hovered the mouse cursor over the first table. It gave me the old path when I did this. A menu dropped down with the option "import" on it. I chose that option.

A dialog window opened up with two choices import to a path or link. I chose the import to a path it was C:/users/lou.reed/documents. When I clicked okay it said the file does not exist.


but it was a path not a file! Thus I carefully created a path like this C:/users/lou.reed/ms_access_database_files

again this is not a file it is a path. When I clicked ok (after putting this path in as the top/first option in the popup dialog) the error says the file "C:/users/lou.reed/ms_access_database_files" does not exist.


Again this is a path not a file! I assume that I am doing everything correctly until I select path and then click ok. It says path does not exist.


It does not like what I put in.


What am I doing wrong?


Respectfully,



Lou Reed

[Micron]

It would seem that we've assumed you're aware of the linked table manager and would invoke it on your tables per the previous suggestions. In my version, that is opened via the Database Tools on the ribbon. You open it and use its controls to navigate to the new source db that contains the tables you need. This should take care of all table links at once. You shouldn't need to do anything for forms or reports.

[Lou_Reed]

In post number 10 it sounded like you were suggesting doing it a table or a form at a time. I will try this new approach in the last post. May I have a link that discusses this procedure in more detail.

Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, I found the linked table manager for the db in question. I selected all of the tables and now what do I do with it?

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[davegri]

In the linked table manager, click the checkbox for the lost table.
Click the checkbox for Always prompt for new location
Click OK and the file dialog will open. If you don't know where the file is located, you're stuck.

The table manager give the table name as the text on the left. Sometimes that an excel spreadsheet, sometimes a text file and sometimes a table in an Access database.
If it's a table in an Access database then you specify the database name, not the table name in the file dialog. If you don't know which database the table is in, you'll have to open each one and look at it's tables.