Run table from code without object designer

mdPartnerNL

A customer wants to run the table directly to get at the raw data.

But without the rights to object designer.

Possible?

ara3n

yes. He can click on Start->Run and type the Dynamicsnav:////runpage?page=nn

You have to create a page for the table.

SeeSharp

ara3n wrote: »

yes. He can click on Start->Run and type the Dynamicsnav:////runpage?page=nn

You have to create a page for the table.

That doesn't account for any additional columns added to the table though and adds an overheard of maintaing?

Why not do:

dynamicsnav://[server]:[port]/[instance]//runtable?table=[tableNo]

Or does that require Object Designer permissions? If it does, ara3n's answer is correct.

mdPartnerNL

he this is the classic client, does runtable work too?

kriki

For the classic client, you need access to the object designer. But you can give him only execute rights on the objects (table,form,report,...) and read access to the tabledata.
Otherwise:create a form and put all fields on it (and make the form NON-editable)

SeeSharp

mdPartnerNL wrote: »

he this is the classic client, does runtable work too?

Oh, sorry, didn't realise I'd wandered into here. Sorry!

mdPartnerNL

no problem, thanks all, i see this as solved (but where is this flag?)

rocatis

Use ODBC.

aseigle

why not use data migration?

Chakraborty

Sometimes we are using excel to view NAV data(SQL Server). Connect NAV Table on SQL Server as "Other data source" from MS Excel.

joshuasung

Export to CSV