Search results

Hi Mark - Glad to get challenged - it's been long time since I last tested. Leigh Purvis has a demo of bound form transaction (Transactions in Forms) and I remember there are issues with how you can commit/rollback. My memory was that you were limited in how you could start/rollback/commit a...

jdraw, maybe I could have phrased my statement better - when I said Access doesn't support multiple statements in a single batch, I was referring to the fact that you cannot do something like this: db.Execute _ "INSERT INTO a (b, c) VALUES (1, 2); " & _ "INSERT INTO a (b, c) VALUES (3, 4)...

Almost forgot - There's an wiki hosted by another forums, UtterAccess and I wrote up an article which is still sparse but tries to cover some common gotcha with ADOs. Feel free to make use of it or better yet, add your own experience. Using ADO wiki article

1) Ah, yes. Using transaction with a bound recordset is kind of problematic since you're now fighting with Access over who controls the transaction. Generally speaking, if you need transaction control, you're probably better off using a temporary table and committing the edit as a bulk operation...

Yeah - you have to be sure to clear all breakpoint before you close the Access - otherwise the breakpoint somehow get saved with the actual code and is still in effect next time you run the program.

To get rid of those phantom breakpoint, highlight the 3 lines, the middle line being the one where your code "broke", cut and paste it back in. Compile the code and save. It'll be gone.

I doubt Access database engine can use the keyword "BEGIN TRANSACTION", "ROLLBACK" and "COMMIT" because the database engine doesn't support multiple statement in a single batch. What you'd do instead is to use either DAO or ADO to establish the transaction context. Example: Dim ws As...

First of all - I want to point out that you can do a Sort in DAO recordset and Access' Form also provide a pair of properties, OrderBy and OrderByOn to provide the sort functionality. You're actually using those already, and that is not something specific to ADO. You can use that with linked...

I'd also point out that you can have your textbox formatted to look like a label so there's really no reason to use a label to display data.

I personally used all tools since they are great in their own ways: 1) I use linked tables whenever I need an updatable query that I can use for form's recordsource. Almost most of the time, the form have one-to-one correspondence to the tables (subforms helps make this happen by representing...

I have to admit confusion - you ask for alternative to ADODB then talk about DataAdapters & DataGrid which are .NET components. Are you talking about using the Data.OleDb to populate those adapters/grids? Does the data source have an ADO.NET provider?

I actually doubt it's an array but more like a linked list. Else, it wouldn't be capable of dynamic allocation. I don't know how they've implemented the search by key and whether the key points directly to the node or one has to walk the chain. As I said before, though, this really works better...

Since you say you can't change the table design, we'd need to know more about what your code is doing in general steps. You already say you are reading from original table into temp then write back to original but you didn't give an overview of what you did with temp - did you do any...

Well, you'd use a query as a source for a pivottable so you'd use SQL view of that query. As for manipulating the presentation of pivottable itself, yes, you'd use the Office Web Components to provide the OM for the PivotTable & associated objects. You can get intellisense support if you add a...

I need to be real clear on the specific sequence of steps required to trigger the write conflict. Are you saying you: 1. Dirty the record 2. Write a value into a control 3. Move off to other control (the record is still dirty) 4. Return back to the control and change it again. 5. Save the...

Actually MVF were introduced in 2007 so that's not an issue. But your point in general still stands - one has to watch out for new features such as web browser control & navigation control, shared gallery and then few more. Also note that it's not also always a simple matter of "not using any...

You keep talking about reading binary files and writing into other binary files. It seems to me that if you're reading the binary sequence literally (which is usually always the case) and the size of the binary sequence is correct, then it won't actually matter if you're putting it into a field...

Okay, is MySQL hosted or local? If it's hosted, you'd need to check with your provider and verify they allow direct connections to MySQL (e.g. they may only allow your website applications to connect to MySQL but not anyone else). Usually, it should be possible to enable the direct connections...

Okay, we need to back up a bit and figure out where you are actually at. You have a MySQL database with few tables already right now, yes? You have an Access database you want to use as front-end client, yes? Did you download & install MyODBC? That is required so you can link from Access. Did...

Access 2010 introduced support for Data Service which in theory would do what you just described, provide you a table that represent data populated by a web service. Unfortunately, this feature involves a setup with SharePoint to provide the interface to the web service (well, I suppose if the...