Recent content by NeotheOne

Hi, I'm porting an Access application composed by a file containing forms, report, ecc. and a file containing data from Access to Sql Server. I've loaded all the data in Sql Server and relinked the table to them. All existing indexes has been created too. Now, accessing forms on Access I can...

Hi Denny, This is really the only solution ? So every user who needs to access data by a view to another database needs also to be enabled to the remote db ?!?!? I think in this case a view lost much of its usefulness... Probably I'ven't really understood db chaining settings. Which is the...

Hi, A looked at thread, and some others concerning the same issue, but there is something I can't understand. I've 2 db, db1 and db2. With user user1, db_owner on both db, I create table2 on db2 and then a view1 on db1 to access table2 on db2. Then I create user2 with no access to db2, and I...

Hi all, I've a view on database db1 created to access data contained on a table on database db2. The owner of the view has permission to create it and to access db2. So everything works until I try to access my view with another db1 user with no permission on db2. This is normal ? Is there any...

Hi all, I've an issue about parsing dynamic statement. I wrote a stored procedure that execute statement built on the fly. The problem is that if the statement string contains certain character the execution fail. For instance the ' char. My question is: is there any extended or system stored...

Hi, I'm developing my first Smartdevice application for Pocket PC and I experienced a strange behavior about tabcontrol. I've a form with a tabcontrol that contains 5 tabpages. Sometimes the order of the tabpages change automatically and randomly at run-time. And when this happens, sometimes the...

Hi I wrote an event handler to manage the click event for ten buttons that work all in the same manner. The problem is: when event is triggered and the handler start how can I know which of the 10 button has been clicked ? Thanks

Hi all, I'm a rookie so please be patient ;-) I need to know if and how I can deploy an application made by Access 2000, without installing MS Access to the end-user pc. Is there some kind of set-up wizard can I use that allow to install only needed components ? Thanks Best regards

Hi, Here is my problem. I need to read the tables list from a linked server database in order to copy the content of some table, one by one, but I don't know how to fetch the SP_TABLES_EX result set to do it. Someone could help me ? Thanks