"Microsoft Jet database engine cannot open the file..."
I'm trying to EXPORT the results of a query to a CSV file. I've been
doing this, using different queries, for WEEKS, with no problems. This
file always thinks that the resulting export file is already opened,
but the file resides on my hard drive, and I get the error even if I
delete the file and start from scratch.
I'm not doing this via programming; just FILE > EXPORT.
Let me add that, if I replace all the "NULL AS..." fields in my query
the export works. HOWEVER, I have about 10 other queries that do this,
with "Null as..." and work just fine.
> I'm trying to EXPORT the results of a query to a CSV file. I've been
> doing this, using different queries, for WEEKS, with no problems. This
> file always thinks that the resulting export file is already opened,
> but the file resides on my hard drive, and I get the error even if I
> delete the file and start from scratch.
> I'm not doing this via programming; just FILE > EXPORT.
> Any ideas?
...tcl database connection for Oracle MySQL PostgreSQL Sybase "Microsoft SQL Server 2000 Desktop Engine" DB2 Interbase/Firebird SQLite Microsoft Access
There are many people that are looking for/missing the support for
their database within TCL. Somehow this was overlooked:
It has native TCL API and supports most popular databases.
One problem: It doesn't have production ready support on Windows, but
for the lucky people who use Linux/Unix, it seems to be an excellent
solution, while TDBC is being developed.
One small correction, the TCL part of the db connection will work just
fine on Windows connecting to sqlrelay running on Linux/Unix (which,
in turn, can connect to the database running on Windows :) ). What
doesn't have production ready support (according to developers) is
sqlrelay running on Windows.
...Can I replicate database "foo" to database "bar"
Let's say that I have two servers, server M with database "foo" and
server S with database "bar", with full control over them. Can I set
up replication so that "foo" is replicated into "bar".
(the issue is that I have many masters with the same database name foo,
and I want to have one slave server with databases like foo-1, foo-2
etc, replicated from all those masters)
On 14 Aug, 22:55, Ignoramus32732 <ignoramus32...@NOSPAM.32732.invalid>
> Let's say that I have two servers, server M with database "foo" and
> se...The Microsoft Jet database engine cannot find a record in the table"with key matching field(s)"
Please can you help me with this problem:
In the next form, when I Add new person who is not registered in the base I
had the massage: The Microsoft Jet database engine cannot find a record in
the table 'CLAN' with key matching field(s) JMBG.
The question is: How to add data for the unregistered visitors in the next
JMBG (unique person number);(translation)
If you want I can send mdb.zip. Thank you very much.
...Strawman: Is MS Access a "database"?
I would argue that it is not.
JET is a desktop DB engine.
Sybase is a database
Oracle is a database
DB2 is a database.
VB 6 is a front-end development tool.
PowerBuilder is a front-end development tool.
MS Access is a front end devlopment tool.
What's got me going on this is that I keep hearing statements like "What!
you're running a mission-critical application out of an Access database?"
Or the latest, to the effect of, "Well, sure the app has been working a-ok for
the past five years, but would you want people reading in th...Too few parameters expected 2 error occurs after migrating "MS Access 2000" to "MS SQL Server"
I get Too few parameters expected 2 error and "The MS Jet Database
engine cannot find the input table or query "myTempTablename". Make
sure it exists and that its name is spelled correctly. 3078" after I
migrated "MS Access 2000" to "MS SQL Server 2000" and relinked all
The front-end interface of my application is MS Access 2000. The
back-end is MS SQL Server 2000. After I migrated the database and
relinked all linked tables, "Too few parameters expected 2" and "input
table or query "myTempTablename" 3078" error occurs. I found a article
in Microsoft website. The "Too few parameter" error occurs because the
limitation of the MS Access ODBC driver. If it is, any solution?
Thanks in advance
If you mean you are getting the error when you are trying to relink the
tables through ODBC, then the problem could be - if your table(s) had a
memo field, that sql server picked up the memo field as a varchar, and
Access is trying to read a text field that exceeds 255 chars. You need
to go to Query Analyzer (sql server QA) and run some queries against the
offending table to see what the text length is in your varchar fields in
the sql server table. And if Sql Server did pick up an Access memo
field as a Sql Server Text field, ODBC can't read Sql Server Text
fields. If any of the varchar fields exceeds 250 chars (for me I get
errors after exceeding 250 cha...SQL Server "Linked Server" to MS Access Database
I have a very frustrating problem. I have a situation that works fine
on some computers, but not on others. I have SQL Server Express 2005
and Access 2003 loaded on 4 computers. I have set up a "Linked
Server" in SQL Server linked to my Access database. I am running
queries on t-SQL against the Access tables through the linked server.
On all of the computers, I can do select queries and they all work
great but what I need to do is run Update, Insert, Delete queries as
well. On a couple of the computers, it works fine, locally and across
the LAN, and a VPN as far as that goes. But on other computers I can
do Select queries (also across the network) but no update queries. I
get the error message "OLE DB provider "Microsoft.Jet.OLEDB.4.0" for
linked server "securedjetls" returned message "Operation must use an
updateable query." where securedjetls is the name of the linked
server. The Access database on the computer that is not working is a
copy of the database from the computer that is working and any of the
tables that I'm trying to update have primary keys, so that's not the
...Urgent JAVA Requirement in """"""NEW YORK"""""""""
How are you ? Please find the requirement below.
Location : NY
Duration : 8 mnths
Java/J2EE Web Service Developer
=B7 (4+ years of application development experience in Java/J2EE
and Web service technologies.
=B7 Experience with spring & Hibernate.
=B7 Experience with J2EE Application Server (preferably Web
=B7 Preferable Aqua logic DSP Experience
=B7 Preferable Sonic ESB Composite Service experience
Experience working in UNIX environment.
Good working knowledge of Oracle RDBMS and PL/SQL)
Note : Please send your updated resume along with contact no to
Thanks & Regards
# 1572, 7 th Floor Suites,
1 Blue Hill Plaza
...does a "parameters"-parameter overwrite the "parameters"-object?
I'm currently writing a JS->Scheme compiler (which, using Bigloo,
automatically yields a JS->C, JS->JVM, JS->.NET compiler), and have a
question concerning the function-parameters:
According to the spec (10.1.6) the activation-object already contains the
the parameters-object when the variables are instantiated (10.1.3). The
question is now: does a parameter "parameters" overwrite the
"parameters"-object or not?
All three implementations I tested (Konqueror, Mozilla and Rhino) do not
overwrite the object, but I've already seen all three fail on other sim...Why does "One Zero" mean "Ten" and not "One Zero"?
Who asked if we said "10" equals "One Zero" like it says what could we
conceive as a benefit from this?
The answer to the question is me: "Eleaticus" (actually) Musatov.
Though we may have answered the question we have not answered [the]
question contained [within] the question.
Let us do this now:
I can think of two benefits.
1. The disparaging difference between logic numbers and language
2. A new system is adopted: one better suited to sensible expression.
Let us examine the problem of the "Ill Placed Zero":
1. When we say 0 it...converting from "cooked" to "raw" oracle database
i'm working on a database which consists of datafiles in filesystems
(referred to as cooked in some technical documents). i want to look at
the performance difference with all the files raw i.e. using logical
volumes to store the data. i know its possible to backup raw files
using the dd command. what i'm interested in finding out/understanding
is how to perform the opposite process i.e. convert from a 'cooked' to
'raw' storage system for an existing instance containing data. can i
use a dd command to copy data from file to logical volume? is an
export/import the only option? i'm going to be performing a number of
tests myself and will post findings here. any other knowledge on
> i'm working on a database which consists of datafiles in filesystems
> (referred to as cooked in some technical documents). i want to look
> the performance difference with all the files raw i.e. using logical
> volumes to store the data. i know its possible to backup raw files
> using the dd command. what i'm interested in finding
> is how to perform the opposite process i.e. convert from a 'cooked'
> 'raw' storage system for an existing instance containing data. can i
> use a dd command to copy data from file to logical volume? is an
> export/import the only option? i'm going to be performing a number of
> tests myself and will post finding..."Code Signing Certificate" with "split database"
I have a split Access 2003 database. I have signed the database with a
Code Signing Certificate from Small Business Server. This works fine
and users can have Access macro security on high or medium and do not
get prompted at startup.
The problem comes because there are two of us modifying the code.
Whenever either one of us changes the code, one of us must resign both
the front and back end of the database. If we forget to sign both, we
hear about it in the morning!
If we remove the digital signatures and set macro security to low, the
users get prompted about "Unsafe expressions".
Any ideas on the best way to handle this?
> If we remove the digital signatures and set macro security to low, the
> users get prompted about "Unsafe expressions".
> Any ideas on the best way to handle this?
Have the users open Access and set the Macro Security to Medium, then close
the dialog window, then set the Macro Security to Low again. When they
receive the following message:
"Unsafe expressions are blocked. You can configure your computer to allow
all expressions to be evaluated. Allowing all expressions to be evaluated
affects all users on this computer. Do you want to allow the evaluation of
potentially unsafe expressions?"
.. . . tell them to press the "No" button this time.
Also tell your users to ensure that their antivirus software definitions are
up to date at all times so that they ...sample "ledger" access database
I'm looking for a sample access database (preferably Access 2000
or early) that is more sophisticated than the template/sample
provided with Access. It's for personal use. Can anyone point me
to some freeware or samples?
I had a good look around for one a while ago and couldnt find anything. You
could have a look at http://www.databasecreations.com/ they make some access
databases. They are not free, but you can have a squizy at the table
"Steve V" <firstname.lastname@example.org> wrote in message
news:MPG.19d37bc148610c5e989683@net..."out" and "in out"
Hi i found the following explaination:
In Ada, "in" parameters are similar to C++ const parameters. They are
effectively read-only within the scope of the called subprogram.
Ada "in out" parameters have a reliable initial value (that passed
in from the calling subprogram) and may be modified within the scope
of the called procedure. Ada "out" parameters have no reliable
initial value, but are expected to be assigned a value within the
What does "have no reliable initial value" mean when considering the "out"
By c...why "::", not "."
Why does the method of modules use a dot, and the constants a double
Math::PI and Math.cos
Posted via http://www.ruby-forum.com/.
On Oct 26, 2010, at 01:48 , Oleg Igor wrote:
> Why does the method of modules use a dot, and the constants a double
> Math::PI and Math.cos
For the same reason why inner-classes/modules use double colon, because =
they're constants and that's how you look up via constant namespace.
Math::PI and ActiveRecord::Base are the same type of lookup... it is =
just that Base is a module and PI is a float....about "++" and "--"
why this program snippet display "8,7,7,8,-7,-8"
the program is:
> why this program snippet display "8,7,7,8,-7,-8"
Ask your compiler-vendor because this result is IMHO implementation-defined.
Check this out:
> why this program snippet display "8,7,7,8,-7,-8&q..."You don't have exclusive access to your database at this time" (Access 2003)
All of a sudden one of our clients can't use her application. She
gets "You don't have exclusive access to your database at this time"
when trying to open our application.
The only thing she did today, according to her, was to download and
install an Avery label wizard.
She has rebooted and there are no other versions of Access running.
The shortcut that launches the application does point to a version of
Access (2003) because the installation wizard found an existing
version on her PC. I believe it points to Office 11.
Nevermind. She uninstalled the Avery Label Wizard and the problem
...What exactly are "Constraint programming" & "constraint databases" about ?
I run into these terms rather frequently, without ever getting/finding a good explanation as to what it's really about.
Anyone here can help me ?
On 2015-12-29 14:16:11 +0000, Erwin said:
> I run into these terms rather frequently, without ever getting/finding
> a good explanation as to what it's really about.
> Anyone here can help me ?
Since it seems that Springer has given free access to its books up to 2004,
if you are interested you may download this:
--- news://freenews.ne...Urgent need """""""""""INFORMATICA DEVELOPER"""""""""""""
How are you ? Please find the requirements below.
Title: Database/ETL Developer
Duration: 6 months
Database/ETL requirements (Mandatory)
Candidate must have worked with financial instruments, preferably
Mutual Funds but, Equities are also ok.
PL/SQL - packages, Stored procs, Functions, Aggregate functions,
Informatica 8.6 - especially complex mappings, complex maplets,
complex workflows, transformations
Unix/Linux shell scripting
Database/ETL requirements (Optional)
Data warehousing experience
Threading and job concepts in 10g/11g
Cost based Optimizer concepts in 10g/11g
Must : Experience with XML files and partitioning concepts in
Oracle, Collections, Material Views
Note : No phone calls please.
: send Resumes to email@example.com
Thanks & Regards
...when should one use "and" and "or"
just got hit w the ff
> when x==1 or x==2
> print "yeoh!"
SyntaxError: compile error
(irb):17: syntax error, unexpected kOR, expecting kTHEN or ':' or '\n' or ';'
when x==1 or x==2
"or" and "and" both exhibit the behaviour in ruby1.8/1.9.
1 put parens around the condition (not again)
2 replace or/and with ||/&&
i believe there are other similar quirks when using "and/or"..
has ruby relegated the use of "and/or"....?
best regards -botp
On Feb 4, 9:55=A0pm, botp <botp...@gmail.com> wrote:
> Hi All,
> just got hit w the ff
> > case
> > when x=3D=3D1 or x=3D=3D2
> > =A0 print "yeoh!"
> > end
x =3D 5
On Fri, Feb 5, 2010 at 1:45 PM, w_a_x_man <firstname.lastname@example.org> wrote:
#> x =3D 5
#> =A0 =A0=3D=3D>5
#> case x
#> =A0when 2,3
#> =A0 =A0p 'no'
#> =A0when 4,5
#> =A0 =A0p 'yes'
of course i know that ;-)
im talking about the second type of "case", eg
> when x.baz and y.foo
best regards -botp
> i believe there are other similar quirks when using "and/or"..
> has ruby relegated the use ..."Correct" term for a 1:1 relationship between a "database" and an "instance" where > 1 such things are on the same physical server?
What is the "correct" term for a 1:1 relationship between a "database"
and an "instance" where there are at least two such "things" on the
same physical server?
Nearly all the Oracle docs and books define a database something like
DATABASE - a collection of datafiles and oracle config files; useless
without an "instance" to access the database.
INSTANCE - a collection of background procs and memory structures,
used to access a "database."
Where I work, people typically call each "thing" mentioned in my
Subject: line an "instance" or a "database instance." What is the
"correct" term for having more than one of these "things" on the same,
unpartitioned physical server?
This may be splitting hairs; but when people don't or can't come to
terms, confusion ensues--and that's typically a Bad Thing.
I noticed, or rather a colleague of mine did, that even Tom Kyte mixes
terms. In the book Expert Oracle Database Architecture (2005 edition)
on page 50, in the bullet-pointed definitional paragraph for Instance,
he throws the word "database instance" into the mix. A "no no"
according to my colleague (don't shoot the messenger, please); because
the vernacular seems to be "instance" or "database instance" for the
I like to be precise with terms, but then there are business
stakehold..."In" "Out" and "Trash"
I just bought a new computer and I re-installed Eudora Light on my new
computer. But when I open Eudora, the "In", "Out" and "Trash" links
are not on the left side of the screen the way they were on my old
computer. How can I get these links back on the left side of the
screen? Thank you.
On 25 Mar 2007 09:49:22 -0700, "abx" <email@example.com> wrote:
>I just bought a new computer and I re-installed Eudora Light on my new
>computer. But when I open Eudora, the "In", "Out" and "Trash" links
>are ...Can "CREATE DATABASE" or "CREATE TABLE" be wrapped in transactions?
I have some code that dynamically creates a database (name is @FullName) and
then creates a table within that database. Is it possible to wrap these
things into a transaction such that if any one of the following fails, the
database "creation" is rolledback. Otherwise, I would try deleting on error
detection, but it could get messy.
IF @Error = 0
SET @ExecString = 'CREATE DATABASE ' + @FullName
EXEC sp_executesql @ExecString
SET @Error = @@Error
IF @Error = 0
SET @ExecString = 'CREATE TABLE ' + @FullName + '.[dbo].[Image] ( [ID]...Variations in "Jet" DB engines etc and "Unknown" error!
I have two systems, one a W98 and the other XP Home. I have Access 2000 installed on both,
and have run into a difference in the way the two behave.
I have a table on which I wish to reset an "auto number" field so the counter goes back to
zero. The procedure I have used is to copy the contents of the table to a temp table,
empty the table and then compress the files. After that I copy back the data to the table
without the original "auto number". All this works fine on the XP machine BUT on the W98
machine exactly the same process produces " unknown" errors when I try and run the
application. That is to say, the error message is that Access has encountered an unknown
error". When I hit help, it refers me to the jet engine but thats about all.
I am wondering if there is a difference in the "jet" engine between the two systems, how I
find out, whether both systems can be given the same version (the one in the XP machine
since that does the job for me), and if so how I would set them up with the same engine.
Advice would be appreciated.
If there is a difference in how JET behaves, check if msjet40.dll is the
same version on both.
It's typically in windows\system32.
Right-click the file, and choose Version.
You should see 4.0.8xxx.0
If you don't see the 8, go to support.microsoft.com, the Downloads section,
and get SP8 for JET 4. From memory, you cannot just copy from one to the
other, as the SP is ...