Search results for query: *

Hello! I happened to make a replica of my database. I am working in my designmodel but if I want to change a table it is not allowed because it is linked... How can I remove the replica and just keep one database? I want to get rid of the little icons in front of my tables, queries etc.

Thanks anyway. By the way I still had the backup of 2 days before, so damage is limited. But I would like to avoid this problem in the future. I guess something went wrong while compressing. RJ

Goodmorning from Holland! This morning I opened my dbase which normally is ± 52.000 MB, now it is only 41.000 MB and half of my tables is lost. Until compression and closure yesterday evening it worked fine. But the backup of this morning also has only the 41.000 MB. How come?? Thanks in...

Good afternoon from Holland! My problem is: When using an ODBC link from MS Acces to an AS400 database I miss several fields in some tables. These fields are visible when using 'filetransfer' in AS400 itself. For example: a table has 10 fields A1 - A10. Via file transfer all fields can be...

Sorry, just found post of yesterday on same subject. Thanks anyway!

Maybe stupid question... how can I change the server's system time?? Thanks in advance, RJ

I guess we really need a new AS400 with up-to-date software... 5722 range is not present. Before the end of the year we will have a new one, I assume these programs are with that. RJ

Dear flapeyre, Thanks for your clear answer. But how can I enter the command. My system gives the following: "Command WRKMBRPDM not found in library *LIBL" I am logged in as security officer. Best regards, RJ

Hello from Holland! I use WRKJOBSCDE for scheduling several queries. Is it possible to run more queries in one RUNQRY command? My command screen looks as follows (in Dutch, but I guess the screen is the same...) Naam taak . . . . . . . . . . . > RJDING1 Naam...

Thanks Syates, It works except in those cases where the date is blank. AS400 seems not to be able to handle a blank date. I work with ending dates of contracts. Contracts that are still running have a day 0, month 0 and year 0. Best regards, RJ

I have a report with 4 subreports. The first 2 lines of the 4th subreport start on the bottom of the page and the next lines appear only on the half of the next page. How do I solve this? RJ

I work through an ODBC from AS400 to MS Access. In my AS400 system I have a table called "ABCCUST" which is in a library called "ABCLIB". Now I want to approach a "sub"table (copy of "ABCCUST") in "ABCCUST" which is called "ABTCUST&quot...

My problem is that there are 3 fields. I am now trying to make subqueries in AS400 to get rid of "zero" fields.

Hello from Holland! I try to convert a date from AS400 query to MS Access through an ODBC. Fields are as follows: LKINGD (day) LKINGM (month) and LKINGJ (year). The desired result is: dd/mm/yy or dd-mm-yy. I use the following formula in AS400 query...

Hello from Holland! I try to convert a date from AS400 query to MS Access through an ODBC. Fields are as follows: LKINGD (day) LKINGM (month) and LKINGJ (year). The desired result is: dd/mm/yy or dd-mm-yy. I use the following formula in AS400 query...