Search results

BTW, your adVarBinary will need to be adLongVarBinary otherwise you'll get a truncation error from the server. (I just did this yesterday, borrowed the same bit of code)

With the exception of GoT, I haven't watched TV in probably 10 or 15 years (prefer to read), nor do I listen to any popular music (jazz and classical mostly for me, of which I play drums and piano, respectively). Therefore, I neither know nor really care much about celebrities. Doesn't seem to...

Sorry, not quite following. You're viewing their website running off their data and it's really slow? Or you have an Access app that's connected to a remote data set that they host? If it's the former, I can't see how it could possibly be an issue on your end. The latter, maybe, but I'll...

Twice this year I've run into a few cases where this type of thing occurs (a list update/entry added/removed) that could affect any number of other forms that might happen to be open at the same time. I set up an EventBus using custom events in a class for each event that I want to track...

Sounds right to me... if the data is coming from their server, your computer shouldn't have anything to do with it. It's either a) their server is slow, b) you have reduced bandwidth for the download, or c) maybe something crazy like your computer is completed tapped out in resources, but I'd...

We fought for years to have them supply basic templates that followed some sort of best practices (which I don't know if they ever did, actually), let alone actually enforce anything within the program itself. Nice thought, and I'd give it a vote, but I'd be less surprised by a talking penguin...

Try using the on-screen keyboard (as part of the Windows OS, not the tablet's one). I think you can run "osk.exe" from the commandline to open it, but it has been a while. If it's something you'll be doing a lot of, might be worth picking up a bluetooth keyboard for that has better programming...

I often find it very difficult to know how the engine will process this, and deciphering execution plans was never a strong point of mine, so that doesn't help either. I recall years ago in Access saving one query to use as the "base" and querying another on top of that, only to run into...

I wish this were a SQL Server thread, because I know so much more about it there than how JET/ACE handles it. In any case, if anyone's curious, I thought I'd throw out a mention to the book SQL Performance Explained by Marcus Winand. It's not for Access (in fact, not for any specific DB...

ADO.NET handles connection pooling internally on your behalf. The standard practice therefore is to open the connection only long enough you need to complete the operation you're doing. Internally, the connection (or even a number of them) may well stay open, so you're not handshaking with the...

I haven't run into an actual Flat Earther (or at least if I have, they've avoided the subject, which is probably not likely... they seem to be of the "INEEDTOLETEVERYKNOWHOWMUCHOFAMORONIAM!" bunch), but I'm pretty sure that if I did, I wouldn't waste my breath on a word of the subject.

It may be easier to ignore all of the relationships that are currently set up in Access, and re-apply them manually after the migration is complete. Aside from the issue you're seeing here, SQL Server is more strict about circular relationships than Access is, so in many cases a "matured"...

I love the chemtrail people. We have a facebook page for the International Chemtrail Association even :) "Dimmer Skies are Safer Skies" https://www.facebook.com/InternationalChemtrail/ https://www.youtube.com/watch?v=wAGhPoUFhsg These people crack me up. Flat Earthers, I can't even... at...

Sounds like a bit of corruption to me as well (in which case SaveAsText/LoadFromText should do the trick). Do you compact/repair often? Regular C/Rs help prevent this (I usually do it every time I take backup of the file, which is just after any significant development is complete... couple...

Currently you have the Me!ReminderID hardcoded as part of the literal string. You need to concatenate that value into the SQL string: strCurRec = "DELETE FROM tblReminders WHERE ReminderID = " & Me!ReminderID Be sure to test the code against a test dataset! Delete operations via SQL can be...

That's correct. The DataAdapter just fills the DataSet, and does nothing about writing that data back to the db. You will have to handle that with Cmd.ExecuteNonQuery (or look into an ORM like EntityFramework, but it's best to learn this stuff well before moving on to an ORM).

Hi, At no point are you actually saving the records. You fetch them from the server, but using ADO.NET, you need to explicitly update them as well. It's been a long time since I used ADO directly to do this, but look at cmd.ExecuteNonQuery(), which is used to execute a statement rather than...

A lot of more experienced Access developers I've met will avoid deleting records using this method (or any DoCmd at all, for that matter). It can sometimes be a bit tricky in that it operates on the currently active object, which can sometimes be unexpected. A safer way to do it is to issue an...

It's conventional for most sites to have a logo there (which doubles as a link to the home page), so for that reason I'd opt go ahead and switch it. Probably it might spruce things up a bit as well, being that the current text is rather cut-and-dry. While we're on the subject of the "upper...

Personally I tend to prefer recording a history of changes and effective dates rather than storing the effective value at the time of calculation. So we'd have a table of HourlyRates per employee with an EffectiveDate, and a query (or view/sproc if working with MSSQL) that returns all of the...