Developer forum

Forum » Development » Databasepublicering

Databasepublicering

E-mail notifications

Reply
Posted on 11/12/2008 16:34:02

When I try accessing [AccessUser] tabel . I get the following statment:

 

"Warning: Incorrect sql statement"

 

Other tabels works fine, but not this one.

 

Any suggestions, why?

 


Replies

 
Posted on 11/12/2008 16:37:10
Reply

This is a limitation by design to avoid publishing login information for all users especially backend users. Set up a view on the SQL server or query on the mdb file and use that as source for your publishing instead.

 
Posted on 11/12/2008 16:56:12
Reply
Sorensen wrote:

This is a limitation by design to avoid publishing login information for all users especially backend users. Set up a view on the SQL server or query on the mdb file and use that as source for your publishing instead.


 

Hi Lars

 

Thanks for the quick answer! :)

 

What exactly do you mean by " Set up a view on the SQL server "

 

How do I do that without the databasepublicering module?

 

I need to collect all AccessUser info and store it in a csv. fil. 4 times every hour.

 

Thanks again

 

- Rasmus

 

You must be logged in to post in the forum