IN trying to export a Jet query (an actual saved Jet querydef which is
written against a pass through query - not that that should be a
problem) to text via either the File->Export... menu item or using
Transfertext, I get an error to the effect that permission is denied.
The VBA line shown below - I tried using the specification
DoCmd.TransferT ext acExportDelim, "QryOracleV iew Export Specification",
"qryOracleView" , strSaveFile, -1
I get an error 3051 for the above line or when doing it via the menu is
as follows:
The Microsoft jet database engine cannot open the file
'qryOracleView-2006-08-24.txt'. It is already opened exclusively by
another user , or you need permission to view its data.
Yet, I have no problem doing the menu method and exporting to Excel.
What is going on?
Thanks in advance for any help on this...
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me 6 6899
IME, Windows often gets itself confused about file permissions, so the issue
might be that the file exists and it is not being overwritten. Try:
If Dir(strSaveFile ) <vbNullString Then Kill strSaveFile
If that also fails there is an issue with the file.
If it solves the problem, you're home.
If it doesn't solve the problem, then the issue is elsewhere, such as with
the import/export spec.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtheriumwrote in message
news:ec******** **@coranto.ucs. mun.ca...
IN trying to export a Jet query (an actual saved Jet querydef which is
written against a pass through query - not that that should be a problem)
to text via either the File->Export... menu item or using Transfertext, I
get an error to the effect that permission is denied.
The VBA line shown below - I tried using the specification
DoCmd.TransferT ext acExportDelim, "QryOracleV iew Export Specification",
"qryOracleView" , strSaveFile, -1
I get an error 3051 for the above line or when doing it via the menu is as
follows:
The Microsoft jet database engine cannot open the file
'qryOracleView-2006-08-24.txt'. It is already opened exclusively by
another user , or you need permission to view its data.
Yet, I have no problem doing the menu method and exporting to Excel.
What is going on?
Thanks in advance for any help on this...
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
On Thu, 24 Aug 2006 17:15:22 -0230, Tim Marshall
<TI****@PurpleP andaChasers.Moe rtheriumwrote:
>IN trying to export a Jet query (an actual saved Jet querydef which is written against a pass through query - not that that should be a problem) to text via either the File->Export... menu item or using Transfertext , I get an error to the effect that permission is denied.
The VBA line shown below - I tried using the specification
DoCmd.Transfer Text acExportDelim, "QryOracleV iew Export Specification", "qryOracleView ", strSaveFile, -1
I get an error 3051 for the above line or when doing it via the menu is as follows:
The Microsoft jet database engine cannot open the file 'qryOracleVi ew-2006-08-24.txt'. It is already opened exclusively by another user , or you need permission to view its data.
Yet, I have no problem doing the menu method and exporting to Excel.
What is going on?
Thanks in advance for any help on this...
I have seen this error on occasions if the filename exceeds 12 characters.
(Isn't it obvious from the error message :)
Try shortening the file name to OracleView rather than qryOracleView.
Wayne Gillespie
Gosford NSW Australia
Tim Marshall wrote:
The Microsoft jet database engine cannot open the file
'qryOracleView-2006-08-24.txt'. It is already opened exclusively by
another user , or you need permission to view its data.
Wayne and Allen, thanks for your responses, but neither is working.
What's particularly odd is that once I specify a file name and get my
error, the file has actually been created... you can go to the folder
and see the text file. however, when you try to open it when your app
is still open, I get an error message in notepad telling me the file is
in use. Only when I turn off the mdb does Wondows allow me to open the
file and then it's a small 1kb thing with just the headers, but no data.
Odd. I've contacted MS Support - regardless of what anyone says, I've
found the expense worth it in the past when I've been hit with something
I can't google or news sleuth! 8) I'll post results if I get anything
to work.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Post the answer when you get it sorted out, Tim.
I suspect I did run into this once, but can't recall the detail. Seems like
there was some reason why the export was failing after it started, such as a
bad import/export spec.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtheriumwrote in message
news:ec******** **@coranto.ucs. mun.ca...
Tim Marshall wrote:
>The Microsoft jet database engine cannot open the file 'qryOracleVi ew-2006-08-24.txt'. It is already opened exclusively by another user , or you need permission to view its data.
Wayne and Allen, thanks for your responses, but neither is working.
What's particularly odd is that once I specify a file name and get my
error, the file has actually been created... you can go to the folder and
see the text file. however, when you try to open it when your app is
still open, I get an error message in notepad telling me the file is in
use. Only when I turn off the mdb does Wondows allow me to open the file
and then it's a small 1kb thing with just the headers, but no data.
Odd. I've contacted MS Support - regardless of what anyone says, I've
found the expense worth it in the past when I've been hit with something I
can't google or news sleuth! 8) I'll post results if I get anything to
work.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Tim Marshall wrote:
Tim Marshall wrote:
>The Microsoft jet database engine cannot open the file 'qryOracleVi ew-2006-08-24.txt'. It is already opened exclusively by another user , or you need permission to view its data.
Post script:
It turns out, to my great chagrin and 3 weeks of serious inconvenience
for the space planners my app is used by, that the specification name
used by my docmd.transfert ext line was referring to an export spec that
was not appropriate for what I wanted to do - in this case, it was comma
delimited and my data was full of commas.
I do find the dialog for saving specs a bit tricky to work with and one
has to be careful that one verifies that what you've saved is indeed
what you want to be actually saved.
Anyway, there you go, for Google posterity... 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Thanks for posting the solution, Tim.
Agreed that the error messages associated with bad import/export specs are
not always helpful.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tim Marshall" <TI****@PurpleP andaChasers.Moe rtheriumwrote in message
news:ee******** **@coranto.ucs. mun.ca...
Tim Marshall wrote:
>Tim Marshall wrote:
>>The Microsoft jet database engine cannot open the file 'qryOracleVie w-2006-08-24.txt'. It is already opened exclusively by another user , or you need permission to view its data.
Post script:
It turns out, to my great chagrin and 3 weeks of serious inconvenience for
the space planners my app is used by, that the specification name used by
my docmd.transfert ext line was referring to an export spec that was not
appropriate for what I wanted to do - in this case, it was comma delimited
and my data was full of commas.
I do find the dialog for saving specs a bit tricky to work with and one
has to be careful that one verifies that what you've saved is indeed what
you want to be actually saved.
Anyway, there you go, for Google posterity... 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Klunk |
last post by:
Hi,
last week I moved the folder of my Intranet application to
another disk of the same server.
After this change all the ASP page return this error:
Microsoft VBScript runtime error '800a0046'
Permission denied: 'CreateObject'
|
by: Mark E. Hamilton |
last post by:
Sorry, I probably should have re-stated the problem:
We're using Python 2.3.5 on AIX 5.2, and get the follow error messages
from some of our code. I haven't yet tracked down exactly where it's
coming from:
sem_trywait: Permission denied
sem_wait: Permission denied
sem_post: Permission denied
|
by: Florian G. Pflug |
last post by:
Hi
I installed a postgres-application (which was developed on debian
woody) on red hat 9 today, using the postgres 7.3 rpms from redhad.
One of my the triggers uses the pg_settings table (more precisely, it
updates that table to change the search_path temporarily). With the
postgres 7.3 (and 7.4 too) installed on my debian development system,
this worked fine. On redhat 9, however, I get an "pg_settings:
permission denied" error when my...
|
by: Taishi |
last post by:
New user of SQL
Everything is on the same machine
My error is close to the bottom
After reading it today, I can see there is a problem with 2 dbases
'PUBS' and 'Master'
There are also some comments from the group:
---microsoft.public.sqlserver.odbc-- subject: Permission Denied -- Thanks
for help guys
I was able to find a trial version of the Enterprise Manager.
|
by: stephen |
last post by:
Hi,
I am getting an error while trying to create an excel file.
"Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Permission denied"
This is what I am doing. we had an app that...
| |
by: debug03 |
last post by:
I am executing a DTS package on a Windows 2000 sp4 server running SQL Server 2000 and IBM DB2 V7 client. The DTS package source data(SQL Server) is selected from SQL server table and inserts data to the destination table(DB2). I get the following error when the package is executed:
The execution of the following DTS Package succeeded:
Package Name: PEX2-CopyQualDatatoDB2-UAT
Package Description: (null)
Package ID:...
|
by: private.anders |
last post by:
Hi David!
Really need assistance since I have been struggling with a problem
long time now.
I am running a web application on a Win 2003 Std (Active Directory).
Everything works fine. I have installed same application on another
server Win 2003 R2 Std (No Active Directory). On that server I get
“Permission denied” using the following code (used to zip folder
content).
|
by: private.anders |
last post by:
Really need your assistance since I have been struggling with a
problem long time now.
I am running a web application on a Win 2003 Std (Active Directory).
Everything works fine. I have installed same application on another
server Win 2003 R2 Std (No Active Directory). On that server I get
“Permission denied” using the following code (used to zip folder
content).
set WshShell = server.createobject("wscript.shell")
|
by: xzzy |
last post by:
I have a v1.1 web app that works on my local computer. However, running it
at the host computer, the following breaks:
when a viewer selects a different country, the State dropdown should
repopulate with the new country's state/proviences.
Running on the host, the dropdown does not repopulate and says 'Permission
Denied', I take this to mean that at the host, a viewer does not have
permission to put new items in the State dropdown.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |