Record locking on Terminal Services - Microsoft Access / VBA

We are experiencing record locking errors which don't make sense.

O/S :Windows 2003 Server running Terminal Services
Access 2003 SP1
Front end copied to each user folder.

4 users adding records in same area of program but in different records get
a conflict message asking to Save/Copy to Clipboard/Don't Save (I've seen
this message on a stand-alone machine). Pressing Save results in several
copies of the dialog box being displayed.
A field in the form then displays #Error and user cannot get out.
Set Record locking on form to Edited record only to no avail.
We have more users on conventional LANs running for years without problems.

Is this a specific TS problem or do we have a design issue?
Welcome your comments.

pj

Nov 13 '05 #1

Subscribe Reply

1679

aaron.kempf

MDB is a piece of crap. use Access Data Projects.
they rock. SOOOOOOOOOOOOOO OOOO much more reliable than MDB.. aren't
you tired of needing to reboot servers?

Nov 13 '05 #2

Dear Aaron
In developing Access databases over several years, we've never lost a record
or encountered the problem discussed in this question.
I thought this news group was created for Access enthusiasts who need
answers to problems from people more experienced than themselves.
Your reply only demonstrates your ignorance. Horses for courses. Large data,
large number of users, ADP is the way to go. This is not our case. Perhaps
you would be better served by going to a site more in line with your
experience e.g. Useful stategies for playing tiddly winks.

pj
<aa*********@gm ail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

MDB is a piece of crap. use Access Data Projects.
they rock. SOOOOOOOOOOOOOO OOOO much more reliable than MDB.. aren't
you tired of needing to reboot servers?

Nov 13 '05 #3

Similar topics

2295

Terminal Services Debugging

by: Sara_S | last post by:

I am ready to move my ASP web site onto a remote host. The problem is that when I use Terminal Services to see the host machine, the error does not show up. (I was told that debugging info is only sent to the 'console' session, no others). And the whole thing locks up when there is a server error. How can I see the server errors through Terminal Services? Thanks, Sara

ASP / Active Server Pages

5569

ADSI + Terminal Services + .Net

by: Josh Schmidt | last post by:

How can one set the terminal services profile and home directory path in AD using VB.NET? I can set the usual profile paths, but terminal services properties are not supported with ADSI. Any help is greatly appreciated! Josh

.NET Framework

2393

Performance problem (maybe cos of Terminal services?)

by: Jindrich Prchal | last post by:

Hi there. We are running DB2 v7.2 for Win NT on Windows 2000 SP3 machine with poor configuration AMD 1800+, 512MB RAM and usual IDE harddisk. During tests of migration our batch programmes written in Visual Age Generator by IBM from OS390 to Win2000 was this machine our test machine and migrated programmes ran quick enough there. Batch programmes are generated into C++ code from VaGen 3.1, compiled by MSVC++ and run on the machine with...

DB2 Database

7571

C# And Terminal Services

by: TPoise! | last post by:

Using: .NET 1.1, Visual Studio 2003, C#, Microsoft Windows 2000 Server (SP4 and all latest windows updates), Terminal Server running in application mode. I have a C# application that I've deployed to our terminal server for remote users to use. However, normal users (simple domain users) can not run the application. After double clicking on the icon, an hourglass appears as if its loading then it goes back to the normal cursor. ...

C# / C Sharp

1211

Custom controls deployment woes...Terminal Services

by: Brian Young | last post by:

My department is responsible for creating custom internal applications for many of our departments. Our strategy has always been to develop our applications as ActiveX controls (VB6) that get hosted in Internet Explorer. I've been tasked with coming up with a strategy for our migration to using VB.Net. So far, I've experienced a number of items that caused us a few stalls, but mostly was able to resolve them after some thinking and...

Visual Basic .NET

2731

Writing Session Specific Code For Windows 2003 Terminal Server Session

by: OHM | last post by:

Hi peoples, I dont know where to place this question, so as I know you guys are all resourceful experts, I thought I would try here. I am writing some code which will be run usingh remote desktop ( On windows 2003 Server ), I need to determine in the code the machine name and username. If I use GetUsername and GetMachineName, it simply gives me the name of the currently logged on user ( at the Server ) and the Servers Machine Name.

Visual Basic .NET

1741

SQL and Terminal on 2 different PC's

by: shawn | last post by:

In the past I have had SQL and Terminal server on the same PC. With SQL and Windows 2003 Terminal server, you can not have them on the same PC. How can I make this work with SQL and Terminal and 2 different PC's? I have 30 users that need to log on to my SQL database.

Microsoft SQL Server

18790

DAO recordset append single record locks entire table (linked table)

by: RayPower | last post by:

I'm having problem with using DAO recordset to append record into a table and subsequent code to update other tables in a transaction. The MDB is Access 2000 with the latest service pack of JET 4. The system is client/server, multiusers based. The MDBs are using record locking. Here is part of the code: Dim wkSpace As Workspace, db As Database Dim rstTrans As DAO.Recordset Set wkSpace = DBEngine.Workspaces(0)

Microsoft Access / VBA

4096

Record locking / update retries in Access 2007

by: Cindy Huyser | last post by:

I have an Access 2000 database behind a threaded Java application that that can have have concurrent access to the same table (but not the same record). The database is set up for shared access with "No locks" as the default, so that optimistic record locking should take place, and "Open databases using record-level locking" is selected. Each Java thread gets a new connection to the database, then updates its record. One of my users has...

Microsoft Access / VBA

8303

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8821

Problem With Comparison Operator <=> in G++

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8723

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8502

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8602

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4300

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1601

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General