473,396 Members | 1,998 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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


Nov 26 '07 #1
2 1110
On Mon, 26 Nov 2007 09:04:06 GMT, "Bigpond News"
<gl******@telstra.comwrote:

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
Nov 26 '07 #2
Thanks Tom

Peter
"Tom van Stiphout" <no*************@cox.netwrote in message
news:f7********************************@4ax.com...
On Mon, 26 Nov 2007 09:04:06 GMT, "Bigpond News"
<gl******@telstra.comwrote:

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

Nov 26 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: George Hernandez | last post by:
I have a site on a set of Linux Servers where my site is PHP enabled and I would like to prevent people from externally linking to content on my site and replace it with a warning image. I've...
27
by: Lee Phillips | last post by:
I believe it is universally accepted that decorating your website with images from someone else's, without permission, is rude and unethical, even if the images are in the public domain, because...
2
by: sunil | last post by:
Hi, We have lot of c and fortran archive libraries that have complex dependencies. We have different server tasks that use some of these libraries. We have developed a tool inhouse that links...
3
by: John South | last post by:
I have an Access 2000 front end that I wish to work with a SQL Server 2000 database by means of Linked tables. Do I have to use an ODBC connection to SQL Server? It seems to be the only option...
2
by: Jeff Pritchard | last post by:
Some time ago I am sure I came across something that said this was possible, though it doesn't seem to work. A client wants to replace an Access back-end with SQL Server tables. We have tried...
14
by: diskoduro | last post by:
Hi!! Years ago I built a database to control the production of a little factory. The users wanted to work in a Windows Net workgroup so I created an mdb with all the tables and data an after...
0
by: gasturbtec | last post by:
please help im new at access programming and i just got this project dropped in my lap because the old programmer quit. i've been doing ok so far but now i need to add code to an existing database...
18
by: Mark P | last post by:
I have a bit of vb code that uses Tables.Append to programatically link tables from Oracle and DB2 datasources. The problem I am having on some client machines is that the link will take anywhere...
2
by: Matthew Wells | last post by:
Good morning... I have an Access front end that uses SQL Server linked tables. SQL Server uses Windows authentication. I have one Windows group that all Access users are a member of. I added...
0
NeoPa
by: NeoPa | last post by:
If anyone can help with a problem linking across to a table in a database on a SQL 2000 server, then please visit Linking from Access over in SQL Server. I'm locking this so that any and all...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.