Recent content by Kuhn

thanks for the suggestions guys. absolutely right on the error handling, allready started to look at it step by step. there are more than 1 reason why a db is corrupt, and also different behavior. I have isolated a corrupt one (where the script was blocked), and indeed, compact and repair did...

hi guys, I found 2 procedures that I combined, first one lists all accdb files on a certain network drive, second one lists all the tables in that DB and some info I need (rows, field count, index count). It worked find on the first network drive, detecting over 80 db's and listing over a...

nvrmind I decided to ditch the old form and created a better one, works fine now. this can be closed.

to be clear: CTR_ID is a short text column, the ID's can contain text.

ah sorry,I did put the 'as string' for each variable. I did not put the whole code, just some snippits, because there is some other stuff going on as well. I did not write the original code to this form, just lucky to inherit this from someone... seek_ctr is actually just a string with a...

hello, I have a form with behind it a dataset (a linked table from another ACCESS DB). On the form I have a button with an input box for a search function, which show the searched record (based on a value CTR_ID from the table. however this button crashes (90% of the time). I have found where...

thanks for that - I rewrote the code that selected the record, and filtered down the data using SQL as suggested. that did the trick! also big thx to the person that posted that link to the migration tool - it will save me a lot of time, esp. index-wise !

thx, that's what I was afraid of. well, looks like I got my work cut out for me...

thx guys. Will watch the video now. the search function does use the (dim rst as DAO.recordset) rst.movefirst command and searching for a certain value. I think I will first have to do some table cleaning as well (loads of unnecessary 255 char txt columns, and even long text). hopefully that...

Hello, We're in the process of migrating our systems from access to another environment. One of the first steps is to move our main tables that became too big to handle in access to an SQL environment, as a temp solution in transition to the new environment. Performing simple queries on the...

the DB is ran once a month, I tried the backup file from last month and get the same error...it worked fine last month though

hi everyone, we have encountered a serious problem with one of our most important DB's. as soon as we try to open anything like the developer, decompile, save as, compact and repair, link to the db from another db,... we get this error msg - The database cannot be opened because the VBA...

fantastic - thanks a lot ! you just saved me hours of pointless work :)

thanks! however this overwrites the same TXT file over and over (leaving me with just the info from the last table). Tried to transfer that code to the first part, but no success.

Hi all, I a trying to list all fields from ALL tables in a certain DB. I am using the tableinfo function. However, because the output of the immediate window is limited to 200 lines, I can only see the last 200 fields. Is there a way to export this in another way than the debug.print...