Linking to SQL Server

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

Re: Linking to SQL Server

On Mon, 26 Nov 2007 09:04:06 GMT, "Bigpond News"
wrote:

There is no user limit.

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

-Tom.


>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
>
>
>

Re: Linking to SQL Server

Thanks Tom

Peter


"Tom van Stiphout" wrote in message
news:f7klk3hff8cbt67k3q04qpr3esr3460mlm@4ax.com...
> On Mon, 26 Nov 2007 09:04:06 GMT, "Bigpond News"
> wrote:
>
> There is no user limit.
>
> You can dump the transaction log, every day if you have to.
>
> -Tom.
>
>
>>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
>>
>>
>>