Search results

hm. Any idea how to check for any connections I have missed to close before doing a backup?

Brief update from my side: have been watching precisely, on what occcasions corruption occurs. Seems it does goes corrupte DUE TO CREATING A BACKUP, i.e. I can edit, open and close the accdb file as much as I want. But if I close it and wait only a few seconds before creating a backup copy of...

sensetech, yes, I've moved to accdb - minor improvements though. PC is off-the-shelf, nothing particularly meaty (2013's thinkpad x230). Another thought occured to me: I am using a Windows batch file to create a copy of the (closed) accdb file and save it with a timestamp in its file name...

Thanks so far. Have re-imported everything to a new file several times, no change. Converting it to an mde (or equivalent) will not work, since the problem occurs while editing forms/reports. This is somethin I obviously can't do in mde, so I will need to work with the open files. What I've...

Hi, we are running a pretty extensive DB, evolved out of 10 years of incremental development, today consisting of accdb frontend with MySQL backend (linked tables). I am increasingly facing corruption while editing forms / reports, and am trying to find out why corruption occurs at all. I...

Hi sorry for responding only now - sorry, never actually got to test dtSearch, in the end we managed with a standa-alone serach engine without a VBA interface. Regards, Marcus

Re: UNION ALL query works fine - but "too complex" for a report's record source? Simon, am not sure I'm getting your first question right. tblaccount and tblaccountmis are similar in structure (some fields identical), however tblaccount is an export of our accounting system (overwritten once...

UNION ALL query works fine - but "too complex" for a report's record source? Hi there, have been using the following SQL as record source for a report while still in Access 2003. Since moving to Access 2010 the report won't accept the SQL as a record source anymore - even though the SQL works...

Hi datagirl sorry for the late reply, haven't been checking for a while. As far as I know dtsearch would have been an excellent match, the price being a bit of a downside. In the end we however did not go for it, but people started to use google desktop / LAN search. I still think a full...

Hi there, thanks for the helpful code about error trapping. Is there a way of retrieving automatically the name of the procedure, where the error occurred? This would allow to locate the error quickly in an error message, without having to type in the procedure name in the error trapping...

I thought the code I posted earlier contained connection string already: Set conPubs = wrkODBC.OpenConnection("c", dbDriverNoPrompt, , "ODBC;DATABASE=MyDatabase;DSN=MyConnection;UID=MyUser;PWD=MyPassword") Anyway using a dlookup for the connection check works fine now. qqq

found workaround Hi Banana thanks for your assistance, sorry for the delayed reply (I thought I had posted back long since). Seems like I found a simple workaround in the mean time: as you propose I just use one of the existing table links to check for the connection. This previously didn't...

Hi there I am using the following function to check if the ODBC-connection is available each time the user runs the application. A few weeks it started to give wrong results: when i run the function right after starting the application it sometimes (not always) faces an odbc-connection error...

thanks, that's what I hope dtsearch does. I was wondering if anyone knew another tool... doesn't seem so.

Thanks DocMan for that impressive response and calculation. Am convinced that "building" is not really the solution (I do not intend to spend the rest of my life with this). However, dtsearch engine (the one I mentioned above) does provide such functionality, and afterall google does, too...

Thanks again, but the magic thing I am looking for should not only search file/folder names, but search (and index) file content. I would be closer to google desktop search (which has an indexing crawler) than the windows explorer (which I think doesn't have an index). Cheers, M

Thanks Guus, for the quick response. I would need something to crawl through several 100 GB for indexing, which I think is beyond the scope of the "search engine code" I could find on planetsourcecode. I think they have been built for searches within db-tables or for finding a file name in a...

Hi there, I would like to include a file search engine in my Access front end, allowing for an indexed search of all relevant files (doc, pdf, xls, txt) in our network, particularly our server. I have come across dtsearch (http://www.dtsearch.com/PLF_engine_2.html). What they offer is a fully...

solved finally!!!!!!!! Seems like I've finally come across the solution: It's Microsoft's Internet Explorer 7 interfering with the vertical controls, for whatever reason. Deinstalling IE 7 does the trick.

I am flipping column headings (editable text boxes) vertical to save width. While this works fine on most PCs in our network, some PCs refuse to display any vertical fields on a form or report. Any idea, hint? Thanks a lot in advance! Btw: all are using Access 2003, FE is Access 2000. qqq