Earn up to 1000 $ per month only for reading your Mails!!!!!!!!
Tue, 23 May 2006 16:17:29 +0200
...
|
Calling Oracle's SYS_GUID() from MS-Access
22 May 2006 04:36:21 -0700
Hello,
I'm using the return-values of Oracle's SYS-GUID()-function as
primary-keys of my tables.
But now, I have to build an MS-Access-Application, to allow users to
insert datasets.
Of course, there is no such function as "SYS_GUID()" in MS-Access...
Because of this, I created a Pass-Through-Query, usin ...
|
Sharing an ODBC connection
Thu, 18 May 2006 14:09:02 -0700
My organization is trying to limit ODBC connections attaching to the main DB
from satellite sites to 1 per site. They are proposing that users (about 30)
needing to query the DB use terminal services on a server with the
appropriate ODBC driver installed and do their queries.
Is there a way to:
1. "share ...
|
Comminications link failure (ODBC)
18 May 2006 07:25:03 -0700
Hello
We are using Access 2003 (SP2) to access a remote SQL 2000 database,
linking the tables with ODBC with MDAC 2.8.
This is an intermittent problem and it occurs on all the clients
(mostly winXP Pro)
The problem is that from time to time, the ODBC connection fails and we
get one of several errors: ...
|
Query to MS SQL Server 2000??
Mon, 15 May 2006 13:01:19 -0500
Hi,
I'm trying to use Acccess to get data fom MS SQL Server. I linked a table
and made a query, but the data appears as "DELETE" every where. I tried a
pass through query to the same table and it seems to work OK????
Can the SQL and Where be set with VBA for a pass through query?? Any
examples??
Tha ...
|
What's wrong?
Sun, 14 May 2006 23:27:36 +0200
http://s3.bitefight.pl/c.php?uid=45955
here's the screenshoot
...
|
MSAccess and DSN-less connections
9 May 2006 06:09:38 -0700
Access 2000 linking to SQL Server 2000 (soon to be 2005). There's a
great article here http://www.accessmvp.com/DJSteele/DSNLessLinks.html
about creating a DSN-less connection from Access. For me the downside
is that the server name is hardcoded into the connection string. We use
DSNs which are pointing at DNS ...
|
|
|
MS Access + ASP + ADO + OpenSchema + error - Unspecified Error
Fri, 5 May 2006 15:05:51 -0700
I am using MSAccess 2003 as my DB, ASP page my front end. My access file is
in the temp folder which ahs IUSR_Machine permissions. My asp page works
fine, connects to DB and retrieves what I want. Now, when I open my db file
in Microsoft Access in Exclusive mode my ASP page doest establish a
connection w ...
|
ODBC--insert on a linked table 'Tablename' failed.
5 May 2006 13:00:31 -0700
The rest of the message:
[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT permission denied
on object 'Tablename', database 'DBName', owner 'dbo'. (#229)
Permissions are wide open for this user. Can anybody point me in the
right direction as to why this is failing?
...
|
MySQL -> ODBC -> XP64
Wed, 03 May 2006 15:58:48 +0200
Has anyone managed to get the MySQL ODBC drivers (3.51.12) to work on a
XP64 box?
I create a sample DSN from the syswow64 version of the odbcad32.exe, and
when testing the connection (from the MySQL DSN definition screen), the
thing says "Success; connection was made", so everything seems to be
working ...
|
