Hello,

i'm new to this forum and new to Access Developer tools so i'm hoping I
could get some quick assistance. I don't even know if this is possible but...

I've created a database in Access 2007 and I've downloaded the developer
tools because I'd like to distribute this small DB to a select group of our
users so they can share the data. In creating the package installation it
asked about Root Install Folder (local). I've also opted to automatically
install the Access 2007 Run-Time. My plan is to have this DB used by about
30 users and I'd like for them to be able to share this data. The default
pkg requies that the access DB installs locally to the client. What I'd like
to be able to do is create a network folder and place the db inside it, then
create my package installation that installs the client and points to the
network for the actual DB.

To my credit I'm under the influence of cough\cold medicine today but for
the life of me I can't see how I can create this pkg installation to
accomplish what I want. I'm limited to installing this locally which
prevents me from have the users share the data they input.

Is this even possible with Access? Am I going about this all wrong?

Thanks in advance for the help, I really appreciate it. let me know what
other info I can provide.

Thanks,
Sleestaks72

I wouldn't know how to do this using the developer kit (I've never used it
before), but I would think that you may be able to use some post-deployment
batches/scripting to copy the required backend file to the server. You could
even do this with a standalone Access app included just for copying the files
to where you need them.

After that, assuming your frontends are set up correctly, you can relink the
tables via code, which allows you to specify the location of the backend. So
between the two, it may be possible.

Here's the link for relinking tables.
http://www.mvps.org/access/tables/tbl0009.htm

hth

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill


"sleestaks72`" wrote:

> Hello,
>
> i'm new to this forum and new to Access Developer tools so i'm hoping I
> could get some quick assistance. I don't even know if this is possible but...
>
> I've created a database in Access 2007 and I've downloaded the developer
> tools because I'd like to distribute this small DB to a select group of our
> users so they can share the data. In creating the package installation it
> asked about Root Install Folder (local). I've also opted to automatically
> install the Access 2007 Run-Time. My plan is to have this DB used by about
> 30 users and I'd like for them to be able to share this data. The default
> pkg requies that the access DB installs locally to the client. What I'd like
> to be able to do is create a network folder and place the db inside it, then
> create my package installation that installs the client and points to the
> network for the actual DB.
>
> To my credit I'm under the influence of cough\cold medicine today but for
> the life of me I can't see how I can create this pkg installation to
> accomplish what I want. I'm limited to installing this locally which
> prevents me from have the users share the data they input.
>
> Is this even possible with Access? Am I going about this all wrong?
>
> Thanks in advance for the help, I really appreciate it. let me know what
> other info I can provide.
>
> Thanks,
> Sleestaks72