Search results

Hi At the moment, I only use Windows security on SQL Server. Frontends are a mix of ADE and ACCDE, using Access 2010. However, I've recently become concerned as this means a user with Excel and ODBC knowledge get at all the tables and views. For example, all Clients. So I'm looking for advice...

Hi I have an Access report which has a page that allows for 6 jpg photographs. The table has 6 text values, which is the file location of the photographs. The report has 6 Image controls, and I load the picture with this code: For iPhotoNum = 1 To NUM_PICS If Me("SubPhoto" &...

Hi This is tied to an earlier post I had, see http://www.access-programmers.co.uk/forums/showthread.php?t=284480 In summary - I'm using Access 2010 ADP with SQL Server 2008 R2. If a user isn't a member of the Sysadmin server role, Access ADP reports will run slowly for that user. This wasn't an...

Hi Bit of background - I have a son and a daughter, both go to mixed schools. That is, a school with girls and boys in the class. My son in a scout group. There has been a big push in recent years to bring girls into the scout group. My daughter is in the Girl Guides. There has been no push to...

Hi I'm using an ADP in Access 2010. I wanted to check the content of some tables, and added this code to a form: DoCmd.OpenView Me.txtView, acViewNormal, acReadOnly So if type PrintLog into the txtView text box, it opens the PringLog view. PrintLog is just an example view, this code will work...

Hi Last week I moved our users from runtime Access 2003 to runtime 2010. I created a new ADP in Office 2010, then imported in all the objects from the 2003 database. Then created a new ADE using Office 2010. All users are logging on to terminal Server 2008. (or Remote Desktop Service as its now...

Hi I've been using Access for many years, but always learning something new. Searching for a good Access forum for a long time, I hope this it what I've been looking for! Diarmuid