473,405 Members | 2,287 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

SP2 Causes Access Denied When Compacting

Hi,

We have an application that uses an Access 2000 MDB file to store various
data, a customer had a problem where during the compaction routine the
database was corrupted, they informed us that they had just upgraded to XP
SP2.

We upgraded the developemnt VPC to SP2 and this throws a message to say
access is denied to the file but does not corrupt the database, we have
switched the firewall off but this makes no difference.

We are using the JRO.JetEngineClass method to do the compaction.

Any ideas?

Cheers Dave
Jul 21 '05 #1
1 1253
Hmm..SP2 on VPC has known problems. Try using the the latest VPC 2004
Service Pack

--
Sriram Krishnan

http://www.dotnetjunkies.com/weblog/sriram
"Dave" <Da**@discussions.microsoft.com> wrote in message
news:14**********************************@microsof t.com...
Hi,

We have an application that uses an Access 2000 MDB file to store various
data, a customer had a problem where during the compaction routine the
database was corrupted, they informed us that they had just upgraded to XP
SP2.

We upgraded the developemnt VPC to SP2 and this throws a message to say
access is denied to the file but does not corrupt the database, we have
switched the firewall off but this makes no difference.

We are using the JRO.JetEngineClass method to do the compaction.

Any ideas?

Cheers Dave

Jul 21 '05 #2

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

Similar topics

5
by: Peter Verhelst | last post by:
Hello, Currently I am running an Access database on a windows WTS server, running Microsoft Windows 2000 server 5.00.2195 Service Pack 3. This database should be accessible for everybody in our...
2
by: Brian Hansen | last post by:
When I tried converting my Access 97 db to 2000, the size of my database increased from 35MB to 70MB even after compacting and repairing. I tried enabling Unicode compression on the table and it...
5
by: lappy | last post by:
Hello, I have written a small programme to compact an access 97 database. Dim je As New JRO.JetEngine ' Compacts database Data.Mdb to Data2.mdb. je.CompactDatabase...
0
by: ASP.Confused | last post by:
The old message looked a little stale, so I am re-posting it here. Anybody have any ideas of what I could do?!? The previous responses to this question are below. If you want to look at the...
3
by: Shailesh Humbad | last post by:
I figured out what was causing the "Access is Denied" error when calling functions from referenced DLLs in my service. I've tried to be very detailed, so bear with me. It turns out that...
1
by: Dave | last post by:
Hi, We have an application that uses an Access 2000 MDB file to store various data, a customer had a problem where during the compaction routine the database was corrupted, they informed us that...
1
by: alex | last post by:
hi I work with access on reg.comp. and at home on laptop I save the data on USB. ext.hard dr. and or cd. DVD of course rewritable my ques. is some times data is being lost while working around is...
6
by: DFS | last post by:
One of my systems grew exponentially - from 13mb to 43mb - after adding some 10 temp tables (with no data), a new form, and about a thousand lines of code. The .mdb has mostly table links, lots of...
8
by: rdemyan via AccessMonster.com | last post by:
I've converted my application from A2K format to A2003 format. I tried to follow Allen Browne's protocol in getting my app into A2003 (although I was unable to find informtion on the conversion...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
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...
0
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...
0
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,...
0
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...

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.