Dear all

I know there might be threads regarding this issue before. But I cannot find it.

My question is what are the options I have if I want to access the data in Baan without occupying one Baan license.

I want my managers to have a screen to display reports and my salesmen to access display sessions on the items quantity on hand.

What are the ways I have to do so without increasing baan license. I am not good at VB, so please suggest other ways.

Thanks and regards,

Create a user with only read permission at Database level.
Configure ODBC.

Use access, you can use link external tables functionality to select the tables you want to query for Baan database.

Write a query in access.(using a very user friendly Query Wizard of Access). Use can now use this query for the information they need.

If you have web programming experience, you can create a display pages on the intranet site.

Hope this helps

But there are third party query tools out there that can help you in your quest.

Here is a list of freebees (http://www.snapfiles.com/freeware/webpublish/fwsqltools.html), but you might also want to look at AQT (Advanced Query Tool) and the likes.

If u configure ODBC access for users who need baan data from MS SQL server , u can create SQL query once and get data in Excel using import data wizard . No prior VB knowledge is required .