Please Help Me

[Rich]

I have developed an aplication in Access 2002 to deploy
to a customer of mine including Access runtime. My
customer insists on having the front end on a local PC
and the back end on a server so they can auto backup
every day. I have designed and split my database. The
problem is that I need a way to reconnect my linked
tables once I move the back end to a server. Is there a
way to run the Linked table wizard with runtime? Or is
there a way to emulate it with VBA code? Or is this
something that can be done with runtime?

 

[Cheryl Fischer]

There is code available at The Access Web to do this:

http://www.mvps.org/access/tables/tbl0009.htm

I use it in all my apps and it works very well.

 

[Rich]

Cheryl
Thank you so much for responding.
I am some what new with VBA code. I tried the example you
supplied the link to but I couldn't get it to work. I am
useing Access 2002 to develope my app. Do you need to
modify the code or does it work "as is"? You have given me
a starting point but I may need just a little hand holding
to get to where I need to be.
Thank you again for your help

Rich

 

[Cheryl Fischer]

Rich,

After you copy all of the code to a public module, the code should run
"out-of-the-box". You will need a form with a command button on it. Behind
the Click Event of the button, just use the following code:

fRefreshLinks

If you still have problems with it, please post back with the error
message(s) received or describe the behavior that occurs when you attempt to
run the code.

 

[Guest]

Cheryl

When I try to run the code I get the following error

Compile error:
User-defined type not defined

And the following line in the code is highlighted

Function fIsRemoteTable(dbRemote As Database, strTbl As
String) As Boolean

Rich

 

[Cheryl Fischer]

Based on the error you report, I suspect that you are missing a reference to
the Microsoft DAO 3.6 Object Library.

 

[Rich]

Thanks again Cheryl you have been a big help.
You were right on the money with the DAO 3.6.
Unfortunatly I have one more error to contend with but I
have been out of town for a couple days and my DB is on
my coputer at work. If I dont figure it out I will try to
post exact information here on monday
Rich

 

[Cheryl Fischer]

OK. I'll keep this thread marked.