Using Access 2003 on XP. I have created a frontend/backend application that
will likely be installed on a network. The user will save the backend to a
network location (which I will not know the address of beforehand). I would
like a way to programmatically ask the user when they open the frontend where
the backend is located, and update the linked tables accordingly. A windows
explorer type dialog box would be ideal, simply navigating to the backend.
Is this possible? Thanks in advance.

Adam Milligan

Download Microsoft's sample database - solutions.mdb - from:
http://support.microsoft.com/kb/248674

There's a module in the database that does what you want. Checks the back
end on start up. If it's not present, it pops up the FileOpen dialog for the
user to locate it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Adam Milligan" <(E-Mail Removed)> wrote in message
news:9447085F-9F00-47FE-9B85-(E-Mail Removed)...
> Using Access 2003 on XP. I have created a frontend/backend application
> that
> will likely be installed on a network. The user will save the backend to
> a
> network location (which I will not know the address of beforehand). I
> would
> like a way to programmatically ask the user when they open the frontend
> where
> the backend is located, and update the linked tables accordingly. A
> windows
> explorer type dialog box would be ideal, simply navigating to the backend.
> Is this possible? Thanks in advance.
>
> Adam Milligan

Adam.

Or have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

Peter Hibbs.

On Wed, 30 May 2007 21:25:01 -0700, Adam Milligan
<(E-Mail Removed)> wrote:

>Using Access 2003 on XP. I have created a frontend/backend application that
>will likely be installed on a network. The user will save the backend to a
>network location (which I will not know the address of beforehand). I would
>like a way to programmatically ask the user when they open the frontend where
>the backend is located, and update the linked tables accordingly. A windows
>explorer type dialog box would be ideal, simply navigating to the backend.
>Is this possible? Thanks in advance.
>
>Adam Milligan

And just to be different, there's
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web". <g>

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Adam Milligan" <(E-Mail Removed)> wrote in message
news:9447085F-9F00-47FE-9B85-(E-Mail Removed)...
> Using Access 2003 on XP. I have created a frontend/backend application
> that
> will likely be installed on a network. The user will save the backend to
> a
> network location (which I will not know the address of beforehand). I
> would
> like a way to programmatically ask the user when they open the frontend
> where
> the backend is located, and update the linked tables accordingly. A
> windows
> explorer type dialog box would be ideal, simply navigating to the backend.
> Is this possible? Thanks in advance.
>
> Adam Milligan

Or, what I do is hold the location info in an INI file held in the same
directory as the application, and on opening up the firs form, reading the
INI file and attempt a reconnection at that point.

This means the user dosn't have to know where the data is located, and if
you decide to upsize to SQL server, you can enter the ODBC connection string
instead

HTH
Chris

"Adam Milligan" wrote:

> Using Access 2003 on XP. I have created a frontend/backend application that
> will likely be installed on a network. The user will save the backend to a
> network location (which I will not know the address of beforehand). I would
> like a way to programmatically ask the user when they open the frontend where
> the backend is located, and update the linked tables accordingly. A windows
> explorer type dialog box would be ideal, simply navigating to the backend.
> Is this possible? Thanks in advance.
>
> Adam Milligan

I found Doug's solution fit my needs the best. Thanks!

"Douglas J. Steele" wrote:

> And just to be different, there's
> http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web". <g>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Adam Milligan" <(E-Mail Removed)> wrote in message
> news:9447085F-9F00-47FE-9B85-(E-Mail Removed)...
> > Using Access 2003 on XP. I have created a frontend/backend application
> > that
> > will likely be installed on a network. The user will save the backend to
> > a
> > network location (which I will not know the address of beforehand). I
> > would
> > like a way to programmatically ask the user when they open the frontend
> > where
> > the backend is located, and update the linked tables accordingly. A
> > windows
> > explorer type dialog box would be ideal, simply navigating to the backend.
> > Is this possible? Thanks in advance.
> >
> > Adam Milligan
>
>
>