Search results

I know the OP is almost a year old but I saw no answer and I was having the same issue of a blank form when upgrading to Access 2013 from 2010 but still using Crystal ActiveX Report Viewer 11.5. We installed Crystal ActiveX Report Viewer 14.0.4.831 and replaced the Crystal ActiveX Report Viewer...

zpy2, I very much appreciate your efforts in helping me troubleshoot. I copied the code, added reference Microsoft XML v6.0, and ran it. The initial connection and update took 56 seconds. I then ran it repeatedly for about 10 times after that, each time it took between 7-8 seconds. I then...

aernelgp, thank you so much for taking the time to read my post and offer a solution. CJ hit the nail on the head and his sql does exactly what I was looking for. But I appreciate your help and feedback as well!

You, sir, are my hero! It's a simple but elegant solution that does exactly what I am looking for. I'm only sad that I can give one thanks per post... But thank you thank you thank you!

Thanks for the suggestion CJ, but doing a simple group by on the shft_id, code_id with min/max on the start/end times will give inaccurate results. For example, such a query would give a result of the very first record being: shft_id code_id start_time end_time 9090 100 1/28/2015 07:15...

I'm using SQL 2012. My current dataset looks like this: shft_id code_id start_time end_time 9090 100 1/28/2015 07:15 1/28/2015 08:00 9090 100 1/28/2015 08:00 1/28/2015 08:30 9090 120 1/28/2015 08:30 1/28/2015 11:30 9090 110 1/28/2015 11:30 1/28/2015 13:00 9090 100...

I'm using a LAN. Did your slowdown occur over a WLAN?

Yes I am sure that both connections are persistent and active. The backend I am using has far more than just one table. I broke it down in my example to keep things simple and directly related to the issue I am having.

I agree, linking a backend to a local table is not the most efficient query. However, the fact that the query in my example performs speedily (in 1 second) with only one user connected tells me it is not the query design that is at fault. So linking the backend to a local table in this...

Actually I tested that scenario as well. I put the backend on another box rather than the file server, relinked the frontends, and still got the Lock Request / Lock Response spam. The query runs and eventually completes. But it's like for every record update transaction a lock request /...

In my OP I state that I simply have each local box open a linked table in the frontend to the backend, which creates the persistent connection for each one. It seems the lock request spam is occurring because more than one user has a persistent connection. Once all users disconnect, the lock...

zpy2, thank you SO much for testing it out in a completely different environment. It lets me know that the databases are indeed fine and that it's probably something with the fileserver that's causing the lock request spam. But fileserver stuff is getting beyond my expertise... I was hoping to...

Thanks for the feedback llkhoutx. I'm actually not using any forms in my troubleshooting sample database (it's attached to my OP). I simply have one linked table open in the frontend to establish a persistent connection, and then had the update query reference a different linked table to...

So I've been having a multi-user challenge with a split frontend/backend database using MS Access 2010. The backend resides on a file server network with copies of the frontend on multiple user computer stations. The issue is that action queries such as updates and appends run fine with a...

Hello all. I hail from LA and my job requires I leverage MS Access 2010. I've been looking for a good resource for information and some of the threads I perused looked very informational, so I'm hoping that there may be someone out there who can help me with a dilemma I'm currently up against...