Hi All

Using AccessXP front-end on PC linked to AccessXP database on server.
System works well for about 25 concurrent users. Have been forced to
upgrade back-end to SQL Server. Have linked tables to SQL Server - similar
process as Access. With minor front-end changes, application works well
for limited user numbers. However, very quickly, server log file becomes
enormous.

Q: Is there a user limit when connecting (linking) to a SQL Server DB ?

If "Yes", would appreciate if you can point me to a helpful site.

Thanks

Peter

On Mon, 26 Nov 2007 09:04:06 GMT, "Bigpond News"
<glenties (AT) telstra (DOT) com> wrote:

There is no user limit.

You can dump the transaction log, every day if you have to.

-Tom.

Thanks Tom

Peter


"Tom van Stiphout" <no.spam.tom7744 (AT) cox (DOT) net> wrote