Access 2007 Sharing

[coyote]

Hi forum members.
I have been using access 2003 but recently I changed to access 2007 which by the way has a very nice interface.
I have this application which is split into a front and back end and I would like to package it using the Developer extensions and the users who don't have access to use access runtime. I have all of these but my question is how to use the extensions to package both the front end and the back end.

I use a function to refresh all the linked tables as long as they are in the same folder but I don't know whether this will be possible once a user installs my application.

All help is greatly appreciated.

 

[burrelly]

Is the back end hosted locally or remotly to the clients machine?

 

[coyote]

I want the back end in a server and the front end in the work stations but none of my clients has access 2007 so amusing the runtime

 

[burrelly]

If the back end is on a server I am assumin it is a server all the clients can access?

If the back end is on a server I am not sure what you are asking about packaging the back end this should be placed on the server no need to package it at all.

It does not matter where on the client machine the application is stored as long as the back end address remains constant. If it is a windows network I would use the actual location on the server e.g \\server\app rather than a network drive.

As the clients do not have 2007 installed you have two options require them to install the extensions before installing the app or the better option is package your front end with the extenstiosn included.