Link to back-end in access 2007

[bodylojohn]

Hello people,

Before I ask my questio I want to let you know that I have searched the forums for an anwser but I just couldnt find it. Or the code didnt work.

What I want is pretty simple for the most of you guys....but not for me. lol

I have a front-end and a back-end.
I want to perform a check if the back-end is still in the same place.
When its not it should promt the user for the new location.

Who can help me please?

 

[David Eagar]

An admin question:

Who or what would move the backend?

More importantly, why?????

 

[Oldsoftboss]

When developing an application, the path to the back end will often be different than that when installed on site, so an easy to use interface is vital. Also networks drop out etc and there are always those "Necessary" IT updates

try the attachment here...

http://www.access-programmers.co.uk/forums/showthread.php?t=115344

 

[David Eagar]

When developing an application, the path to the back end will often be different than that when installed on site, so an easy to use interface is vital. Also networks drop out etc and there are always those "Necessary" IT updates

Not sure if I follow this (or have the skills to challenge your assumptions) but moving from development to production, the tables would need to be relinked Y/N?

IT updates moving a backend is unacceptable - One of my pet hates is changing software to jump through 20 million hoops to 'cater' for human stupidity:

Install it correctly and LOCK IT DOWN - and issue DETAILED Work Instructions on how to use it!

 

[David Eagar]

When developing an application, the path to the back end will often be different than that when installed on site, so an easy to use interface is vital. Also networks drop out etc and there are always those "Necessary" IT updates

Not sure if I follow this (or have the skills to challenge your assumptions) but moving from development to production, the tables would need to be relinked Y/N?

IT updates moving a backend is unacceptable - One of my pet hates is changing software to jump through 20 million hoops to 'cater' for human stupidity:

Install it correctly and LOCK IT DOWN - and issue DETAILED Work Instructions on how to use it!

 

[GaryPanic]

David-

If you work at your company thats great - but if you do design work at home or at a satelite offfice - networks can change
example

G : drive in London
however the Manchester office is set up to H drive - if your designing Manchester system - etc..


if you look at 2 computers installed at the same time etc 9/10 times they are set up differently - over 2 sites with 2 different network engineers setting up networks

- so although you are correct - people get in the way of being normal

- g

 

[bodylojohn]

Can't I just use the transferdatabase method?
My question here is how can I link the entire BE databse?
Or do I have to link table by table producing lots of lines of code???

 

[Oldsoftboss]

Can't I just use the transferdatabase method?
My question here is how can I link the entire BE databse?
Or do I have to link table by table producing lots of lines of code???

Did you download the attachment in the link I pasted? It will do EXACTLY what you want

 

[bodylojohn]

Did you download the attachment in the link I pasted? It will do EXACTLY what you want

Hellow,

The attachement in your link works great.
Accept that I am afraid of using it because I don't understand the code.

Isnt there a simple way to relink?

 

[Rabbie]

Try this link

 

[Oldsoftboss]

If you look at the Db, all the code in a couple of modules, and all you have to change is the number of tables to link (this changes the way the progress bar updates) Import these module into your database.

Then look at the splash form, If I remember rightly the form timer has something like Call RefreshLinks

I will have a look and try to simplify, but dont get too scared.

 

[bodylojohn]

Try this link

Hello,

Thanks for your help.
I tried this but I get an error on 'ahtAddFilterItem'

 

[bodylojohn]

If you look at the Db, all the code in a couple of modules, and all you have to change is the number of tables to link (this changes the way the progress bar updates) Import these module into your database.

Then look at the splash form, If I remember rightly the form timer has something like Call RefreshLinks

I will have a look and try to simplify, but dont get too scared.

I realy love your solution but I am not the kind of guy that just copies everything on his way.
I want to understand what I do.

I would be very very greatfull if you could simplify the code for me.

 

[Oldsoftboss]

I have tried to cut out most of the BS.

Hopefully you can understand a fair bit of it (I dont understand much of the basRetrieveBackEnd), but is reliable and easy to use and customise.

If you copy the table tblDataFile to your Db, and hide it, then if the Split Database Wizard is used, this table will not be moved to the back end. It needs to remain unlinked and in the front end so the front end knows where to look to find the back end database.

The other thing to look at is to edit the number of linked tables you have in the db at the top of the module basRetrieveBackEnd

Dave

Edit: Error in form repaired and new zip attached

 

[bodylojohn]

Thanks for your efforts sofar.

Here is a huge problem...

I am using access 2007 and also using ADO.
The example you provided is using DAO references.

When I start the splash form in my app the following error message appears:
"Can't find object MRHSKeyRegister"

Please help me...

 

[Oldsoftboss]

My bad. The form frmLinkManager has a menu property MRHSKeyRegister. Find and remove this in the form properties and you should be right.

Dave

 

[bodylojohn]

Thank you thank you thank you!
This works perfect.

Thanks again for all of your effort

 

[padlocked17]

Does this work correctly for a Native 2007 format DB opposed to an MDB? I was trying to get this working and with the few brain cells I have firing this late couldn't.

I'll attempt again tomorrow, just wanted to see if you have done it with a 2007 file format?

Thanks.