473,657 Members | 2,371 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data loss in Access-97

sid
Data loss in Access-97 from VB 6.0

I have encountered Random data loss in our access database.
Sometimes the users call in saying that the records entered by them
are lost. The users, use our VB front end to enter the data (Users do
not enter data directly into the database)
Most of the times I have noticed that the problem occurs when users
add new records.
All our tables have a unique alpha-numeric primary key.

Our Setup
VB 6.0 SP6 (Enterprise) application on a Citrix Metaframe server
MDAC 2.8
Jet SP2
Access database is located in app path which is a shared network
drive.
ADO

Any limitations on Access-97 on a Citrix Metaframe server ? (My
problems started after we migrated to a 2000 Metaframe server from a
NT Metaframe server)

Any hints or pointers that can help me trouble-shoot this random data
loss is greatly appreciated.

Thanks & Regards,
Sid
Nov 13 '05 #1
0 1535

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

Similar topics

14
3160
by: smilemaster | last post by:
I have recently started experiencing form data loss. Here is an example: ====test_form1.php==== <form method="POST" action="test_form2.php"> <input name="textboxvalue" type="text" size="20"> <br> <input type="submit" value="Submit"> </form>
16
3018
by: D Witherspoon | last post by:
I am developing a Windows Forms application in VB.NET that will use .NET remoting to access the data tier classes. A very simple way I have come up with is by creating typed (.xsd) datasets. For example dsParts.xsd and including that in the data tier. I then will create a class that looks like this Public Class CPart Inherits dsParts
2
5010
by: SenseForAll | last post by:
First please note I am a novice at VBA and not even that experienced with DAO/ADO and MS-SQL. Any assistance is appreciated. That said... I have an application written in Access w/ VBA. I need to get some data out of a SQL server and into an Access table. I don't know anything about the SQL server data model or structure. I don't have access rights to link to the SQL table. What I do have is the rights and information to run a stored...
7
2286
by: Neil Ginsberg | last post by:
I'm having some problems with an Access 2000 MDB file with a SQL Server 7 back end, using ODBC linked tables. I previously wrote about this, but am reposting it with some additional information and in summary form, in hopes that someone might have an idea about what's going on. I am using a bound form which is losing data a significant portion of the time. Basically, the form contains 6 fields and three subforms, as follows: Field A...
9
1601
by: HelmutMunich | last post by:
Hello, I am Helmut, my database for multiuser is Frontend/Backend. The turnover file is browsed by VBA for Article numbers to be found in the article table. I use DAO 3.6 lib. The sql Statement uses the article number of the turnover file - with 29 Fields. After record 187 or so, the Article number, read from the turnover file shows only a string of ten blanks.
9
1881
by: Tim | last post by:
Hi, has anyone experienced a spontaneous loss of a subform bookmark (i.e. resetting to the first record), when the computer is idle. I used to have a problem in NT4 when doing a couple of specific things outside of access (launching internet explorer or adobe) that would cause a loss of bookmarks within access. Since our migration to XP though my database seems to do it spontaneously whilst the computer is idle. I guess its actually...
3
11038
by: byeung | last post by:
Hi, I am trying to check if a particular record already exists in an Access database through Excel vba code. Through code obtained at another forum, I got the following: *********************************************************************** Sub TheButton()
10
1683
by: c9stealth | last post by:
I'm new to this Forum and to Microsoft Access, so that being said I'm sure this is an easy fix. I am making a database for my unit and I am stuck on my gains loss reports. I've tried using the code below but, i only get results that are within 30 days but the year doesn't matter. I need the results to take in to cout the year also. for example: right now I put in the code looking for dates of loss with in the next 30 days, my results...
4
23058
by: Haas C | last post by:
Hi all, I have a table with two columns, labeled Year and Loss. In the Year field, I have the numbers 1 to 10,000, each which can or cannot repeat. In the Loss column, i have numbers corresponding to the Years...for example: Year, Loss 1, 568 1, 621
3
1464
by: limperger | last post by:
Hello! This is quite important. We have an Access file shared in a network. Every user has its front-end copy that is linked to a back-end copy. This database has an autonumber field to count the records. Surprisingly, one day we found out that the autonumber count had elapsed 500 records; that is, the last entered record was assigned number 650 and the new one was assigned number 1100 by the autonumber field. I didn't find any...
0
8399
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8312
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,...
0
8827
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, 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...
0
7337
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6169
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4159
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4318
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2732
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
2
1622
bsmnconsultancy
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...

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.