Search results for query: *

Hello Steve, we also had some problems when working on an Oracle database via MS Access client. We were able to eliminate this kind of problems by setting an ODBC timeout value to 0: HKLM\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC\ConnectionTimeout = 0 Try it ! Regards Hayo Thanks Hayo [pipe]

Great ! Thanks to Dagon for his version ! And thanks to Dima for the useful hint to include the EXECUTE statement. Now everything works fine. Thanks Hayo [pipe]

Hi Dima: Yes, I catch others in my procedure. And, Yes, the role is already granted to the user. Usually I am using packages, which are called from within the procedure. Here I provide a reduced version of my stored proc: CREATE OR REPLACE procedure SP_TEST_INVDB2 ( i_Userid IN VARCHAR2...

I do not understand your exact problem. Do you want to populate column6 for all already existing rows, or do you just want to maintain column6, when new rows are inserted, or if updates are done ? In both cases, you should be able to do that with a row trigger. You may code a trigger as...

Hello, I am using Oracle 8i on a server, and I want to submit a SET ROLE ... IDENTIFIED BY ... command from a stored procedure. What happens ? I start an SQL*Plus session, submit SET ROLE NONE to elimiate all roles. Then I check my session roles: SELECT * FROM SESSION_ROLES; and I have none...

I converted an Access97 app to Access2002 (n Windows XP). This app is secured, using a central application workgroup file. Now I have a strange effect on XP: Each time when I try to repai and compress the mdb, a messagebox pops up saying, "that the mdb-file coud not be used, because its...

I am using mailto: command (on XP) to send emails from a program. Everything works fine, but I do not know how to add an attachment. The following code works (without attachment): mailto:Danny?cc=ZXINTGFII001&Subject=German%20telephone%20data&Body=Hello Danny,%0Aplease find attached the latest...

Hi ! I have a program, which submits an email request as follows: mailto:Danny?cc=ZXINTGFII001?Subject=German%20telephone%20data?Body=Hello,%0Aplease find attached the latest data.%0ARegards%0AHayo?attach="\\pc0446\myData\mydata.txt" This command is being sent to ShellExecute, and...

Yes, thats it ! If I customize the setting for "classic view", then it works for both ! Thanks ! Hayo

When i press Start button, ant then All Programs, then only "often used" (or "last used") programs are shown. To see the other program, I have to click on some arrow. Is there a way to customize this behavior ? I want to see all my programs at once. Thanks Hayo

Thanks for your reply. What you said is clearly possible, but I implemented a lot of access privileges on the different objects ito the MDW-file. Therefore I am looking for some way of "coversion of the MDW-file". The error I get when trying to open the MDW-file may indicate thats...

Hi ! I have an AccessXP user i/f. Each user has to enter an Access password first, when starting the app. Now the app executes "autoexec" macro, where a main form is opened. On opening, a lot of database stuff (remote Oracle) is executed. Therefore, depending on the network traffic...

I am using an Access97 frontend to an Oracle database. A separate application workgroup file resides on a network share, implementing access control for the access user i/f. This workgroup file was created with Access97. Now I converted the Access97 user i/f to AccessXP (2002). The app is still...

Thanks for all your answers ! An important point is the ability to update the Excel sheet from MS Access, but also from MS Excel. Therefore I think, the idea to place a "'" in front of the column is appropriate (doing this with the technique shown by Jeff). If I apply that to the...

Hi Jeff and Isadore, thanks for your replies. Changing only the first value to text is NOT sufficient. I changed the first 4-5 to text, and it still converts to number ! I think the tip to insert a ' in front of >each< value looks good. But how can I easily do that in Excel, if I have a big...

This is NOT possible in my case. Let me explain the situation in more detail: I opened Access, then I goto External data, here I select &quot;link table&quot; (where I also select XLS type). I do NOT select &quot;import&quot; ! When I link an Excel-Sheet this way, I can update it in Access...

When linking Excel (XP) into Access (XP), I have a problem with the format of specific columns: They are set to &quot;Number&quot;, but I want them to be &quot;Text&quot; in Access. Is there a way to force Access to define them as text ? Most of the column values are numbers, but not all of...

I have an Access97 frontend for an Oracle database, which runs without problems on NT4. I installed Access97 on an XP-machine, and got the mdb frontend running on XP. Now I experience very strange errors, but only on XP: For some entries in the database (I found 4 up to now, there may be...

Hi Sean ! Please have a look at the following code. In this sample, I use &quot;DSN=inv_oradb&quot;. So I have to create an ODBC datasource before named &quot;inv_oradb&quot; (or any other name), which points to the Oracle database. This DSN is then used here to connect to Oracle. You may add...

In my access97 app, the run property for all queries is set to &quot;Owners&quot;. Now I want to upgrade the secured mdb-file to access 2002. For this purpose, I have to unsecure the mdb first. And in this context I read, that I should change all run permissions on queries to &quot;users&quot...