Recent content by Krava

Dear Richard! Thank you very much for your helpful answer. Well, I am probably going slightly mad, but I have tried this method last week and it did not work. Now, I tried it again and it works. So I am not really sure what is going on. But I suppose I have done some syntax mistake. Have to see...

Hello, Richard! I am back to you! All works fine, but I have one problem. The syntax you suggested works fine with SELECT of one table. If I created SELECT statement with INNER JOIN of two tables, I got the error message that the system cannot find the second table. Any clue or hint how to fix...

Hi, Banana! Well, I think I have made a mistake. In my test, I used SELECT statement and I think it is the problem. Concerning your suggestion about SSL I think it makes sense. Since I am not a specialist in this field I passed your suggestion to my colleauge and I am sure we will study it...

Dear Richard, dear Banana! I am back to you with some feedback. At first- thank you very much for you ruseful support! And- both suggested methods worked out well, I am very impressed. Thank you. Banana- only one unclear point is- what WITH ROLLUP statement means? Any specific function? I have...

Dear Banana! Thank you for your suggestions. Well, we do not use ADP. Normally, we distribute MDE clients. Why ADODC? It was only the idea as we have experience with it in VB6.0 developing. We developed a hige system for collecting the data from production (BarCodes) and we store it into MS SQL...

Dear Banana! Thank you for your quick reply. I am not quite sure with the first part of your reply. Concerning the second part- I have done following: 1) I have placed ADODC ActiveX DataControl object on one Form. I set up Connection string (working) and its RecordSource as "StoredProcedure" and...

Hi, folks! I am fighting with one idea with no success. I have a data in MySQL (MS SQL) and the access client, normally with linked tables in it. But is it possible that I have a chance to avoid linked tables at all and to set up (somehow) the datasource/recorsource for forms and its objects...

Hello, George! Thank you for your reply. Well, we have developped many applications, but only a few of them are, I would say, critical. I will try someting concerning Table security and I will see. I will keep you informed. Regards Krava

Hi, folks! I spent some time by reading a different threats concerning this matter. To be honest- I did not find the answer I was looking for. We develop the application always this way: 1) The data is store on the server in MDB file, password protected 2) The client application does not...

Hi, folks! It took me some time but I have tried and it works fine! Thank you very much for your great help! Kind regards Krava

Hello, gentlemen! Thank you for your help! We will try and I will let you know. With only best regards Krava.

Hi folks! I have a problem I could not find in the forum, but maybe I used a wrong words in criteria. So- does somebody know how to avoid opening the same Access instance (the same client) twice (or multiple) on the sam PC at the same time? I need to get some checking mechanism that would not...

Hi, Pleasure! Thank you for your idea! I will try it and I will let you know. With only best regards Krava

Hi! Thanks for the answer. Maybe I am looking at my problem from wrong direction. I cannot print (I cannot manage) on the printer because if I use the system settings (Windows) and driver it offers me only A4, A5, Envelop etc. sizes of the media. Of course, in the report I can setup my...

Sorry, I did not get that.