I have 5 MS Access DB's that I have moved over to a bigger server from my IIS
server, figuring that it would support the sql request easier. However I was
wrong. Would anybody know why after copying the db's over would a server
crash after accessing the db's via IIS? I have a Dell PowerEdge 2300
1CPU(?G/MHZ) w/256RAM.
On Nov 1, 6:25 pm, Joseph
> I have 5 MS Access DB's that I have moved over to a bigger server from my IIS
> server, figuring that it would support the sql request easier. However I was
> wrong. Would anybody know why after copying the db's over would a server
> crash after accessing the db's via IIS? I have a Dell PowerEdge 2300
> 1CPU(?G/MHZ) w/256RAM.
Access DB does not scale by simply copying it to a bigger server. If
you actually want to make it more scalable/usable by more people, go
to any form of SQL, for free or for fee.
Can you clarify what server is crashing (the server that is running
IIS or the server with the Access DB files -- or are they still the
same machine). And what do you mean by "crash" -- is the server blue
screening? Is a specific process crashing (and if so, what is the
process name)? Or is your web request simply not working or hanging.
//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//
Sorry for the miscommunication-
My PDC which serves as the file server also(small company), seperate from
the IIS. On the blue screen of death, I get, failed to start audit, physical
memory dump beginning. I moved the db's over to that because our IIS machine
is a Dell Optiplex GX110(intranet site for viewing data not
enter/manipulating). I wanted to seperate the services so that the IIS does
not get bogged down when actual data is entered/manipulated. I have looked
into getting a SQL server, but I work for a County office and you know that
it takes forever to get anything. So as a quick fix until, I moved the db's
to the Dell PowerEdge to free up some of the memory on the IIS.
"David Wang" wrote:
> On Nov 1, 6:25 pm, Joseph
> > I have 5 MS Access DB's that I have moved over to a bigger server from my IIS
> > server, figuring that it would support the sql request easier. However I was
> > wrong. Would anybody know why after copying the db's over would a server
> > crash after accessing the db's via IIS? I have a Dell PowerEdge 2300
> > 1CPU(?G/MHZ) w/256RAM.
>
>
> Access DB does not scale by simply copying it to a bigger server. If
> you actually want to make it more scalable/usable by more people, go
> to any form of SQL, for free or for fee.
>
> Can you clarify what server is crashing (the server that is running
> IIS or the server with the Access DB files -- or are they still the
> same machine). And what do you mean by "crash" -- is the server blue
> screening? Is a specific process crashing (and if so, what is the
> process name)? Or is your web request simply not working or hanging.
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>
>