Search results

Hi all, I need advice on the most efficient way to connect to SQL to reduce user wait times. I recently moved access 2013 backend to SQL Server 2012. We have about 150 users over the company WAN (typically 10 concurrent) and have some latency issues accross the network. The front end is on...

Hi all, What am I not understanding? Access 2013 with SQL backend. I have a subform datasheet. If I try to right click to delete a record I get an error that I cant delete because its based on a view that has 2 tables in it. So I tried to cancel the delete event, run a simple delete query on...

Anyone have a good reference for using objects and classes in Access. I have searched here many times. I get the basics of OOP, but any of the VB books I've found always disconnect the data, so you have to deal with managing updates by multiple users. I want to leverage access to manage the...

My access 2013 database is tiny - front end 16MB, Backend 30MB and will probably grow by about 30MB per year. 140 users, some remote, but typically about 10 concurrently. 120 tables (should be well normalized) Front end is on users Desktop, which allows me to do a lot of data manipulation on...

Does anyone know of a good resource to learn OOP with Access VBA. I understand the basics, read several intro to OOP web pages, but havent found any with more than 1 VBA example. Im looking for a book or online resource that has lots of examples of classes and objects in VBA. Ive googled...

Anyone know how to get the horizontal scroll position on a form I have a form in datasheet view, with the record ID column frozen and users typically scroll to the right to see certain columns. Different users scroll to a different position. I dont have the option to reduce the number of...

I am regularly getting the error "There is not enough free memory to update your display, close unneeded programs and try again" Access 2013 on a windows 7 machine with 4 processors and 24GB total RAM. Today I have 14 GB free memory (unbelievable! my first laptop had 136 MB total memory!)...

Hi, Im Gerry from Dublin currently living in Portland Oregon. Been using MS Access from version 2. Been lurking here long enough I thought Id contribute!