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

Home Posts Topics Members FAQ

Access 97 less available records

I am running a bespoke access 97 application (front on windows XP
machines, back end on Win 2000 server) that runs fine on 14 of 15 new
machines the 15th however apparently runs okay until you check the
record count which is always about 20% of the "okay" machines! I've
looked and checked everything I can think of, it's running exactly the
same DB so why this problem.

If anybody has any ideas I would be most grateful - it has been
suggested to me to install Access 97 Service pack 1 but I can't find
that either so any help at all would be fantastic.
Nov 12 '05 #1
3 1055
Have you saved a filter on the problem machine.

If you open the tables from the database window do you see the correct
data? (Make sure the navigation buttons do not say (Filtered).

If it's still wrong then my guess is that that machine is connected to a
different backend file. So use the Linked tables manager to relink.

Peter Russell
Jonny Archer previously wrote:
I am running a bespoke access 97 application (front on windows XP
machines, back end on Win 2000 server) that runs fine on 14 of 15 new
machines the 15th however apparently runs okay until you check the
record count which is always about 20% of the "okay" machines! I've
looked and checked everything I can think of, it's running exactly the
same DB so why this problem.

If anybody has any ideas I would be most grateful - it has been
suggested to me to install Access 97 Service pack 1 but I can't find
that either so any help at all would be fantastic.


Nov 12 '05 #2
jo************* @calibreinfo.co .uk (Jonny Archer) wrote in message news:<3d******* *************** ****@posting.go ogle.com>...

I should have mentioned but I have already tried those potential
solutions - the front end has been relinked several times and is
identical to other machines in every way and a filter is not causing
the problem because the application automatically replaces any filters
with the standard filter used by the program.

I am running a bespoke access 97 application (front on windows XP
machines, back end on Win 2000 server) that runs fine on 14 of 15 new
machines the 15th however apparently runs okay until you check the
record count which is always about 20% of the "okay" machines! I've
looked and checked everything I can think of, it's running exactly the
same DB so why this problem.

If anybody has any ideas I would be most grateful - it has been
suggested to me to install Access 97 Service pack 1 but I can't find
that either so any help at all would be fantastic.

Nov 12 '05 #3
I suggest that you create brand new link (using File>GetExterna lData>Link)
to link to a table that you believe is not showing all data.
If this new link is still problematic and you have looked at the data in
the backend and it is correct then I would still have to conclude
you are looking at the wrong datafile from your front-end.

Are you specifying links using UNC addresses
(\\servername\p athtofile_be.md b\file_be.mdb)
or mapped drives?
If mapped drives check the mapping from that machine.

Peter Russell

Jonny Archer previously wrote:
jo************* @calibreinfo.co .uk (Jonny Archer) wrote in message
news:<3d******* *************** ****@posting.go ogle.com>...

I should have mentioned but I have already tried those potential
solutions - the front end has been relinked several times and is
identical to other machines in every way and a filter is not causing
the problem because the application automatically replaces any filters
with the standard filter used by the program.


Nov 12 '05 #4

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

Similar topics

9
3172
by: WalterR | last post by:
This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as it is was under OS/390 or equ. My main experience is IMS DB, which leads to my question. In IMS, there is an HDAM access method which can find a record without using an index as such. At initial database load, it first formats the entire space allocation into blocks of the given size. ...
10
6034
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network computers cannot access the database. The message is...
5
3998
by: Scott | last post by:
I have a customer that had developed an Access97 application to track their business information. The application grew significantly and they used the Upsizing Wizard to move the tables to SQL 2000. Of course there were no modifications made to the queries and they noticed significant performance issues. They recently upgraded the application to Access XP expecting the newer version to provide performance benefits and now queries take...
3
4076
by: Leinad Kong | last post by:
I'm using Access 2002, as front-end and back-end as well: 1) I faced database corrupted problems, when more than 1 user edit concurrently. I'm using All-records Locking, and open-exclusively as default. But, still face the same problem: Database corrupted! (But, it allows to be repaired) 2) I found that the relationship linkage between those related tables(which corrupted) was disconnected/lost after problem (1)
17
2481
by: DaveG | last post by:
Hi all I am planning on writing a stock and accounts program for the family business, I understand this is likely to take close to 2 years to accomplish. The stock is likely to run into over a thousand items and the accounting side will be used for hopefully many years so the entries are likely to be vast. The delema is what is best to use ase the DB engine, Access I have as part of Office 2002 or should I really be looking at SQL...
24
14404
by: cassetti | last post by:
Here's the issue: I have roughly 20 MS excel spreadsheets, each row contains a record. These records were hand entered by people in call centers. The problem is, there can and are duplicate phone numbers, and emails and addresses even person names. I need to sift through all this data (roughly 300,000+ records and use fuzzy logic to break it down, so that i have only unique records.
5
2907
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a front end to SQL server if we ever needed to go that route. But - is there a client/server version of Access ? Looking on the CDW site there is a bewildering variety of packages and licences and such, but we can't figure out just which do...
18
2697
by: Asif | last post by:
Hi all, I am working on portal which is using MS Access 2003 database. The problem that I am facing is that once I received data from vendors I have to upload whole Access Database file to server. Initially it is not an issue but after increasing the size of database file(nearly to 50 MB) it is now difficult to upload such file on server.
6
6255
by: onnodb | last post by:
Hi all, While working on an Access UI to a MySQL database (which should be a reasonable, low-cost, flexible interface to the DB, better than web-based, much less costly than a full-fledged .NET app or so.... is it?), I tried measuring the bandwith consumed by the Access/MyODBC/MySQL link, which came out to be, er, quite high. I fancied it would be interesting to look at the queries Access throws at MySQL through the ODBC link, so I...
6
1714
by: pippapippa | last post by:
I should be most grateful for a little advice. I have used Access 2000 & latterly 2002. Am about to upgrade since it is evident that documentation, tutorials etc are more readily available in later versions. I work on this on my lonesome & do not have access to a mentor or tuition. This is an intermittent activity and quite adjunct to my "normal" investment activities. I have found that most books & documentation are either...
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
8732
jinu1996
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...
1
8503
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,...
0
8605
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 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...
1
6167
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
5632
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();...
1
2731
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
1957
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1620
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.