473,604 Members | 2,487 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

REPOST: Access 2000 runtime and record-level locking

[Just reposting as I'm sure someone must know about locking behaviour using
the Access 2000 runtime...]
I use the Access 2000 MSI Wizard from Sagekey and they don't know if the bug
documented on page 32 of the Access 2000 Developer`s Handbook Volume 2:
Enterprise Edition still affects the runtime.

Apparently page locking is invoked when using the Access run-time record
than record-level locking. This also affects Access 2000 but if you patch
Access the bug is fixed. I really don't know about the runtime though.

Does anyone know if databases using the Access 2000 runtime default to
page-level locking?
thanks
Martin
--
Nov 13 '05 #1
2 2208
Since the runtime uses the exact same executable as the full retail version
(it's simply crippled through hundreds of registry entries), I would assume
that the default would be the same for both. I'm afraid that I don't know
this for a fact, though.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Deano" <de***@mailinat or.com> wrote in message
news:42******** *************** @ptn-nntp-reader01.plus.n et...
[Just reposting as I'm sure someone must know about locking behaviour
using
the Access 2000 runtime...]
I use the Access 2000 MSI Wizard from Sagekey and they don't know if the
bug
documented on page 32 of the Access 2000 Developer`s Handbook Volume 2:
Enterprise Edition still affects the runtime.

Apparently page locking is invoked when using the Access run-time record
than record-level locking. This also affects Access 2000 but if you patch
Access the bug is fixed. I really don't know about the runtime though.

Does anyone know if databases using the Access 2000 runtime default to
page-level locking?
thanks
Martin
--

Nov 13 '05 #2
Douglas J. Steele wrote:
Since the runtime uses the exact same executable as the full retail
version (it's simply crippled through hundreds of registry entries),
I would assume that the default would be the same for both. I'm
afraid that I don't know this for a fact, though.
"Deano" <de***@mailinat or.com> wrote in message
news:42******** *************** @ptn-nntp-reader01.plus.n et...
[Just reposting as I'm sure someone must know about locking behaviour
using
the Access 2000 runtime...]
I use the Access 2000 MSI Wizard from Sagekey and they don't know if
the bug
documented on page 32 of the Access 2000 Developer`s Handbook
Volume 2: Enterprise Edition still affects the runtime.

Apparently page locking is invoked when using the Access run-time
record than record-level locking. This also affects Access 2000 but
if you patch Access the bug is fixed. I really don't know about the
runtime though.

Does anyone know if databases using the Access 2000 runtime default
to page-level locking?
thanks
Martin
--


Sagekey said they're program simply wraps around the Access runtime. So I'm
not certain that patching Access would do anything to the runtime. It would
be a real pity if the runtime lumbered me with page-level locking.

--
Nov 13 '05 #3

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

Similar topics

5
1910
by: David Greenwood | last post by:
I posted this under 'microsoft.public.sqlserver.client' but got no reply. Any help with this problem would be greatly appreciated --------------------- I developed a database under SQL Server 2000, with Access 2000 on Windows 2000 as client. This had been running fine for several years. The client is now upgrading to Windows XP, and has come across a display problem on the reports. The figures are correct but are now displayed with lots of...
1
1690
by: Yannick Turgeon | last post by:
Hello, This is a repost (see under the "dotted" line) from 2 days ago. Hope someone could help. Norton Antivirus 2003 is installed on this computer. Could it cause a problem? Another interesting thing is when I open a email with the DB attached (on the ME computer), the file is not "enabled" in the file list, it's grey. First time I see this.
3
2492
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access runtime and also full-version. Some of the client workstations will have Access 2002 installed. Most of them will have the runtime installed. However, I can't find the Office 2002 Developer Edition anywhere! Nobody has
7
8842
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
2
2456
by: Philippe PERON | last post by:
Hello, An ACCESS application (mde) is installed on a computer looking at an mdb file on the same machine. As far as I know the application is installed thru a Wise Installer script. The installation process performs an installation of ACCESS 2000 RUNTIME thru a SAGEKEY script. The application is designed to run only in within the scope of ACCESS 2000 RUNTIME. Everything works fine.
11
6579
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...
47
4507
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
4
1927
by: brooks | last post by:
I have an Access 97 app and the ADT and am considering selling it to the public. Is this viable? What issues might I have? I also have Access 2000 and could use that if it would be better. I don't have the "ADT" for 2000. Is it called ODE or ODT? Can you still buy that? Would there be any advantage in moving up to and distributing using
4
1852
by: Kaur | last post by:
I am reposting this message. I am a beginner using MS Access. I am working in MS Access 2000 and have created two forms. Form 1 is called frmParent (which has a read only subform called SfrmChild). FrmParent has a list box that lists all the Last Names of parents in the db. Clicking on one of the lastname of parent in the list box shows children of selected parent in the SfrmChild. I have a button on frmParent that opens up a pop up form...
1
5569
by: ncsthbell | last post by:
I have a dilemia, I have an application that I am having to make some changes to in order for it to run sucessfully under Runtime 2007. We are currently working on upgrading from 2000 to 2007. The users will be running the apps under 'Runtime Access 2007' Here is my dilema... This application is used as a 'stand alone', basically, my users get a copy of the 'master' database and enter their data specifically for one account, each account they...
0
7929
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
8419
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
8409
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
8065
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
8280
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...
0
5441
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();...
0
3907
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...
1
1526
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1266
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.