Search results

Hi, I'm regularly exporting the database to a new version (once a month). This way I try to keep it free from history-clutter and so far that works fairly well. Attached you'll find the script I'm using, which I found online. There is 1 problem with this script, for which I have not been able...

Yes indeed, this I tried. It happens with Access in general; doesn't matter what database. And it ONLY happens with Access; not with Excel, f.i.

Hi Ranman256, *auwtsj* They supplied me with a Thinkpad T450 (i5-5300 2.3Ghz, 8Gb intern, SSD). You should think that should be sufficient... The strange thing is, that it doesn't happen in Excel, only in Access.

Hi, It's been a while since I've been active here. Recently I took up a new challenge and here we are working with Office 2010 SP2 Pro Plus 32bit on a Windows 8 Enterprise 64bit OS. I experience Access crashes several times a day, while working on the development of a major database. One...

Hi Gemma, I totally agree, of course. It is the flexibility that makes it 3D; you can manipulate on all levels, instead of getting stuck in 2 dimensions... :P

Hi, As far as I know, Access 2007, as a process, not only as a database, can only be started on 1 core. But I am not sure; it is why I stumbled upon your question. I am basically looking for a way to speed things up and let Access use multiple cores...

If I may be so bold as to answer this question: I had a dream... No, seriously. In 2011 I was working at the head-office of some big company and they were mainly struggling along with all those nifty spreadsheets. After 2 months, they started to see that what they did with Excel, I could do in...

Hi CJ, Thank you for your help and your link! It is interesting to see it is possible to send a connection string through SQL; no doubt it will come in handy one of these days. And you feed my suspects: LAN will never be as fast as local, whatever we try. I totally agree. So, now we are...

Hi namliam, That's what I did indeed. But in running tests with a large dataset, I found out that pushing 6.63GB to my local MySQL install is almost 3x faster than to my network MySQL install. That's why I wanted to find out if passthrough goes any faster. Until I found out it is difficult...

Hi guys, Thanks for taking the time! This morning I -indeed- found out myself that running server-side code does not work. Of course MySQL does not recognise the Access table, once I send the SQL statement to the server. I've run a good test with ODBC connector 5.3.2. I really wanted to see...

Hi, It's been a while since I needed this forum. I learned a great deal browsing around, gave some comments and continued developing for the company I work for. Now I've stumbled upon a whole new problem: All morning I've been looking to create a simple pass-through query in Access. Problem...

Hi CJ_London, Thanks for your reply! Meanwhile we were looking for a solution too and found indeed the same thing as you did: ComboPOC.RowSource = "SELECT tbl_RPM.Createdby FROM tbl_RPM GROUP BY tbl_RPM.Createdby, tbl_RPM.Material HAVING (((tbl_RPM.Material) = '" & Me.Material & "'));"...

Hi, First of all: Thanks to all posters. I've learned a lot from this forum. Currently I'm stuck with a datasheet-form. The datasheet is populated in a subform, based upon a table. SELECT DEV_List.* FROM DEV_List; Within this datasheet, I have several combo boxes. It is easy to give them a...

yes right now we are walking through it by F8, see what happens.

Hi JHB, Thank you for your reply. I tried the order of parameters, indeed. That did not help. Right now I will try if @Category only will work (leaving out @Period).

Question for the freaks out here. I try to run a query on a table, very straightforward. Table > full select query with 2 parameters. Then I try to execute & populate an Excel sheet with it. Set cmd = New ADODB.Command cmd.ActiveConnection = cn cmd.CommandType =...

Hi, Currently we are trying to automate Variant manipulation in SAP through Access. Does anyone here have any knowledge about that? The current script runs and works like this: - SAP login through SAP references - Use Access for Transactions and Variant names - Input values in Variants by...

I've been here before briefly, with the email of my previous employer. And I found out you guys are the best resource on the web for Access! So here I am again, joining with my private email. For my new employer there is a lot of programming to do and I am not a VBA wizard, so I will come up...