linked to mdb file had renamed to other extention

[samsul]

Hi, everyone
I have problem I want U help me
I have database linked to another mdb named "D:/Data.mdb"
and then I renamed "D:/Data.mdb" to "D:/Data.myd"

How can all linked table in my front end work eventhoug I had renamed the data file from "D:/Data.mdb" to "D:/Data.myd"

I now it's stupid question, maybe someone can solve this problem,
any help would be appreciated
thank u so much

regards

 

[Mr. B]

Renaming the .mdb to .myd will not prevent you from linking to the tables in the file after you have renamed it. I just tested it here. Just use the Linked Table Manager" and relink your tables to the renamed file. During the process of using the Linked Table Manager, the default in the "Files of type:" in the "Select New Location of ..." dialog box is set to "Microsoft Access (*.mdb) so you will have to change this option buy selecting the "All (*)" option so you can see the renamed file.

 

[samsul]

Than for your help,
but when I use linked table manager and change files of type
I can only see in option
micosoft office acces(*.mdb;*.mda;*.mde)
Dbase 5 (*.dbf); Dbase III (*.dbf);
Dbase IV (*.dbf);Microsoft Excel (*.xls)
Exchange();HTML documents
Outlook();paradox(*.db)
Windows share point services() and
ODBC Databses()
I can't find all files (*.*) and
I actually I want to do this by using code
For changing path of BE file "data.myb"
I use "myb" in orther that user never try many mdb files
Becau mdb is general file and in some pc we can find out them
Than u so much, I always need your help

Regards

 

[Mr. B]

What version of Access are you using. I checked and even Access 2002 provides an "All(*)" option when attempting to locate the file you want to link to.

To relink your linked tables you will need more that just code to change the path to the backend. Here is a link that should provide you with the code you are needing:
http://www.fabalou.com/Access/Modules/refreshtables.asp

 

[samsul]

Thank you Mr, that code only work if we use mdb extention as our BE files
If we use not "mdb" we'll get error message
In past time I had ever found the solve
By using connetion string and then import or linktabel from
BE file, eventhoug I use ".dat". (= I change ".mdb" to ".dat")
But it's my stupid, that code had been loose and
I've forgotten that code I have to rewrite
I'm sorry make U bussy with my stupid question
I wait your help, tank

 

[samsul]

I have progress Mr, I combine using file dialogue
So I can select all tipes of file
to selet BE file I renamed to data.myb and then
I use code to refresh link
You recommended to me
That work fine,


Thank u so much,
I always remeber your help


Regards