Re: PLS Help. Linked tables in MS Access

hengky liwandouw wrote:
>
> 1. How can i know my ODBC driver version ?
My win is not in english, so the following is approximative : Go to the
windows configuration panel -> administration tools -> database sources
(ODBC) and look in the the ODBC driver tab.

> 2. How to run tcpdump ?
>From your *nix server ? Or from windows, install wireshark.

> 3. How to see Postgre SQL log, to see how fast it runs Access sql command ?
you have to tweak your psql config file in your server. if it is an
*nix, logs are probably in /var/log

> 4. Some times when user input data, my application show "#delete"
> records while no user delete record. How can this error appear ?
This is a really recurrent bug. There are plenty of information about
this in the ml.
Personnaly, I only use integer primary key, NOT NULL boolean and other
stuff I don't remember.
Access return #deleted because each time it insert or update a table's
entry , it check it :
- If it knows the PK, it will check with a "select * from yourTable
where PK=X"
- If it doesn't know it, it will do a select with all the datas it has :
if more than one entry or no entry are returned by psql, it will be
printed as #deleted in MSAccess.

Sorry if I'm not clear, but just run wireshark a study what's append,
you should anderstand quickly.

> 5. Could someone share his VBA code to connect from Access to PGSQL ? I
> think maybe something wrong with my VBA code that caused the "#delete"
> problem.

...
Dim qry As QueryDef
qry.Connect = "ODBC;DATABASE=dbName;DSN=ODBCName;UID=user;PWD=pass"
...

Cheers,

--
IoGuiX