Access in a server cluster environment

D

Dixon

Can the Access database be used in a server cluster environment? I was
inform that an SQL Server (database) is needed. I couldn't find any
documentation on this.
 
J

J. Clay

If you are using Access as the Database (.mdb file) then this is a file
based system. The mdb files are just like a word or excel document. With
my limited understanding of clustering, I don't think that this would be
doable in a production Access app.

SQL on the other hand is designed with redundancy methodologies in mind, so
yes, I would say you do need SQL Server in order to do clustering.

Jim
 
D

Dixon

Thanks. I think the key point is that Acess is not designed with redundancy
in mind. I am wondering, however, it there are any documentation on this
somewhere. I tried looking in MS site but got tired of looking at pages
after pages. Any ideas?
 
J

J. Clay

I am not aware of any documentation on this. The only redundancy I can
think of in terms of file based apps (Access, Word, Excel, Etc.) would be
RAID on a Server.

Regards,
Jim
 
Top