I enjoyed the code provided there:
http://www.mvps.org/access/tables/tbl0009.htm

but:

1)I don't know how to avoid the message that the database shows when starts
up and don't find the linked table!: Could not find <back end database path>

2) what's the best way to launch a Function when the database starts?
in my case the function is "fRefreshLinks()"

Autoexec - is a right one. if you call this function in Autoexec - then it
will relink tables before any form opened - so you get rid of "Could not
find <back end database path>" message

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"Double" <(E-Mail Removed)> wrote in message
news:6DA88199-8CF0-4971-914B-(E-Mail Removed)...
>I enjoyed the code provided there:
> http://www.mvps.org/access/tables/tbl0009.htm
>
> but:
>
> 1)I don't know how to avoid the message that the database shows when
> starts
> up and don't find the linked table!: Could not find <back end database
> path>
>
> 2) what's the best way to launch a Function when the database starts?
> in my case the function is "fRefreshLinks()"
>
>

Hi Alex,

I have been trying to run the code found at
http://www.mvps.org/access/tables/tbl0009.htm

I keep getting an error saying I haven't defined the type. I am assuming I
haven't got the appropriate object library or type library ticked. Do you
know which libraries are required to run this code?

Also, my issue is that on my computer a drive is mapped to my Q drive, some
other users have S drive, others have P etc etc. When I link a table is
obviously references the Q drive, I am struggling.......

If my locations don't change, and I just want the linked tables to point to
the actual server address, is this possible?

Thanks

Neil

"Alex Dybenko" wrote:

> Autoexec - is a right one. if you call this function in Autoexec - then it
> will relink tables before any form opened - so you get rid of "Could not
> find <back end database path>" message
>
> --
> Alex Dybenko (MVP)
> http://alexdyb.blogspot.com
> http://www.PointLtd.com
>
>
> "Double" <(E-Mail Removed)> wrote in message
> news:6DA88199-8CF0-4971-914B-(E-Mail Removed)...
> >I enjoyed the code provided there:
> > http://www.mvps.org/access/tables/tbl0009.htm
> >
> > but:
> >
> > 1)I don't know how to avoid the message that the database shows when
> > starts
> > up and don't find the linked table!: Could not find <back end database
> > path>
> >
> > 2) what's the best way to launch a Function when the database starts?
> > in my case the function is "fRefreshLinks()"
> >
> >
>
>

Hi,
libraries - you need to make sure that you have a reference to DAO

mapped drives - you can use UNC name like \\MyServer\\MyShare\Folder\my.mdb

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"NeilGel" <(E-Mail Removed)> wrote in message
news:7B1A3CD8-9B79-4C65-9DC8-(E-Mail Removed)...
> Hi Alex,
>
> I have been trying to run the code found at
> http://www.mvps.org/access/tables/tbl0009.htm
>
> I keep getting an error saying I haven't defined the type. I am assuming I
> haven't got the appropriate object library or type library ticked. Do you
> know which libraries are required to run this code?
>
> Also, my issue is that on my computer a drive is mapped to my Q drive,
> some
> other users have S drive, others have P etc etc. When I link a table is
> obviously references the Q drive, I am struggling.......
>
> If my locations don't change, and I just want the linked tables to point
> to
> the actual server address, is this possible?
>
> Thanks
>
> Neil
>
> "Alex Dybenko" wrote:
>
>> Autoexec - is a right one. if you call this function in Autoexec - then
>> it
>> will relink tables before any form opened - so you get rid of "Could not
>> find <back end database path>" message
>>
>> --
>> Alex Dybenko (MVP)
>> http://alexdyb.blogspot.com
>> http://www.PointLtd.com
>>
>>
>> "Double" <(E-Mail Removed)> wrote in message
>> news:6DA88199-8CF0-4971-914B-(E-Mail Removed)...
>> >I enjoyed the code provided there:
>> > http://www.mvps.org/access/tables/tbl0009.htm
>> >
>> > but:
>> >
>> > 1)I don't know how to avoid the message that the database shows when
>> > starts
>> > up and don't find the linked table!: Could not find <back end database
>> > path>
>> >
>> > 2) what's the best way to launch a Function when the database starts?
>> > in my case the function is "fRefreshLinks()"
>> >
>> >
>>
>>

On Mon, 4 Jun 2007 22:15:01 -0700, NeilGel <(E-Mail Removed)>
wrote:

>If my locations don't change, and I just want the linked tables to point to
>the actual server address, is this possible?

Just to add to Alex' suggestion - you can use the file location dialog that
the linked table manager will bring up; the trick is to navigate via Network
Neighborhood, not via the mapped drive names. This will store the UNC path in
the tables' connect strings, and other users with different mappings will be
able to connect without having to re-find the backend.

John W. Vinson [MVP]

Thanks John, tried your suggestion which worked perfectly.



"John W. Vinson" wrote:

> On Mon, 4 Jun 2007 22:15:01 -0700, NeilGel <(E-Mail Removed)>
> wrote:
>
> >If my locations don't change, and I just want the linked tables to point to
> >the actual server address, is this possible?
>
> Just to add to Alex' suggestion - you can use the file location dialog that
> the linked table manager will bring up; the trick is to navigate via Network
> Neighborhood, not via the mapped drive names. This will store the UNC path in
> the tables' connect strings, and other users with different mappings will be
> able to connect without having to re-find the backend.
>
> John W. Vinson [MVP]
>