Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

For an Access 2003 application, how can we tell how it connects to it’s Sybase Datasource?

Posted on 2016-09-23
1
Medium Priority
?
55 Views
Last Modified: 2016-09-23
We have a legacy MS Access 2003 application.

How can we tell how it connects to it’s Sybase Datasource?
0
Comment
Question by:zimmer9
1 Comment
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 41813119
That might be a complicated question, but for starters, you can look at the tabledefs connect property:

1. Go to the VBA edit (Alt/F11).
2. Bring up the debug window (Ctrl/G).
3. Type

? CurrentDB().TableDefs("mytablenamehere").Connect

 and hit return.

 The driver may or may not be listed depending on the connect string (it may point to a DSN which has the driver info).
 
 It will start with ODBC though.

 copy and paste what you see here.

Jim.
1

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question