Database queries

[progdlp]

We are trying to pull Microsoft Office inventory access from the Lansweeper program. We currently have some configuration databases set up that are pulled from another inventory system that we have. The person who does the reports pulls the data automatically using an odbc connection. That way she can do her queries based on her experience and expertise. We attempted to do this with the lansweeperdb file but they were all empty after the import. The current report builder in lansweeper is not working for her. We need to know if there is a way that we can directly access the database from access using an odbc connection. I have also put scans into lansweeper to scan for winword.exe but cannot figure out how to get that information either. We have a deadline on an audit and need this asap. Thank you.

[Hemoco]

Please contact us by e-mail for further assistance (lansweeper@hemoco.com)
And provide screenshots of your problems.

[progdlp]

Also I keep getting an error that the sql server does not exist. I am using lansweeperdb and choosing to import odbc from the afafg-pp-lanw01 server where sql express and the lansweeper application resides. Not sure what I am doing wrong. Tried to do what you suggested about opening a project but was that in access or in lansweeper. I am not very experienced with access. I need to know details about the exact steps on this. When the database was on a different sql server separate from lansweeper I could pull in dbo files but they were all empty. That was for our Access guru as well. Please help.

[progdlp]

She tried the % and the *. It kept giving an empty report. She was double clicking on the table which gave the relationship box and she checked the fields she wanted and tried to query for 'microsoft%' and some other ways and it did not give her anything.

[progdlp]

For some reason the queries would not work right for her. She is very experienced with access and she tried to use some of the queries that she uses in access and they would not work even with a wild card.

[Hemoco]

progdlp wrote:
For some reason the queries would not work right for her. She is very experienced with access and she tried to use some of the queries that she uses in access and they would not work even with a wild card.

Most likely cause: the wildcard in access is '*' in sql server it's '%'

[Hemoco]

An odbc connection should work like on any other database.

What you can also do in access:

Create a new "data" project (file/new,project using existing data)
Connect to the lansweeper database.

You should see everything in a familiar MSaccess screen.

What is the exact problem with the report builder?