hi all,
i'm going to poblish my access file after dividing it to 2(db and
aplications/quries)
i would like to know what is the best solution for using the access on
the server and what is the best server of course,i know that there is a
server called IIS but does it works with access file or i need to
change all the platform of my dababase?

IIS is an internet server not a file server. You can use Access with IIS,
but not with the application front end. Instead you'll need to build ASP
pages to use it. If you want to use Access on a network, the best solution
is a file server like Windows Server 2003.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi all,
> i'm going to poblish my access file after dividing it to 2(db and
> aplications/quries)
> i would like to know what is the best solution for using the access on
> the server and what is the best server of course,i know that there is a
> server called IIS but does it works with access file or i need to
> change all the platform of my dababase?
>

"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi all,
> i'm going to poblish my access file after dividing it to 2(db and
> aplications/quries)
> i would like to know what is the best solution for using the access on
> the server and what is the best server of course,i know that there is a
> server called IIS but does it works with access file or i need to
> change all the platform of my dababase?

In a standard split-app setup you save the data file on the server and give all
users full permissions to that folder. Then the front end is installed on each
user's PC along with Microsoft Access (licensed or the runtime).

The server is merely serving the file. That's it. Think of it as a remote hard
drive. There is no requirement for any other software to be installed on it.
Your app is not running ON the server. It is running on each user's PC.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

hi rick
after talking with our IT department they are not accepting office file
on the server but one thing that they say and i want to consule you
regarding this issue is that this front-end file cannot stand a
multiple use of users and after some time it can crush down,what do you
say about this?

Rick Brandt כתב:
> "thread" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > hi all,
> > i'm going to poblish my access file after dividing it to 2(db and
> > aplications/quries)
> > i would like to know what is the best solution for using the access on
> > the server and what is the best server of course,i know that there is a
> > server called IIS but does it works with access file or i need to
> > change all the platform of my dababase?
>
> In a standard split-app setup you save the data file on the server and give all
> users full permissions to that folder. Then the front end is installed on each
> user's PC along with Microsoft Access (licensed or the runtime).
>
> The server is merely serving the file. That's it. Think of it as a remote hard
> drive. There is no requirement for any other software to be installed onit.
> Your app is not running ON the server. It is running on each user's PC.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com

Sounds as though your IT department doesn't know what they're talking about.

If they don't allow office files on the server, how are multiple users going
to access the same file?

If you follow Rick's advice and ensure that each user has his/her own copy
of the front-end database on his/her hard drive (with the shared back-end
database on the server), you should be fine.

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


"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
hi rick
after talking with our IT department they are not accepting office file
on the server but one thing that they say and i want to consule you
regarding this issue is that this front-end file cannot stand a
multiple use of users and after some time it can crush down,what do you
say about this?

Rick Brandt ???:
> "thread" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > hi all,
> > i'm going to poblish my access file after dividing it to 2(db and
> > aplications/quries)
> > i would like to know what is the best solution for using the access on
> > the server and what is the best server of course,i know that there is a
> > server called IIS but does it works with access file or i need to
> > change all the platform of my dababase?
>
> In a standard split-app setup you save the data file on the server and
> give all
> users full permissions to that folder. Then the front end is installed on
> each
> user's PC along with Microsoft Access (licensed or the runtime).
>
> The server is merely serving the file. That's it. Think of it as a
> remote hard
> drive. There is no requirement for any other software to be installed on
> it.
> Your app is not running ON the server. It is running on each user's PC.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com

hi Douglas,
the question is if there will be from time to time update of data to
the server file(db),is it still be holding on or it will crush down
after some time?becaouse the data to the main db will need to be
updated from time to time by submission

Douglas J. Steele wrote:
> Sounds as though your IT department doesn't know what they're talking about.
>
> If they don't allow office files on the server, how are multiple users going
> to access the same file?
>
> If you follow Rick's advice and ensure that each user has his/her own copy
> of the front-end database on his/her hard drive (with the shared back-end
> database on the server), you should be fine.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "thread" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> hi rick
> after talking with our IT department they are not accepting office file
> on the server but one thing that they say and i want to consule you
> regarding this issue is that this front-end file cannot stand a
> multiple use of users and after some time it can crush down,what do you
> say about this?
>
> Rick Brandt ???:
> > "thread" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > hi all,
> > > i'm going to poblish my access file after dividing it to 2(db and
> > > aplications/quries)
> > > i would like to know what is the best solution for using the access on
> > > the server and what is the best server of course,i know that there is a
> > > server called IIS but does it works with access file or i need to
> > > change all the platform of my dababase?
> >
> > In a standard split-app setup you save the data file on the server and
> > give all
> > users full permissions to that folder. Then the front end is installed on
> > each
> > user's PC along with Microsoft Access (licensed or the runtime).
> >
> > The server is merely serving the file. That's it. Think of it as a
> > remote hard
> > drive. There is no requirement for any other software to be installed on
> > it.
> > Your app is not running ON the server. It is running on each user's PC.
> >
> > --
> > Rick Brandt, Microsoft Access MVP
> > Email (as appropriate) to...
> > RBrandt at Hunter dot com

There's always a chance of corruption in any system, but without more
details of number of users, volume of data, split between read-only usage
vs. update usage and the like, I'd say that you should be okay.

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


"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi Douglas,
> the question is if there will be from time to time update of data to
> the server file(db),is it still be holding on or it will crush down
> after some time?becaouse the data to the main db will need to be
> updated from time to time by submission
>
> Douglas J. Steele wrote:
> > Sounds as though your IT department doesn't know what they're talking
about.
> >
> > If they don't allow office files on the server, how are multiple users
going
> > to access the same file?
> >
> > If you follow Rick's advice and ensure that each user has his/her own
copy
> > of the front-end database on his/her hard drive (with the shared
back-end
> > database on the server), you should be fine.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "thread" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > hi rick
> > after talking with our IT department they are not accepting office file
> > on the server but one thing that they say and i want to consule you
> > regarding this issue is that this front-end file cannot stand a
> > multiple use of users and after some time it can crush down,what do you
> > say about this?
> >
> > Rick Brandt ???:
> > > "thread" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > hi all,
> > > > i'm going to poblish my access file after dividing it to 2(db and
> > > > aplications/quries)
> > > > i would like to know what is the best solution for using the access
on
> > > > the server and what is the best server of course,i know that there
is a
> > > > server called IIS but does it works with access file or i need to
> > > > change all the platform of my dababase?
> > >
> > > In a standard split-app setup you save the data file on the server and
> > > give all
> > > users full permissions to that folder. Then the front end is
installed on
> > > each
> > > user's PC along with Microsoft Access (licensed or the runtime).
> > >
> > > The server is merely serving the file. That's it. Think of it as a
> > > remote hard
> > > drive. There is no requirement for any other software to be installed
on
> > > it.
> > > Your app is not running ON the server. It is running on each user's
PC.
> > >
> > > --
> > > Rick Brandt, Microsoft Access MVP
> > > Email (as appropriate) to...
> > > RBrandt at Hunter dot com
>

The database files need to be split. The applications go on each
workstation. Only the datatables go on the server. I support over 50 users
each with files on their individual machines, all of whom are linked to the
data files on the server. Our last corruption was caused by a faulty WiFi
card in April of 2003. Your IT department obviously suffers from a lack of
knowledge.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"thread" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi Douglas,
> the question is if there will be from time to time update of data to
> the server file(db),is it still be holding on or it will crush down
> after some time?becaouse the data to the main db will need to be
> updated from time to time by submission
>
> Douglas J. Steele wrote:
>> Sounds as though your IT department doesn't know what they're talking
>> about.
>>
>> If they don't allow office files on the server, how are multiple users
>> going
>> to access the same file?
>>
>> If you follow Rick's advice and ensure that each user has his/her own
>> copy
>> of the front-end database on his/her hard drive (with the shared back-end
>> database on the server), you should be fine.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "thread" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> hi rick
>> after talking with our IT department they are not accepting office file
>> on the server but one thing that they say and i want to consule you
>> regarding this issue is that this front-end file cannot stand a
>> multiple use of users and after some time it can crush down,what do you
>> say about this?
>>
>> Rick Brandt ???:
>> > "thread" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> > > hi all,
>> > > i'm going to poblish my access file after dividing it to 2(db and
>> > > aplications/quries)
>> > > i would like to know what is the best solution for using the access
>> > > on
>> > > the server and what is the best server of course,i know that there is
>> > > a
>> > > server called IIS but does it works with access file or i need to
>> > > change all the platform of my dababase?
>> >
>> > In a standard split-app setup you save the data file on the server and
>> > give all
>> > users full permissions to that folder. Then the front end is installed
>> > on
>> > each
>> > user's PC along with Microsoft Access (licensed or the runtime).
>> >
>> > The server is merely serving the file. That's it. Think of it as a
>> > remote hard
>> > drive. There is no requirement for any other software to be installed
>> > on
>> > it.
>> > Your app is not running ON the server. It is running on each user's
>> > PC.
>> >
>> > --
>> > Rick Brandt, Microsoft Access MVP
>> > Email (as appropriate) to...
>> > RBrandt at Hunter dot com
>