Re: Suggestions Please !!!

Tech-Archive recommends: Fix windows errors by optimizing your registry


Lee wrote:
Hi,

I am writing a small P2P based application that allows users to message one
another on a network, and sometimes share files by sending them to each
other (no big files.. word docs ect). The P2P network itself uses a central
server for logging on and looking up IP adresses, but if a user is offline
then it also holds any messages for them and sends them when the user logs
on.

I would say that on average each user may send and recieve messages around 6
or 7 times per day, and there is likely to be around 100 users or so on each
P2P network.

now here is the problem... normally i would have a database backend to the
server for holding all the relevent information. but the end users have no
IT skills, so setting up a database for them is too much trouble.

I presume you mean here, installing SQL Server and its associated
maintenance requirements are too much trouble?

I am
thinking of creating a series of sub-directories within the server
directory, each one will be particular to a specific user, so any messages
files ect can be held there until retrieved.

I cannot think of any other way of easily doing this, as the end users
simply want to install the application (and server) and start using it with
minimal fuss.

any suggestions other than the directory idea of how to store user msessages
and files?

Use a file-based database, such as a JET database (mdb) ? No
administrative requirements at all! - at the cost of robustness, sure,
but this doesn't look like it's going to be an enormous database.

--
Larry Lard
Replies to group pleas

.

Relevant Pages

  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: Active/Active configuration
    ... Almost everything out there is onActive/Passive.Setting up another instance in a cluster is no different than setting up the ... how does sql server knows which instance an application/user is refering to?You need a separate IP addresse for each clustered instance. ... you really shouldn't share a single network. ... Is this a valid assumption?You may get better performance by virute of running each database on its own ...
    (microsoft.public.sqlserver.clustering)
  • Re: dataset safety?
    ... In my idea is the transport on the network (even more on ethernet because of ... posible collisions) that makes a network slow, not the times you use it. ... client has to send the update to the server. ... so the server can go to the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Winsock rate of sending data
    ... The database only has 1 table with 3 columns: ... my machine with less power then the server, ... compress when I am sending the data, ... >network and reducing the server's workload, ...
    (microsoft.public.vb.general.discussion)
  • Re: db corruption
    ... > posts just to help someone. ... See http://www.QBuilt.com for all your database needs. ... Very solid and fast network connectivity, ... > The server is hundreds of GB's with many many users. ...
    (microsoft.public.access.setupconfig)