Search results

I went around and did microsoft updates on se of the computers ok Friday and the performance seemed to be better on those computers. Will keep an eye this week and so how everything goes. Thanks for all of the advice!! We will be looking into your suggestions!!

I'm slightly confused on this? I have a query that runs upon opening the database and the users leave that query open as they refer to it off and on throughout the day. Would that be a "persistent connection" or am I thinking of this in the wrong way?

I haven't looked into windows or access updates - I will do that today. In regards to the other link you provided, I did look at these things. The only thing that I haven't done is taken Lookup fields out of my tables.... Does this mean lookup fields or dlookup? I don't use dlookup. Thanks...

Hello Everyone, My company is running two separate databases, one for Rentals and one for Maintenance and Accounting. We've been successfully running these same databases for 3 years with little to no issues. Within the last 2-3 weeks, we've been experiencing significant slow downs...

Good afternoon, I have audit trail tracking set up in my database using the following: Function LogChanges(lngID As Long, Optional strField As String = "") Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim varOld As Variant Dim varNew As Variant Dim strFormName As String...

Hi there! Yes, we had great success with it! Our users removed in to a virtual desktop from IPADS anywhere in the field. The only issue we really had was that our server is pretty old so there were issues with lag time periodically... nothing major but definitely noticeable. We had to log each...

Just a little update here - we have done this successfully and it worked beautifully!! We are now looking to make the database accessible over the internet so that our potential tenants can not only apply online, but also update their application data themselves, etc... possibly eventually have...

Thanks for all of the feedback. I decompiled the front end and made sure everyone updated. We're making the change to the network card settings as well. Hopefully this resolves the issue.

We have tried getting her a new front end. We do have a script set up on each desktop to copy the front ends, but will be setting that up to run automatically when they log in. We have one user who connects with a wireless connection. She's a part-timer and (so far) we have had no issues with...

Thank you both for responding. I guess my next question is, why would it only be happening with this one specific user?

I have a split database with multiple users. The back end is hosted on our server, and each user has a front end saved on their desktop. We were having issues with corruption quite frequently and figured out that users were leaving their front ends open when leaving at night, and at some point...

Yes, the database will be split. The users will be logged into IPADS, in to a virtual desktop on our server. We get part time help this time of year because all of our apartments turnover at pretty much the same time (within days of eachother). We have 1000+ units to inspect within 3-4 days...

I need to create a very user-friendly form that is easy for our inspectors to follow. As I've stated, this has been done 100% on paper for the past 20+ years. The way that I had this set up before, I could easily build a form that listed each category that needed to be inspected in each room...

I actually have a database with all of the units and tenant information. We are very new to using Microsoft Access here. Everything has always been done on paper so we are building out our databases as we go. It's been requested that I create the inspection items in a different database...

I think I am understanding what you're telling me and honestly, I can't believe I didn't put this together before. Grrrr... Can you look at this for me and see if I'm on the right track? Where do you think would be the appropriate place for the inspector to list a flooring type (carpeted vs...

I'm trying to wrap my head around this now but unfortunately, I only have a few days to either 1)make what I built already work or 2)redesign everything (on top of my other duties). I sure with I had researched this better. Thanks for the guidance everyone.

Absolutely. I appreciate any feedback/advice!!

No, i dont have one table per item. I have multiple tables because I can only have so many fields in a table and our inspections literally cover every item in the apartment, right down to electrical outlets and baseboards. Therefore, I did one table per room. Each room has multiple...

I have myself extremely confused :banghead: My company use to do paper move-out inspections and we are now going to be doing them electronically. The tables are set up as follows... KitchenFloor (Value list options are Okay, Needs Maintenance, Needs Cleaned) KitchenFloor_TCOC (Value list...

The users would remote in to a virtual desktop that is housed on the same server as our BE. The FE is saved in that desktop.