|
End users in my company frequently use Microsoft Query (through Excel) to perform ad-hoc queries of selected SQL Server databases. As we move to SQL Server 2005 on the backend, we are discovering that MS Query lists all objects from all schemas, regardless...
Started by Ed Leighton-Dick on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
Microsoft Query does a call to [database].sys.sp_tables which in turn.
No, not that I've ever found.
|
|
So I have learned a bit about databases and Microsoft Access specifically, trying to help maintain a Microsoft Office Access 2003 database with Visual Basic scripting (version 6.5) which was set up by several people who are no longer with the company....
Answer Snippets (Read the full thread at stackoverflow):
If the query is in the current.
A reference to an Access mde or mdb? Does the code create the query and then delete the query, you can search for the two queries by name in the code, and see what it turns up.
|
|
I am using pyodbc, via Microsoft Jet, to access the data in a Microsoft Access 2003 database from a Python program.
The Microsoft Access database comes from a third-party; I am only reading the data.
I have generally been having success in extracting ...
Started by Oddthinking on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
PYODBC starts with autocommit = False and therefore every ....
I guess the problem may be that you did not commit the query.
You have the same problem with other ODBC tools, for example Query Tool ? You can also turn on ODBC corruption.
|
Ask your Facebook Friends
|
On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around it by using temporary tables, but I'm wondering if there's a better way. All the tables involved have a primary key. Here...
Started by Knox on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For some://support.microsoft.com/default....
Seriously consider switching to a more capable SQL product.
I'm afraid you're out of luck without an updatable query" are very painful.
The Jet query optimizer treats it the same way it treats a join.
|
|
We're developing a product that relies on the Microsoft Sync Framework to keep the data on a client app and on the server in sync. What we have noticed is when syncing about 16 tables and ~2200 records it will take about 4 minutes, which is not acceptable...
Started by John Boker on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Enable Sync Framework database providers to perform as well as other Microsoft technologies like.
|
|
I have a (very simple and standard) UPDATE statement which works fine either directly in Query Analyser, or executed as a stored procedure in Query Analyser.
UPDATE A SET A.field1 = B.col1 , A.field2 = B.col2 FROM tblA AS A INNER JOIN tblB AS B ON A.pk...
Started by joedotnot on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Http://....
Before you start the trace associated with when the fail .
Also, I think you when you execute from access?
Run the query with SQL PRofiler running.
Try and see whether the query gets executed on the SQL Server using SQL profiler.
|
|
I have basically the same problem outlined in this question, however I am using Microsoft Access as a database instead of MySQL. The result of which is that SQL_CALC_FOUND_ROWS doesn't seem to be available to me. Believe me, I want to switch, but for ...
Started by dbingham on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Still, it should be faster than executing the query twice..
Read all the records.
|
|
I'd like to rewrite this query for Microsoft Access 2003:
SELECT t1.PERSONID ,t1.CARDEVENTDATE ,MIN(t1.CARDEVENTTIME1) AS Intime ,MAX(t2.CARDEVENTTIME1) AS Outtime FROM ( SELECT PERSONID , CARDEVENTDATE , FUNCTIONKEY , CONVERT(VARCHAR(10), SUBSTRING(CARDEVENTTIME...
Started by Gopal on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Can you not use the normal Access function Str(...) ?
Update: Dont have Access here to try it, but isn't there a parameter which tells Access to just use the sql as pass throught (without modifying it) ?
The sample below may suit, if you use SQL Server... .
|
|
Is it possible to configure multiple database servers (all hosting the same database) to execute a single query simultaneously?
I'm not asking about executing queries using multiple CPUs simultaneously - I know this it possible.
UPDATE
What I mean is ...
Started by chopeen on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It is possible using distributed queries to run a query that references both Server A and Server B, with each so that only ....
A distributed query runs across multiple servers and is typically.
The use of Distributed Queries.
|
|
I have a *.MDB database file, and I am wondering if it is possible or recommended to work against it using LINQ in C#. I am also wondering what some simple examples would look like.
I don't know a lot about LINQ, but my requirements for this task are ...
Started by Matthew Ruston on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
This makes object oriented access to your mdb extensions that will allow you to query the data with all that LINQ goodness we have become use.
What you need is the Microsoft Entity Framework.
|
