link database

[Deen]

I've link my msaccess database to database from sybase server anywhere from
another pc. The problem I'am having is that my pc take time to show that
data. Can some help me to make the data show more faster.

 

[Arvin Meyer [MVP]]

Make sure that the indexes from the Sybase DB are being used, and that you
have the latest ODBC drivers.

 

[Deen]

Arvin,

I just links the table from exist Sybase server to view the data using my
msaccess. Actualy I dont have any permisson to open and dont have any
software to open that database. Can you make me clear how to make the sybase
indexes used ?

And are you talking about latest ODBC drivers from microsoft or from sybase ?

 

[Arvin Meyer [MVP]]

If you have an ODBC link, you have permissions to work in the data. Opening
directly is another matter. Usually own admins are allowed to do that.
Developers usually hand their work to an admin, who then check it and runs
the scripts.

What you'll need to do is have an admin create a stored procedure or view
that uses all the fields and indexes that you have permissions on, and give
you a list of them.

When you connect to the stored procs, they will look like tables in your
app. Make sure that your indexes match the list the admin gave you.

Whichever drivers that you are using, make sure that they are the latest
version. Then check both Sybase and Microsoft's knowledge bases to see if
there are any issues. Inform the Sybase admin if you find any.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Deen]

When you mention about the store procedure that looks like table, then I
realise that I already link to that database dan that work fine and not slow.

The problem is with the query. When I use format to the field from original
date yyyy/mm/dd to date dd/mm/yyyy, and using a parameter to call the record
from that link store procedure, that will take a long time for access to find
and display that record. I wish if there any way make this query work fast ?