472,795 Members | 2,441 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,795 software developers and data experts.

Access Announcements

32,534 Expert Mod 16PB
Access Announcements

From time to time we (Access MVPs) get information from the Access Team at Microsoft about what is happening with Microsoft Access. Much of this we are not allowed to share publicly. This sticky thread is for that which we are allowed to share, and for other information we come across related to Access which may not have been prompted by Microsoft themselves.

I'll try to keep this up to date with all important announcements.

To avoid the likelihood of clutter, and to keep this to the point as much as possible, I'm locking this thread for all but moderators. If you have something you feel should be said then please PM me and I'll decide how to handle it.

Anyone interested in keeping up-to-date with all blogs from the Access Team should monitor the Access Blog Index.
Nov 10 '15 #1
15 23083
32,534 Expert Mod 16PB
Still Life in MS Access

Contrary to what many of us thought in recent years, there is still life in the old dog yet!

More than two decades old and counting. This may be old technology but MS have realised there is still a great deal of value yet to be had out of the product.

I've recently returned from Redmond WA where a whole bunch of Access MVPs learned that MS are planning to invest more resources into bringing Access forward for the millions of us still using it for all sorts of purposes. Notice that this applies to both the desktop and the AWAs (Access Web Apps).

If this excites you as much as it does me then why not go over to User Voice for Access Desktop, or even User voice for AWAs and vote for what you would most like to see in the product(s).
Nov 10 '15 #2
One way to rekindle the fire would probably be to start posting on https://blogs.office.com/access/ again with Access-specific threads
Nov 10 '15 #3
32,534 Expert Mod 16PB
Problem with November Update (KB2837592)

Access 2010 may encounter a crash after installing the November update KB2837592
Nov 18 '15 #4
32,534 Expert Mod 16PB
Access Team Welcome Feedback and Suggestions via Access UserVoice

Access Blog (Connecting with Customers on Access UserVoice)
Dec 3 '15 #5
32,534 Expert Mod 16PB
One way to rekindle the fire would probably be to start posting on https://blogs.office.com/access/ again with Access-specific threads
I suspect they must have heard you ;-) I've updated the OP with this link as we anticipate this medium to be more heavily used in future.

NB. When reviewing the items in the list bear in mind they are in descending order of date, as read from left to right then down the page, but with different sized items this can be harder to cruise. Remember then, work from the top-left corner of each item to see them in the correct order.
Dec 10 '15 #6
32,534 Expert Mod 16PB
Problems with KB3085515.

There has been a bit of a kerfuffle recently after a number of problems were noticed after this recent release went out.

Here is some stuff that you should all know :
  1. The update was to address a VBA-crashing issue in Excel.
  2. The update unfortunately has some negative impact on Access 2010 users.
  3. There is no reason to believe that any other versions will be affected.
  4. Product teams are actively working on the issue.
  5. If you’ve installed the update, Microsoft recommends uninstalling it at this time.
For more details and the whole story so far see the Access Support Team Blog post.
Mar 10 '16 #7
32,534 Expert Mod 16PB
On a Personal Note

I have a video up on Microsoft's Channel9 that I'm hoping you may find interesting MVP Free Tools for MS Access. I'm alongside fellow MS Access MVP Crystal Long and we're offering free tools for MS Access.

Any views, and particularly awarding of 5 stars as a rating, are appreciated :-)
May 19 '16 #8
32,534 Expert Mod 16PB
Access UserVoice Comes Up Trumps

I've posted before about Access UserVoice.

Recently we found out that, as a direct response to one of the most popular suggestions, dBase files are on their way back in - Back by popular demand—dBASE file support in Access.
Sep 8 '16 #9
32,534 Expert Mod 16PB
New Access Tutorials

The Access Team, or A-Team as we like to call them now since they've started to make things happen again with our beloved Access, with the help of others at MSFT, have produced a series of new tutorials (What is Access?) aimed at getting people to start using Access quickly and easily.

You may find this link very useful in your trips around the forum.
Sep 17 '16 #10
32,534 Expert Mod 16PB
BigInt Support

New in Access 2016—Large Number (BigInt) Support
Mar 6 '17 #11
32,534 Expert Mod 16PB
Date/Time Extended Fields (& Recent Issues in Access)

Below is a copy of an email we received from Ebo Quansah who is the head of the Access Team in Redmond.

"Very soon, we will ship a new data type, known as Date & Time Extended, which enhances syntax compatibility with SQL while increasing accuracy & level of detail in date & time records.
While the feature is not yet enabled in Current Channel builds, most of the code for the feature is in the product in an inactive state. Nonetheless, we are aware of a problem that currently exists with this new code. As of today, if you are on version 2005, build 12827.20010 or greater, and you manipulate Decimal fields (Access DataType=Number/FieldSize=Decimal, or SQL DataType=Decimal) using DAO (Data Access Objects), you might have identified your app crashing. If you hover a variable with the type in VBA code, you may see that the field is not being displayed properly; either reading as '?????' or giving a Type Mismatch error, or Access may crash.
We are very sorry for the inconvenience this causes in your Access app. The Access team is working on resolving this issue as soon as possible, and we will report back to you once this error has been fixed. In the interim, we’d recommend for you to roll back to a previous version (How to revert to an earlier version of Office), or switch to a slower channel (e.g Monthly Enterprise Channel, or SemiAnnual Channel), until the issue is fixed in Current Channel. The issue only impacts Decimal types so if avoiding DAO code that manipulates Decimal types is possible, we’d advise this as a short term solution.
Thank you,
-Ebo Quansah"
Jun 11 '20 #12
32,534 Expert Mod 16PB
As a follow-up to my most recent post, here (Access VBA/DAO code may crash or report incorrect data for Decimal columns) is a page that gives further advice.

Please feel free to share this and the previous link as much as possible.
Jun 11 '20 #13
32,534 Expert Mod 16PB
Here's what a fellow Access MVP (Armen Stein) said recently about this :

I spent a while online trying to figure out how to switch channels from Current to Monthly Enterprise. I kept going down rabbit holes trying to figure out how to code my own configuration XML to do it and then apply it using the Office Deployment Tool (ODT). It’s way too hard.

Then I found a non-Microsoft site that made it easy. Here are my tested steps. I’m using Office 365 CTR, and they worked perfectly.
  1. Close all Office programs.
  2. Type Windows-Cmd to open Cmd window using Run as Administrator.

  3. Type: cd C:\Program Files\Common Files\Microsoft Shared\ClickToRun
  4. Type: OfficeC2RClient.exe /changesetting Channel=MonthlyEnterprise
  5. Type: OfficeC2RClient.exe /update user
  6. You’ll see a window about updating Office. It may take a few minutes. Wait until it completes.
  7. In any Office program (Word, Access) click File..Account. Channel should now be Monthly Enterprise Channel.

Hope this helps,
Attached Images
File Type: png AS1.Png (10.4 KB, 308 views)
File Type: png AS2.Png (6.5 KB, 284 views)
Jun 11 '20 #14
437 Expert Mod 256MB
The UK AUG seminar originally scheduled for 4 Nov 2021 was unfortunately cancelled due to issues related to COVID.

This has now been rescheduled for 8 Feb 2022 - hopefully as a live event....
The agenda is as follows:

0915 START
• Steve Girling, Case Study of a Live Project Using an Access/SQL Database
• Donna Landy, The Lazy Coder – codeless prototyping
• Colin Riddington, Automatic Form Resizing

1245-1345 LUNCH
• Alan Cossey, Confirming the Printing of Reports when Access doesn’t Play Ball!
• Colin Riddington, Controlling the Application Interface
• Peter Bryant, Managing SQL Backup For You On Demand

1600 CLOSE

Full details of the event are available at: https://www.ukaug.co.uk/wp-content/u...bruary2022.pdf
To book a place, email margaret@gordonassociates.co.uk

The seminar is FREE to UK AUG members. For non-members: the membership rate is £70+vat per year so you can join and attend both this conference (and the spring conference too)
Dec 2 '21 #15
437 Expert Mod 256MB
Access Europe (AE) is a new online chapter of AccessUserGroups.org.

Further details are available from https://accessusergroups.org/europe/

All meetings will be on the first Wednesday of each month from 18:00-19:00 (UK time – currently UTC/GMT) and will be co-chaired by Alessandro Grimaldi & Colin Riddington.

Whilst Access Europe is intended to be at a time suitable for residents of European countries, the meetings are both free and open to all

The first meeting on Wed 2 March will be used to introduce ourselves and explain the purpose of the group, explain how to use the various tools on the AccessUserGroup website and provide more details about the group as a whole.

We hope you will join us for our first meeting and help ensure the new Access Europe chapter is a success

It is intended that Access Europe will largely focus on innovative and lesser-known features in Access.

During the first meeting, there will be short presentations by both Alessandro and Colin as a ‘taster’ of what to expect from future meetings.

The session will also provide an opportunity for those attending to suggest possible topics of interest for subsequent meetings.

We already have an exciting range of speakers and topics booked for the coming months, starting on Wed 6 April with Chris Arnold who will be demonstrating his new and very powerful Access Studio application.

Please sign up to get notified about details of future events
Feb 7 '22 #16

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Paul | last post by:
Hi all, at present I I've built a website which can be updated by admin and users. My problem, I've combined "log in" and "access levels" to restrict access to certain pages, using the built...
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network...
by: Colleyville Alan | last post by:
I have an app that uses Access to grab various PowerPoint slides using the followhyperlink command. I have set the PPT window to run in a minimized state: FollowHyperlink link Set oPres =...
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
by: frekster | last post by:
All. I have a folder/files that I have added asp.net to have read/write/etc. privlidges via the properties of the folder/files and security tab. However, when I run my asp.net page, I still get...
by: Rico | last post by:
Helolo, I have an ASP.NET application on a Windows 2003 Server machine WITHOUT VS. I am working on an XPPro machine with VS 2003. I have installed the remote debugging components on the server....
by: Fish Womper | last post by:
I am at best a part time developer of Access databases. I use Access 2.0, as this is all my employer has on its computers. Even so, to use this ancient version requires a fairly convoluted...
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
by: Mourad | last post by:
I need to attach (link) a table in SQL Server 2005 database to an Access 2.0 front-end database: On Access 2.0: Click File\Attach Table..., select <SQL Databaseclick OK On the "SQL Data...
by: ArunaMani | last post by:
if i login as admin it redirects me to admin page.There i kept one button called log out. if i give log out the session will be closed but again if i give back the page automatically redirects to the...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.