• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

Search results

  1. A

    Access speed on new server much slower than old

    Thanks all. I've managed to get a dedicated resource from the technical team to look at this, this week. I did some benchmark tests using various combinations of C, P and Q drive and was able to convince them that a problem exists. Will post whatever we find.
  2. A

    Access speed on new server much slower than old

    Sorry, I explained that poorly. The two options are: Front end back end both on new server Front end local, back end on new server Yes, I figure now someone has built it he has his name attached to it, so he'll want it to work even for selfish reasons.
  3. A

    Access speed on new server much slower than old

    Thanks will do. I assume I can't be the only person this will happen to.
  4. A

    Access speed on new server much slower than old

    Some are on the users' own PCs. Some are on the shared drive. Normally all would be on one or the other but I'm experimenting to see if it makes a difference and the change is negligible.
  5. A

    Access speed on new server much slower than old

    Thanks, I'll try it
  6. A

    Access speed on new server much slower than old

    I've found various questions about Access speed over a remote connection but can't find one that quite covers this problem. Apologies if I've missed it. Until two weeks ago, we had a load of databases on a shared drive (P:\). They were set up with a shared back end and each user having their...
  7. A

    ODBC Error for one user after upgrading to Windows 10 Access 2016

    Sorry, should have added that to the list of things I tried. The connection string generated by Access looks the same as the one in the code.
  8. A

    ODBC Error for one user after upgrading to Windows 10 Access 2016

    Thanks all. 1. Will change the declaration and see if that helps. 2. haven't used the Event Viewer before. Will look into it. 3. Yes, just the database name is given, no file/system/ etc. This was set up before I got here and has been running fine for years.
  9. A

    ODBC Error for one user after upgrading to Windows 10 Access 2016

    Our company just upgraded everyone from Access 2010 on a Windows 7 device to Access 2016 on a Windows 10 device. One of the problems encountered is as follows, but only happens to one person, which has me puzzled. There is a line of code in a few of the databases that uses a global password and...
  10. A

    Solved Setting up ODBC data sources for accdb files in Windows 10

    Sorted! The problem turned out to be that only the 32 bit Access drivers were installed (no idea why). I downloaded and installed the 64 bit and Access showed up as it should. I was then able to connect in Qlik View. Thanks so much for the help, it pointed me in just the right direction.
  11. A

    Solved Setting up ODBC data sources for accdb files in Windows 10

    It's 64 bit. Professional Plus 2016. However, when I go via the 'ODBC Data Source Administrator (64 bit)' dialog and select 'MS Access Database (which shows both *.mdb and *.accdb as options), only 'SQL Server' is available in the 'Create New Data Source' dialog.
  12. A

    Solved Setting up ODBC data sources for accdb files in Windows 10

    Yes, in step 4 I changed the file type to 'All Files'. After that, I could see the accdb file I want. I (perhaps incorrectly) assumed I could do this, as the earlier screen showed *.mdb and *.accdb as options?
  13. A

    Solved Setting up ODBC data sources for accdb files in Windows 10

    Thanks for the reply. Yes, I have Access installed and I created a small database to use for testing (just one table).
  14. A

    Solved Setting up ODBC data sources for accdb files in Windows 10

    Does anyone have any experience of adding a driver for accdb files under Windows 10? I'm testing out Qlik View with Access which means, for the first time, I'm trying to install a 32-bit driver on my home PC. The steps I used were as follows: I open the Control panel I click on 'Set up ODBC...
  15. A

    Qlik View

    ....aaaaand there's our current problem. We have permission to go into salesforce and run reports. Nothing else. I'm coming to the end of a two year battle that's resulted in them exporting a load of data for us on a daily basis, creating a few CSV files which I then import at our end, just so...
  16. A

    Qlik View

    Thanks CJ. It's the multiple sources bit that my manager noticed. We use Salesforce in conjunction with other sources and it would be nice to access the data directly.
  17. A

    Qlik View

    Thanks, Minty. That's my impression so far.
  18. A

    Qlik View

    I was wondering if any of the esteemed users on here have had any experience of using Qlik View with Access or other dbs? I've been informed that my department has a few Qlik View Server licenses, we're just not currently using them. My manager is toying with the idea of me getting a Qlik View...
  19. A

    Upgrading from MS Access 2013 to 2016, incrementally

    We had this issue just after I came here. Everyone was running Office 2003 and they upgraded to 2010. The various databases had been built not only with the front and back ends in one file but with everyone accessing the same file to do work. The first time someone who'd been upgraded to 2010...
  20. A

    Upgrading from MS Access 2013 to 2016, incrementally

    You may be right, but that's a little above my authority. Everyone here gets it.
Top Bottom