Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2005

Tip: Looking for answers? Try searching our database.

Jet Version Issue - Problems with Locate Record Button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TheScullster - 06 Apr 2005 12:14 GMT
Hi all

Sorry this could get a bit long, but I think the history is important.

We have a company database, originally constructed using Access 2000.
This is split with the front ends being almost entirely on XP boxes and the
back end being on Win2003 Server.

Many moons ago, when the clients were Win98 and NT and the back end was on
NT server we developed a problem.

Part of the function of our database is to control drawings and their issue
status etc.
The problem we found was that use of the Locate Record button (with
binoculars) caused unpredictable behavious of data in the main and
associated sub form.
The fix for this was found to be an upgrade to the Jet database engine to
Jet 4 SP2.5.

Having moved to XPSP2 and Office 2003 SP1, this problem appears to have
returned.
I have tried to upgrade to Jet 4 SP8 but when I do it says this feature is
already up to date.  However when I go into the access help and query system
info, there are entries for Jet 2.x and Jet 3.x, but under Jet 4, the path
entry says not available!
Also, if I go to the immediate window in Access and enter ?dbengine.version
it returns 3.6.

I am not absolutely sure that the problem lies with the Jet version, but I
don't understand why version 4 does not seem to be available on a machine
with all the latest software!

Can anyone give me any pointers please?

TIA

Phil
DL - 07 Apr 2005 14:19 GMT
Not an answer, but may be of some help
http://msdn.microsoft.com/data/downloads/tools/default.aspx
The component checker tool

> Hi all
>
[quoted text clipped - 33 lines]
>
> Phil
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.