Is there any session in ERP where I can set the path to the tables? (With W2k and SQL SERver). I remember something like that in c4 and tabase?

Thanks
Spartacus

Spartacus,

What do you mean by "set the path to the tables?"

Please explain

NPRao

I think in c4 there was something like "set table directories". In that session you can set, or check the path to your tables. For example: /baan/tables/200/<some-table>.

The sence of my question: Im at a W2k System with sql server, and need to know, where the tables are physicaly stored. If I found that I would like to check permissions of files and folder of that path.

But I'm not sure if that is possible with the current system.


Spartacus

Spartacus,

Your tables are stored in database files if you are using SQL-server. Check the SQL-server manager (Entreprise Manager?) to see where the actual db-files are located. The 'path-to-tables' is only valid for UNIX system running the old BISAM database system.

patvdv

thanks, that will help.


Spartacus

In Baan app:

The path to your table within the db server is found in tabledef6.1.

In SQL Server:

The db name is baandb. The tables can be found by opening the Enterprise Manager. I normally set the owner of the db as baandb user. So if you look at Security its says baandb is dbo (dbowner). He should have the sysadmin permission.

The rest of your users including baan shall have default db as baandb, with roles "public" and "baandbg".