Recent content by qqq

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...