Access 97/Jet 3.5: Problem with data refresh in a multi-user database

RipTide

Background:
Using an unsupported/abandoned multi-user multi-database program that uses
Access 97 and Jet 3.5. Program itself appears to have been built with
PowerBuilder 6.5.
Databases reside on an NT 4 SP6 file server with opportunistic locking disabled.
Workstations are Win98 SE with Access 97, Jet 3.5 SP3, and Network
redirector file caching disabled (VREDIR/DiscardCacheOnO pen=1)
Network: Local LAN using NETBUEI as Primary Protocol, than TCP/IP.

Problem:
When multiple users open the same database, and access the same record,
and the data for that record is modified everyone can see it on the screen,
but it will not print out the modified data until the first person that opened
the record closes his connection to the database.
However, if the first person to access a record makes the modification,
his print out will be correct, but subsequent users will still print the unmodified
data until the initial user closes his connection to the database.

Problem with data refresh, workstation file caching, ODBC/Jet caching ?
I have not been able to figure out if the problem lies within Jet 3.5 and it's
handling of multi-user databases over a network, or with the programming
of the database.

Your expert insight is much appreciated.

Thanks.

Arneil
ri*****@cryogen .com

Nov 12 '05 #1

Subscribe Reply

4840

Albert D. Kallal

What you describe is not the behaviour of ms-access.

However, since you state that the developer did not use ms-access, but in
fact wrote the application in PowerBuilder, then I would suggest you talk to
the developer.

It is very possible that the original developer used temp tables, or perhaps
even wrapped the updates in a trans action of some type.

If one was using ms-access, then the code to force a disk write would be a
me.refresh right before the report gets printed (assuming that the user is
still editing the one record, and whacks a button to print that record based
on a report).

Since the ordinal author could have coded the application anyway they
want...then I would suggest you check with the original developer.

I *did* think that PowerBuilder was a Sybase tool that is for use with the
Sybase database server, and not one that can be used with JET. Perhaps you
meant Delphi..but regardless, how the updates to data works is really the
choice of the developer.

There should be no need to close the application for others to see the
updates. That being the case, then how the application is coded is at issue.
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@ msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #2

Arneil jaski

Thanks for the reply. As far as the application

being created or related to PowerBuilder may

or may not be true as I read some readme.txt

in the install directory. The datbase is an

MDB file, and will not work unless Access 97 and

Jet 3.5 is installed (won't function at all with

Jet 4.0+)

They only have problems when accessing the same

database and the same record. I was hoping there

was something I could do as far as a setting

somewhere to fix the record refresh.

The developer does not exist anymore so if it

has to go that far we might as well develop

another one, maybe with MySQL or something.

Thanks again.

Arneil

ri*****@cryogen .com

"Albert D. Kallal" <pl************ ********@msn.co m> wrote in message
news:s49tb.3905 70$9l5.28842@pd 7tw2no...

What you describe is not the behaviour of ms-access.

However, since you state that the developer did not use ms-access, but in
fact wrote the application in PowerBuilder, then I would suggest you talk to the developer.

It is very possible that the original developer used temp tables, or perhaps even wrapped the updates in a trans action of some type.

If one was using ms-access, then the code to force a disk write would be a
me.refresh right before the report gets printed (assuming that the user is
still editing the one record, and whacks a button to print that record based on a report).

Since the ordinal author could have coded the application anyway they
want...then I would suggest you check with the original developer.

I *did* think that PowerBuilder was a Sybase tool that is for use with the
Sybase database server, and not one that can be used with JET. Perhaps you
meant Delphi..but regardless, how the updates to data works is really the
choice of the developer.

There should be no need to close the application for others to see the
updates. That being the case, then how the application is coded is at issue.

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
No************@ msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #3

Similar topics

430

What are the benefits and drawbacks of web form and windows form at the layer of Data Access?

by: Hamed | last post by:

Hello I have employed as a developer in a software company that its team uses FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to migrate to VS.NET. There is a project modified that is to upgrade a big, more than 100,000 lines DOS based program developed by FoxPro 2.x to .NET platform. The design is as previous and the implementation will be reprogrammed. As a duty in my job I should find an answer about the

.NET Framework

6139

Word Table to Access

by: Ruby Tuesday | last post by:

Hi, I was wondering if expert can give me some lite to convert my word table into access database. Note: within each cell of my word table(s), some has multi-line data in it. In addition, there is one row containing picture(s) as well. So far, what I did is doing it manually for each word docs I have. Select Table Convert Table to Text(I use ^ character for delimiter)

Microsoft Access / VBA

3347

Questions about Access from a .NET/C++ developer

by: Olav.NET | last post by:

I am a .NET/C++ developer who is supposed to do some work with Access. I do not know much about it except for the DB part. Questions: *1* I am looking for INTENSIVE books to get quickly up to speed. I like books with practical exercises, and also with test questions (like cert books) *2*

Microsoft Access / VBA

1788

Ms Access and .Net?

by: marslee | last post by:

One of the my professor gave final question like this "How to use Access database in .Net enivronment to keep track of data?" I have no idea what it is about since he never taught about .NET in the lecture. Does anyone know the answer?

Microsoft Access / VBA

1927

Access to data into an array causes seg-fault

by: Michel Rouzic | last post by:

I had a program that worked perfectly, and that read .wav files. I changed something so the tags of the wave file, instead of being each in a different variable, are all in an array, called tag. i also set macros such as #define bitspersample tag so when in my original program it was written bitspersample now it acts like its tag, and i also moved things that were in the main function into specific functions. anyways, the program read the...

C / C++

4763

Access 2003 performance on datasheet view of bound form

by: rkershberg | last post by:

Recently converted the entire office to Access 2003 as a by-product of upgrading all users to XP sp2 and Office 2003. My performance on the Access 2003 datasheet view of a bound (to an underlying SQL Server view) is so slow the application now is unusable. There must be some additional settings that I am not aware of (I wrote all of the code on the back end .. and it has been optimized and runs extremely well). Current environment is...

Microsoft Access / VBA

5019

How DataGridView refresh and update the data source class property run time

by: Ivan | last post by:

I have a class Foo which have two property. I have a thread that do some process and update class Foo int B. I have a datagridview on main form. this datagridview data source to this class Foo and column A binds to string A and column B binds to int B. When i start two threads, the datagridview able to show two rows and updated int B at run time. How? public class Foo { public Foo()

C# / C Sharp

3127

How and when can I access the controls in the pager row?

by: Nathan Sokalski | last post by:

I have a FormView control in which I use a PagerTemplate. I am having trouble accessing the controls in the PagerTemplate. How do I access them, and in what event should I put the could that accesses them? My current code is as follows: Partial Public Class indextest : Inherits System.Web.UI.Page Private rowcount As Integer = 0 Protected Sub Page_Load(ByVal sender As Object, ByVal e As

ASP.NET

5194

copy a column from table to table in access VB

by: Hokiecow | last post by:

I'm trying to import specific columns from an excel file (Requirements.xls) into an access table (tblRequirements). Using VBA, I'm able to import the entire excel file into table (tblImportRequirements). Instead of going row by row of (tblImportRequirements) and copying the fields needs to (tblRequirements) it would be faster to just copy the column and over write the other table's column. I'm not sure how to copy a few columns from...

Microsoft Access / VBA

2631

Data From Access Pivot In Excel

by: benchpolo | last post by:

I have data extracted from Access db to Excel with a pivot table. Somehow, I am having issues with the pivot table were it doesnt update the totals. For example, the first extract i did in Access has 6000 data rows and pivot table in excel should refresh on open and reflect the 6000 data rows. 2nd extract in Access has 10000 data rows when pivot table opens it doesn't refresh the summary count on the pivot table based on the 10000 data...

Microsoft Access / VBA

9454

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

10038

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

9912

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

8934

AI Job Threat for Devs

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

Career Advice

6715

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

5354

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

5482

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

4007

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

2850

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