Search results

Good point. I could use 2b, and just store the encrypted password in code. And encrypt the user name as well.

Ranman - do you mean the password in not visible in both 2a and 2b above?

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...

A bit late to the party on this, but I would advise not to use DAO code in Dotnet projects. Otherwise you are just replicating something that's just easier to do in Access. You should add a dataset to your project, then work with that. You can then work with a datatable, which is the closest...

Thanks, that seems to be just what I'm looking for.

I have PDF software on my machine, just tried Win2PDF and Adobe Pro. Unfortunately this produced similar results. I think there will be a problem as long as the users can use any size picture. Some of these think they are artists, and love maximum resolution on their cameras :)

Sorry, I should have been clearer. The code in the link is Application.CommandBars.ExecuteMso "PicturesCompress" Which won't within Access as the PictureCompress function is not available.

Thanks, but it looks like those solutions relate to using functions in Excel and Powerpoint.

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" &...

In the Group properties there is a Force New Page option. I usually set this to Before Section, and not use a Page Break.

Apologies for delay in coming back on this. There are several sub reports involved. So the main report is based on the Clients table, with the sub reports based on different tables. How would I go about testing this within SQL Server?

Thanks, I hope you're enjoying Paris. I note that you use impersonate in that code. Would I be able to impersonate a Sysadmin user just while the Access report was running? Or even while Access itself was running. That may well solve my issue.

Ok, thanks for that. Better I know that's is not an option. Only vague reference I've seen is that its because of Sysreferences. I've tried that solution as well, just in case, but it made no difference...

So its working fine now? Its happened me a few times, where I just did a new report and the strange behaviour went away. Not very scientific though!

Is this code in the Detail_Format() of the report? If you want it to run for each record, it should be in the Detail_Format area.

Hi. Is the detail of the report also set to Can Grow? Also, is it cutting it off after the same number of lines in all cases?

Minty, it is just an ADP issue. I've seen other mentions of it, like http://answers.microsoft.com/en-us/office/forum/office_2010-access/slow-performance-in-ms-access-project-adp-with-ms/edbdffd1-55b0-40d5-9583-35ea515c37f8?auth=1...

Thanks for those links, very helpful. I created a new role, granted the permissions and then added my users to that role. Unfortunately, it made no difference to the speed. But at least I have a proper security model now! Adding the Sysadmin role still increases the speed of the reports...

I'm recommending we move off ADP, but it will be the end of the year before that work can being. And that's several months of moaning too long for my users. But your your point is valid. I've have just checked the select privileges, and its not set at all. Good idea! All the domain users are...

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...