• ** 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/

Recent content by Alc

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