Database Splitter -table link issue

[Robert Robinson]

I created my database application on one machine, then split the database on
that machine. I then moved the front and back ends to another machine (this
will be the standalone machine that will house the application).

When I tried to open up the front end, it told me that I could not find the
back end because it was still looking for that back end in its old location
(on the machine where it was created and split). Ok. I then tried to run the
link functions; I could not run it from the front end, because the
application would not open in the first place, and I could not run the link
from the back end, because no tables exist in the front end.

I re-split the application on the new machine, but it left me with a
question: given the above scenario, is there a way to re-link the front and
back ends on a different machine with different file locations? It seems that
there should be some backdoor way, I just can not find it.

 

[Allen Browne]

Microsoft has a sample database named solutions.mdb. It contains a module
that checks the data on startup, and if not found pops up the File Open
dialog so the user can locate the file, and the sets the Connect property of
each TableDef.

You can download it from:
http://msdn.microsoft.com/library/officedev/bapp2000/mdbdownload.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news[email protected]...

 

[Douglas J. Steele]

There's also similar code at http://www.mvps.org/access/tables/tbl0009.htm
at "The Access Web".

As to not being able to open your front-end because the tables weren't
properly linked, try holding down the shift key while you're opening the
database. You might have some code that runs on startup that's failing due
to not being able to find the tables, and holding the shift key down should
bypass that code.

 

[Robert Robinson]

I KNEW there was something that I was forgetting (the shift key)...that did
the trick.

Thanks.