Hi,
I currently use Access XP to query the companies database system (based on Adaptive Server Anywhere 7 - 7.0.2).
Most of the work I do will involve sending dataset's to other members of staff who can then run the query to generate reports.
I have a SQL Server installation which is not currently used. How would I go about linking Sybase tables?
The reason I am looking at SQL Server is because Access does tend to crash when performing more intensive queries etc. I have also looked at other third party products, but these have a number of disadvantages: the main one being
cost and compatability with Office suite.
Regards
Naz
I currently use Access XP to query the companies database system (based on Adaptive Server Anywhere 7 - 7.0.2).
Most of the work I do will involve sending dataset's to other members of staff who can then run the query to generate reports.
I have a SQL Server installation which is not currently used. How would I go about linking Sybase tables?
The reason I am looking at SQL Server is because Access does tend to crash when performing more intensive queries etc. I have also looked at other third party products, but these have a number of disadvantages: the main one being
cost and compatability with Office suite.
Regards
Naz