Search results

I saw somewhere on the internet that I could link the SQL Server tables to my .accdb with VBA, without having to use the Linked table manager. Sometimes I get the ODBC call failed when trying to link tables with the Linked table manager and then I have to add every table again to the .accdb...

Very strange. I made the decompiled version and took the old version also. Tried to make the .accde few times from both versions and both sometimes finish without the error and sometimes with the error.. I would say 60% of the times the error occurs. BTW its access 2010 and its not exactly the...

Do you mean this? (attachment) Thats how it currently is.

I do run this line with F5 "Set ProP = Db.CreateProperty("AllowBypassKey", dbBoolean, False)" before doing the Save As but I did forget to do compile after doing so, I usually dont and it works. I will try with it. I do have Option Explicit in almost all modules, I found 3 reports without it...

No, not on any machine. It happens on the server but yes I do it locally on the server. At my home machine it didnt happen.

Well, Im not quite sure. It happens when I go in the .accdb and do Save as .accde, this is where it actually happens..but in this process a C&R happens, yes. However, it doesnt happen when I open the .accdb and just do a C&R or when I open .accde (after its been made) and do C&R, so only when...

Some more information, tables in the .accdb are mostly linked tables. Some are linked to .mdb and most of them are linked to the SQL Server. Very few are actually in the .accdb which arent linked but made in .accdb but the size is quite small... mostly temporary tables (I write and remove from them)

The .accdb is not even 10MB and I have no idea which query to check, however, I dont think any of the queries gives results that big to occupy 2GB

Sorry, fixed. Thanks :)

I get this error/warning (check attachment) when I make an .accde from .accdb. It jumps after closing the .accdb or .accde when doing compact n repair (turned on to do it on exit). When I open the .accdb and close, nothing like this happens, nor for the .accde after its been made. They work...

We posted at the same time, if I find time over the weekend I will try to do the testing and let you know :)

Ah, I misunderstood it, thought speed will be same if no indexes. I did but I didn't feel any improvement, however I need to do some further testing I don't think I tested everything suggested and correctly tho.

Thanks The field isn't indexed so I guess it won't matter much. When I get some extra try I will do some more of the suggested methods with databases larger than 5m, guess I should feel the performance difference there for sure. What about pass through queries? I keep most of the databases on...

I tried a little but it didnt seem like much of an improvement but I could be wrong, because I didnt test it in detail, had other things to finish :/ I have another question regarding SQL also but not truly for this thread, maybe to start a ne one? Anyway, when I go into a big table, lets say...

Thanks, I will try all that after some sleep :) I cant do anything with the indexes on the table NAPLATA - Kartica - Finansijske promene because I have no access to change it, unfortunately.

Hey CJ, sorry for the confusion. The SQL i posted is the correct one, not the screenshoot. Thanks for cleaning up the Order by, I will get rid of it. Yes if I remove the Is Null everything will be added correctly but the query will be even slower in some cases. For example it will most probably...

Alright, here is the SQL just this time with INSERT INTO because I need it. INSERT INTO ImportNap ( BrojacNap, DatumVriImp ) SELECT [NAPLATA - Kartica - Finansijske promene].Brojac, Now() AS Expr1 FROM [NAPLATA - Kartica - Finansijske promene] LEFT JOIN ImportNap ON [NAPLATA - Kartica -...

In the attachment I have put the query design. The qryNaplataKarticaSaIdPotDom alone runs just fine even tho the table has over 1m records. However, when I do a LEFT JOIN like in the attachment with this query and the table ImportNap, then it takes more than 3min for the query to load. When I...

I connect with a client PC to the server over RDP where I access the .accde which has tables linked to SQL Server 2012. All forms, queries n tables work fine even the report opens just fine in print preview but once I try to print the report after selecting the printer and clicking on the print...

When I make a pass-through query, I go make write SQL in SQL Server and then paste it into access pass-through query it runs pretty fast, even faster than the .mdb version. However, its the first time I done it like this and my access query has IIF expression, IsNull and takes some data from...