Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
RE: MaxDB and Access
From: Döhr, Markus ICC-H (Markus.Doehrsiegenia-aubi.com)
Date: Fri Mar 24 2006 - 16:03:05 CST
> One current issue is this. Using Access as the front end and
> ODBC it takes a long time to open an attached MaxDB table and
> a table with only 5 records in it takes minutes to delete one
> record. Is this an ODBC problem a MaxDB problem. What can I
> do to fix this. I want to continue to use the application I
> have with an Access 2003 front end. It can be on either
> client machines or the 2003 server. In either case it must
> link to the MaxDB tables and work with acceptable speed.
Is you name resolution work in both directions? Means, can the server
reverse lookup the name of the IP address that is connecting?
Check on your local system (with Access):
# nslookup <ip address of server>
This should give you the servers name.
Try the same thing on the server for the IP-Addresse of your machine.
Tel.: +49 6503 917-152
Fax: +49 6503 917-7152
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb