Search results

Odd. Doesn't sound like normal behavior. A few things you can try to clean it up: - MAKE A BACKUP! - Decompile the app (www.fmsinc.com/microsoftaccess/performance/decompile.asp) - Import everything into a new db and try again (decompile usually takes care of the same thing this would though)...

It's not uncommon at all for developers to fall into the DBA role, so that's worth keeping in mind. My sentiment about focusing more on usage rather than administration comes with the assumption that you're staying in application development, but a good DBA is really quite invaluable, so there...

SQL Server does tend to be the next technology in most Access developer's path, but really just the basics of it. SQL (be it SQL Server or any other robust RDBMS) tends to come in two parts: DBA level stuff (administering) and Application level stuff (what we as Access devs are used to). If...

Most times for development I'll try early binding first, then switch to late binding for testing/distribution. Perhaps you could try that (add a reference to Outlook and change your Object types to their appropriate strong types, develop and test it all, then change back to Object). Also, just...

Could you post a screenshot of the warning? I can't seem to conjure up a mental image.

Have you looked at the ODBC error itself to see what the server is responding with? Set up an error handler and when you get the VBA ODBC error (usually 3146, IIRC), check this: ?DAO.Errors(0).Description That's where the server errors are reported (there may be more than one, but usually...

Despite my last post (which covers end to end), this sounds like a sane approach. Sometimes migrations can be huge jobs (I have a brother in law that's been working on one for Unilever for two years), and taking it in chunks like this can keep us from getting overwhelmed. Just be careful you...

That's not quite the process, no... what plog mentioned is very important: the final table should be normalized (if you're not familiar with the concept, that'd be square 1: read up a bit on it). In a normalized table, you will not have one table per year: rather you will have one table that...

Often times importing is messy: external data is rarely ever cleaned up the way we really like. You can take any approach really: clean it all up in excel first, them import, or import into temporary tables, clean those up, then move it to final tables, etc. My general preference is to import...

What's the message you get trying to open it? Corruption is a tough one to guess at but certain errors are indicative of certain kinds of corruption and can (maybe) give us a clue as to which direction to start in.

Looking forward to it myself. It'll be my first trip to that side of the pond.

I was going to say that it's because if I need multiple instances, I need to manage them externally, but it occurs to me that this may very well just be a byproduct of the way I manage them and don't actually need the external reference at all. Food for thought! (for me, I mean)

I've generally preferred dictionaries over collections for ease of use, but never liked that I had to late bind or include the scripting reference. A while back I found the drop in class (see post 19) that works very well, but these days it's rare I do a VBA project from scratch, so usually...

ChrisO had some really nice examples of drag/drop resizable (drag) rectangles on forms in an code archive post over at UA (he might have had them here as well, not sure). Looks like a very similar concept, except in the videos it's as if they're constrained to a grid. I think - going off...

There's some more info here in a recent thread on the same topic: https://www.access-programmers.co.uk/forums/showthread.php?t=297552

For #1, many people opt to use the Windows Task Scheduler and fire off a bat/cmd file which in turn starts up Access with an /x switch to run a specific macro which in turn calls your entry function. Myself, I've found this to be very finicky, but it can usually be bludgeoned into place if need...

That's the type of approach that would have me cursing the developer who wrote it when I was finally able to track down what was going on (it is quite clever though, I wouldn't have thought of it). Like Galaxiom, I tend to feel that it's better to be able to explicitly have a reference...

As an aside to the thread, there's a nice drop-in Dictionary class here: https://github.com/VBA-tools/VBA-Dictionary

You have to open the actual msaccess.exe executable, and pass the path of the file to be opened, along with any commandline parameters as you've shown. The issue here is finding the executable path reliably as it's not always in the same place depending on what environment (and installer...

Hello - I'm not sure offhand about action center information from Access (my guess would be that this is possible via API calls, but I haven't looked yet...). Can you offer any direction on what you've tried so we have some sort of starting point? Regarding "background processing" - have you...