Recent content by BBrian

I posted about this before and have learned a good bit since, but the database is still slow! I've taken over from another IT guy who designed the database that's being used in a school. The data itself is sitting on a Windows 2008 server and clients are Windows 7 using Access Runtime 2010...

I wrote a long message here, but figured out a bit more when reading up on DoCmd.OpenForm. I'm looking at the indexes again now.

I've inherited a network running Windows 7 with a 2008 server (only server here), each client uses Access 2010 Runtime and an in-house database application I'm unfamiliar with. When users try to open a record, Access immediately changes to Not Responding with the blue circle mouse-pointer. A...

Excuse me, that's closer to the code Access created. I then took out the brackets in a debug attempt (to bring it closer to SQL I'm familiar with). The Data Types are all text, so I changed that to "N" and "Y", but nothing changes in the Locks table. Then I noticed in the status bar "The action...

I writing a script outside Access to remove table locks that aren't cleanly removed when I reboot the server the database is on without remembering its in use (or when the power goes). I'm writing it using AutoIt and have two delete queries executing nicely, but the update query I also need...