connect to the right be-db

[TeeVee]

I have build an app with a fe and a be.
i want the app to use the be-db from the location where the fe and be-db are placed.
using some code with connecting a db and relink the tables workes fine in the std app.
But when i generate a .fe.mde the old be-db is still used in spite of the code for reconnecting.
i am using A2k.
What do i need to do more so the fe.mde will use the correct be-db?

 

[prley]

I have build an app with a fe and a be.
i want the app to use the be-db from the location where the fe and be-db are placed.
using some code with connecting a db and relink the tables workes fine in the std app.
But when i generate a .fe.mde the old be-db is still used in spite of the code for reconnecting.
i am using A2k.
What do i need to do more so the fe.mde will use the correct be-db?

If I understand your question. Your putting a new version of the front end out but it still looks back at your local drive for the data instead of the new location.

I usually move the back end database pn my local machine when I put a new version in since I don't usually do that many changes. That way the Front end won't find the back end data and automatically run the re-link code and find the back end data in it's new directory ie same new dir of the newly compiled Front end.

 

[boblarson]

What code are you using for reconnecting? I know this one is good:
http://www.jstreettech.com/files/JStreetAccessRelinker.zip

 

[TeeVee]

Thanks for the ideas and quick responses. I used some code i found in forums. I delet all linked tables at closing the app. I coded the connectionstring as flexible as i think is needed (eg strconnectionstr= application.current.projectpath & new db name) and that is before i use(i think) a be-db.
But it seems to me there is a diffrence between the .mdb file and the generated .mde file because in the mdb file it links correct but not in the .mde file. Maybe it is in the close and reopen db thing, i will try that.