Hello,

I have an access database .mdb that has linked tables. For some reason, the linked tables are not showing up in the SQL Explorer and queries fail when I enter a linked table in a Task with SQL Text.

Any workarounds available for this?

Thanks.

We have no experience on that but it seems like either a permissions issue or that those linked tables are not shared when using ODBC or OLEDB.

---

may be an oledb issue as it doesn't seem to handle linked tables (if that is how visualcron is creating the connection internally). not sure though.

http://www.oblique.ch/ms/ADOX_Faq.html 

I have my datasource setup as odbc, and it seems to work everywhere else i use it, but not through visualcron unfortunately.

thanks.

What about the connection string? Are you using OLEDB or ODBC? You select this yourself.

Are you using a Credential? Try using the same user as you normally login as.

---

i've tried many combinations of oledb, odbc, and credentials, but it just doesn't seem to work.

the sql explorer shows tables that I don't see in MS Access (i.e. MSysAccessObjects, MSysAccessXML, MSysObjects, MSysQueries). So the tool seems to be presenting a "raw" results of what is in the Access table and not showing any linked tables.

And also, the queries randomly show up in either the Views or Stored Procedures tree. 15 queries show up in Views and 12 show up in Stored Procedures.

Is there any other way i can pipe database results into VisualCron?

My end result, is to send a notification if the value from the database is greater than 0.

Thanks.