access working on a server

[thread]

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?

 

[Arvin Meyer [MVP]]

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

 

[Rick Brandt]

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.

 

[thread]

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 כתב:

 

[Douglas J. Steele]

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

(no private e-mails, please)


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]

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]

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.

 

[Arvin Meyer [MVP]]

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