Linked Tables

S

samdert

Help:

I had someone help me write a database. I was told me that it could be
installed on my network. When I tried to install it, the application would
not write to the data file nor would it open the data file.

I realized that the programmer had a linked the tables to the c: drive. The
app file and the data file are in the same folder. How do I change it so
that the linked tables don't look for a specific drive?

Thanks
 
D

Douglas J. Steele

Try using the Linked Table Manager. Where you find it depends on what
version of Access you're using. In Access 97, it's under Tools | Add-ins. In
Access 2003 (and I believe 2000 and 2002), it's under Tools | Database
Utilities.
 
D

Damien McBain

Douglas said:
Try using the Linked Table Manager. Where you find it depends on what
version of Access you're using. In Access 97, it's under Tools |
Add-ins. In Access 2003 (and I believe 2000 and 2002), it's under
Tools | Database Utilities.
Click to expand...

I think he wants to specify the directory relative to the db directory
rather than a whole path. I'd be interedted to know this myself.
 
S

samdert

Here's the deal. I'm installing this database on to a bunch of different
networks. It's in Access 97. I tried to go into each location remotely and
update the tables using the Linked Table Manager, but the option is not
available nor is the Add-Ins option.

Are there any other ways to accomplish this without using the Linked Table
manager?
 
D

Douglas J. Steele

Damien McBain said:
I think he wants to specify the directory relative to the db directory
rather than a whole path. I'd be interedted to know this myself.
Click to expand...

You can't. Best you can do is put logic into your application to determine
where the application is located, and thereby determine where the backend
should be located. If you're not linked to the location you just determined,
relink.
 
S

samdert

I really have no idea how to do any of that. The application file and the
data files are called :
BSIDbApp
BSIDbData

They are in a folder called "BSI Database"

Any suggestions?
 
D

Douglas J. Steele

Can you go back to the person who wrote the database for you, and ask
him/her to incorporate that important capability which he/she left out?
 
S

samdert

I have, but he hasn't gotten back to me. He was helping me out in his spare
time and I can't guarantee that he'll get my e-mail. Additionally, I'm
eating crow. Due to my lack of knowledge of my network and databases in
general, I inadvertently gave him incorrect information about the way that it
was going to be installed and now I think he may not want to help me out with
this one. Can't blame him.
 
B

Brendan Reynolds

I have an example MDB including re-linking code that you can download if you
like. Do please note, though, that this is a free, and therefore
unsupported, example. It will take some work to figure out what the code is
doing and to modify it for your needs.

That said, if you want, you can download the example at the following URL
http://brenreyn.brinkster.net/bjecap02.zip

After extracting from the zip file, to see the code, open the MDB while
holding down the Shift key to bypass the startup code, then open
'frmStartup' in design view and look at the code in the Timer event
procedure.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
B

Brendan Reynolds

Sorry, like I said, free and therefore unsupported.

If you have a specific question about part of the code in the example,
though, feel free to ask the question here and to post the relevant code
along with the question. I have a copyright notice at the top of each
module, but that's just there to prevent anyone else from claiming copyright
on it and preventing me from re-using my own code. Other than that, I don't
mind what you do with it.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top