PHP ODBC / DAP Access DB
Thu, 3 Nov 2005 14:20:06 +0100
I have an AccesDB (2000 Jet4.0) where I store content for my intranet
webpage. For administering the content I use Iexplorer 6.0 and
DataAccessPages. I display the content with dynamic pages (PHP) which
is connected to the DB through ODBC (Newest servicepacks and drivers).
The whole system worked very well for ...
|
ODBC & SQL
Tue, 01 Nov 2005 14:50:46 -0600
I am using Access 2003 with an ODBC connection to a MS SQL database.
When I make a change to a record on a form, I always get a write confict
dialog stating that the record was changed by another user. I am the
only one using the db at this time so I know this is not correct. Is
there a way to correct th ...
|
OOBC, Access, Postgres
31 Oct 2005 14:49:33 -0800
Hello,
I have a database application to be used in a multiuser environment.
The Access file resides on 1 server and it contains forms, reports,
queries, etc. The data resides on a Postgres server which Access links
to using a system DSN. My question is, if I am not consistent in naming
the DSN's the same w ...
|
Gracias por todo, me ha servido de ayuda 0EGU
Mon, 31 Oct 2005 09:51:57 GMT
---
Mafe huxuye bedib dep pomaset vep netisoled hasewocip mip tipocuce da tufacepo romi codamata sirotenec metelo ranesi vevesotavi nomulali doce fenis gitowefo soxilam reyofemit .
...
|
ODBC function sequence error after converting from Acc 97 to Acc 2
Fri, 28 Oct 2005 11:51:01 -0700
After converting an Access97 database to Access 2000, the append queries do
not work
The append queries select fields from pass-through queries that use an ODBC
connection to an external database.
The queries are of the form .
INSERT INTO myTable ( field1, field2, ...)
SELECT DISTINCTROW passthru-que ...
|
Porting SQL Server Stored Procedure to Microsoft Access
28 Oct 2005 06:37:51 -0700
Hi all,
Is it possible to port a SQL Server Stored Procedure with Output
parameter to Microsoft Access Query?
Currently, i'm having problem porting the below SQL Server stored
procedure to MS Access
Create Procedure myProcedure
(
@CustID int
@CustName nvarchar(50) OUTPUT
}
As
Select
@CustName ...
|
ODBC connection
Fri, 28 Oct 2005 19:02:56 +0800
i have setup a Access application with MsSQL server.
Now i have to setup ODBC connection at each XP workstations.
any better method to setup this connection at once rather than do it at each
workstations?
Thanks a lot.
tony
...
|
|
|
Connecting to Sybase
Thu, 27 Oct 2005 14:28:35 -0700
I'm trying to link to an Adaptive Server Anywhere 9.0 db in Access 2K
code:
Dim ConnectString As String, MyDB As DAO.Database, MyTDF As
DAO.TableDef
Dim LocalName As String, ForeignName As String
ConnectString = "Connect=ODBC;Database=GIDS;DSN=GIDSHome;"
LocalName = "dbo_TktRemarks"
ForeignName = "dbo.Tkt ...
|
3167 record deleted error
27 Oct 2005 09:01:57 -0700
HI,
i have an access MDB linked by ODBC to SQL2k.
I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from "LEFT OUTER JOINED" SQL tables.
If the related table hasn't related record to the first table,
it get an Error 3167.
This behaviour is not present with MDB tables JOINS.
Who ...
|
Prompt for UID & PWD
Thu, 27 Oct 2005 15:08:04 GMT
Public Sub PromptConnect()
Dim WkspcODBC As Workspace, NewCon As Connection
'Create ODBC workspace
Set WkspcODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
'Open New Connection to JayRemote
Set NewCon = WkspcODBC.OpenConnection("Test1", dbDriverPrompt, False, "ODBC;DSN=JayRem ...
|
