Go Premium for a chance to win a PS4. Enter to Win

x

Microsoft Access

218K

Solutions

51K

Contributors

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Share tech news, updates, or what's on your mind.

Sign up to Post

Cyber News Rundown: Edition 11/10/17

CyberNewsRundown.jpg
UK-Based Cryptocurrency Hit By Cyberattack

Prior to the official launch of Electroneum, a UK-based cryptocurrency that uses smartphones for its mining process, was targeted by a DDoS attack that shut down both the website and the app for several days. The attack effectively blocked all users from accessing their accounts, as the entire network was forced offline, to ensure the safety of investors’ funds.

Canadian University Held for Ransom

In the past week, officials have been working with affected students to secure their personal information after hackers breached the university’s systems and gained access to student records. The university has since taken its email system offline, as the hackers were spreading the leaked information throughout the email lists. Along with the data circulation, the hackers also demanded the university pay a large ransom of roughly 23,000 USD within 48 hours, though officials are still uncertain when the breach itself occurred.

WaterMiner Cryptocurrency Mod for GTA 5

As more cryptocurrency miners are embedded in software, one Russian hacker has gone a step further by exploiting a mod for the popular game Grand Theft Auto 5. The exploit silently uses a computer’s power to mine digital currency and, with the help of a modified version of the XMRig miner, can hide itself if it suspects monitoring software is active.

More on the Webroot blog here.
0
Fill in the form and get your FREE NFR key NOW!
LVL 1
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Let’s learn something new is the term known Error Database. What is this KEDB? And how it is connected to software testing world?

The key to progress lies in climbing the stairs step by step, instead of a single jump skyward. Approaching slowly and carefully expects knowledge to be stored, utilized and enhanced. In Information Technology Infrastructure Library one such tool that enables associations to make this progress is the Known Error Database.

What is a Known Error Database Tool?

A known error database is a database that portrays the majority of the known issues inside the general frameworks. It depicts the circumstances in which these issues show up, and when conceivable, it offers a workaround that will get the client around the issue and back to profitable work. The configuration management system is part of known error database.

This database also turns out to be a part of the general Problem Management Database, where IT can go to distinguish and organize issues that need perpetual resolutions. Workarounds are just impermanent fixes with the goal that work can precede until the point when issues are definitely settled.

The ITIL known error database must incorporate screenshots of the issues, and additionally the content of error messages, and portrays the issue from the perspective of the client.

Advantages of a Known Error Database

IT groups inside undertakings build up a known error database format as it offers …
0
Your access to October’s Course of the Month expires today! Enroll now and begin adding Microsoft SQL to your professional skills.
0
Today is the last day you'll be able to download Office 2007 SP's, Access 2007 Database Engine, Access 2007 Run time, and other software related to Office 2007 from Microsoft.

Make sure you download what you need to support your software.   Original post with some Microsoft Access links is here:

https://www.experts-exchange.com/posts/3107/MS-Access-2007-Users-Developers-IMPORTANT-NOTE.html

  You'll also want to download the Service Packs (SP's).
2
Gmail just launched a physical Security Key access option, dubbed as Advanced Protection, for their service:
https://landing.google.com/advancedprotection/

You'll need to purchase two physical security keys to enroll in it.

Here is the announcement from their blog:
https://www.blog.google/topics/safety-security/googles-strongest-security-those-who-need-it-most/

Good to see a big email service provider taking security seriously, for 'personal' users.

7
 
LVL 54

Expert Comment

by:Scott Fell, EE MVE
Good post. Because I am lazy, I made a request to have this type of thing save to my ee knowledgebase or browser bookmark.

https://www.experts-exchange.com/bugs/21366/Save-posts-to-knowledge-base-as-a-bookmark.html
1
Has your access to vSphere Web Client (VCSA 6.5) crashed this morning with Shockwave Crashed, Google have released a sneaking update 27.0.0.170 to flash which causes Shockwave to crash when accessing VCSA 6.5.

Fix - delete 27.0.0.170 and put back an older version!

You can also read about it here

http://www.virtuallyghetto.com/2017/10/shockwave-flash-has-crashed-workaround-for-vsphere-web-flash-client.html
3
 
LVL 1

Expert Comment

by:patron
Thanks , now we did replaced the dll to get this working , further will wait for another version
0
 
LVL 124

Author Comment

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Chrome and Adobe have now been updated with a release version which works!
1
Cyber News Rundown: 10/13/17

CyberNewsRundown.jpg
Rigzone Founder Caught Stealing Data

Over the last few months, officials have been piecing together the case against Rigzone founder, David Kent. After selling the Rigzone domain several years ago, Kent used several backdoors he’d implemented to access account information for over 700,000 customers, which he then attempted to sell back to Rigzone. By setting up several dummy accounts, Rigzone staff determined the specific IP address Kent used and apprehend him.

Criminals Hack Eastern Europe Bank for Millions

In the last year, banks in several Eastern European countries have seen a drastic rise in fraudulent charges at ATMs that have allowed hackers to make off with nearly $40 million dollars. Attackers start by manipulating the banks overdraft protection and setting up proxies to allow accomplices in other countries withdraw massive quantities of money from separate accounts. In addition to spoofing the overdraft system, the attackers also installed remote access software on bank computers to enable further intrusion to the institution’s systems.

More on our blog here.
2
MS Access 2007 Users/Developers - *** IMPORTANT NOTE ***

  This is a heads up that the following Access components available as standalone downloads are moving past extended support in the near future and along with other Office 2007 products, will not be available for download after that time.

  If you have any software that depends on the 2007 (32bit) database engine or the 2007 run time, you'll want to download these as soon as possible so you have them.  

•      Access 2007 runtime  - https://www.microsoft.com/en-us/download/details.aspx?id=4438
•      Office Data Connectivity Components (ACE) - https://www.microsoft.com/en-us/download/details.aspx?id=23734&40ddd5bd-f9e7-49a6-3526-f86656931a02=True&a03ffa40-ca8b-4f73-0358-c191d75a7468=True&751be11f-ede8-5a0c-058c-2ee190a24fa6=True
•      ADE - https://www.microsoft.com/en-us/download/details.aspx?id=24569 (includes the packaging wizard, source code control, and the save as template functionality)
 
4
Don't Get Hooked!

September-Consumer-Blog_Phishing_800.png
Another day, another phishing attack. From businesses to consumers, phishing attacks are becoming a more widespread and dangerous online threat every year. One wrong click could quickly turn into a nightmare if you aren’t aware of the current techniques cyber scammers are using to get access to your valuable personal information.

Stay safe with these tips.

1
Hello Team, i need a need a calendar solution that can be shared by the entire office. I want different people to be able to view, access and edit the same calendar data across networks.
Which is the best solution for this ?
0
 
LVL 54

Expert Comment

by:Scott Fell, EE MVE
Lee, you will get a better response if you ask a question.  Just click on the blue Ask a Question button at the top.

Scott
Topic Advisor
1
 

Expert Comment

by:Erik Dick
Google calendar is your best bet everyone can submit and edit to it. You can also have meeting rooms as users so no one double books.
1
Visualize your virtual and backup environments
LVL 1
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Hi i would like to know is there a website that can compare all access point products? For example like GSMarena for handphones or smart phones. Thanks
0
 
LVL 34

Expert Comment

by:Rob Henson
This may be better raised as a question rather than a post using the Networking topic (assuming it is network access to which you refer). Use the big blue button at the top of the screen to start question. At the bottom of the question screen there is an option to add topics; same as you have done here with Microsoft Access.

I have googled "access point products" and see numerous suppliers but not one that gives an overview of different items, except Amazon who will have their share of reviews for specific products.

Adjust the google search to "access point reviews" and you get some links that may be of use.
1
I recently passed my Microsoft 70-346 Exam.  As part of my revision I used Flash Cards that I created to help memorise key information.  The Flash Cards have been created on Cram and I've recently made them public.  You can access them from here:

http://www.cram.com/flashcards/70-346-8863906

I've gone overboard on the amount of information on there but It might help those attempting to pass this exam.  Obviously this is to be used in conjunction with other courses.  I can recommend the course on Platform Scholar.

The information on the Flashcards are valid as far as I am aware.  Obviously I take no liability for incorrect information.
5
 
LVL 1

Expert Comment

by:Joe Danyi
Thank you for the flash cards! you Rock
2
 
LVL 22

Author Comment

by:David Atkin
Thanks Joe :) .  I've got my 70-347 shortly as well.  If I pass, I'll make those publicly available as well.

Also, if you want an online video I highly recommend the Platform Scholar courses.
0
Bit Defender Anti Virus Free Version has started to block access to online banking sign in.
It does not advise of the blocking to record an exception.
Access is available when BD is temporarily turned off.
Have uninstalled and reinstalled but problem persists; commenced over past 4 days but has been okay previously.
1
 
LVL 34

Expert Comment

by:Rob Henson
You have raised a Post here rather than a Question. You will get better assistance from Experts by raising a question using the big blue button at the top of the screen.
0
 
LVL 66

Expert Comment

by:Jim Horn
Also please ask a question as opposed to a series of statements.
0
Just installed Access 2016 on a new office computer and discovered  "tell me what to do" in the ribbon. According to Google searches this cannot be removed. Has anyone found a way to disable this or do I downgrade to 2010?
0
 
LVL 34

Expert Comment

by:Rob Henson
You have raised a Post here rather than a Question. You will get better assistance from Experts by raising a question using the big blue button at the top of the screen.
0
1
Hello everyone out there in Experts Exchange World!  My name is Terri and I am new to this site.  The reason I decided to become a member is hopefully be able to learn from all of YOU EXPERTS!  I have decided to learn Microsoft Access and learn how to build databases.... I am not new with it by all means but absolutely NO EXPERT... In fact I would say I am just a step above the beginner..... so I am praying one of you out there in Expert Exchange land will soon become my best buddy in education.... lol
10
 
LVL 66

Expert Comment

by:Jim Horn
C'mon in, the water's fine, and we have some serious Microsoft Access rock stars that hang out in the Access zone and can answer questions.  

For a humorous tutorial on how to help them help you, much of it learned in the Access zone, check out Top 10 Ways to Ask Better Questions.

Thanks for joining.
Jim
1
 

Author Comment

by:Terri Anderson
Thank You for the warm welcome!
0
Last chance! Today is the final day to enroll in August’s CompTIA IT Fundamentals course. Premium Members, Qualified Experts, and Team Accounts unlock 30 days of free access. Enroll today!



3
Having a problem in Microsoft Access?    Make this your first stop (after applying all patches first of course!):

https://support.office.com/en-us/article/Fixes-or-workarounds-for-recent-issues-in-Access-54962069-14f4-4474-823a-ff7e5974a570?ui=en-US&rs=en-US&ad=US

and see if it's a known issue.   The Access team will be trying to be very diligent in posting all known problems.
3
hello guys, i am trying to parse a array result rest that i got from kraken
i would like to know how can i access a key on the array that was returned by thir api, bellow is the response from the api.
Array
(
    => Array
        (
        )

    [result] => Array
        (
            [descr] => Array
                (
                    [order] => sell 1.12300000 XBTUSD @ limit 120.00000
                )

            [txid] => Array
                (
                    [0] => OAVY7T-MV5VK-KHDF5X
                )

        )

)
i would like to extract the txid from the result set i tried this away but did not work
echo array['result']['txid'];

can some one help me out here ?
thanks in advance.
Rafael
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Rafael,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange...
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
Veeam and MySQL: How to Perform Backup & Recovery
LVL 1
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

cannot open log for source msExchange setup you may not have write access Error when trying to uninstall Exchange 2007 SP1
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Khaled,

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange...
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
Some news from the Microsoft Access world - lots happening!

New data connectors are rolling out:
Link to or import data from Dynamics 365: https://support.office.com/article/636079c1-9fc3-4fca-8410-6596d62223da
Link to or import data from Salesforce: https://support.office.com/article/7375ffb6-1d6a-46f1-bb0c-c6ac3c58f5a0

as well as New Accessibility features:
https://techcommunity.microsoft.com/t5/Access-Blog/Accessibility-Updates-in-Access/ba-p/75244

and new are Access case studies.   Here is the first:
https://techcommunity.microsoft.com/t5/Access-Blog/Customer-Story-quot-A-future-for-children-quot-ZUKI/ba-p/85336

Keep these links handy for info on new features and announcements:

What's new page:
https://support.office.com/en-us/article/What-s-new-in-Access-2016-76454345-f85d-47af-ace1-98a456cb3496

Access Team Blog:
https://techcommunity.microsoft.com/t5/Access-Blog/bg-p/AccessBlog

as they list new and updated features in Access as they are announced.
3
How do you make 0 a default in query
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi George,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
Filtering records to the Last Financial Year to Date in Access.
0
 
LVL 66

Expert Comment

by:Jim Horn
Asking questions using complete sentences would also help.  Check out Top 10 Ways to Ask Better Questions for some helpful tips on how to get answers quickly around here.
0
 
LVL 66

Expert Comment

by:Jim Horn
Also check out the SQL Server Calendar Table series on how to create your own date table to handle things like financial years.   The code is written in SQL Server but the concept still applies for Access developers.
0
Check out this email I got from Google (DUH!):


Help keep your Google Account secure

Hi Ryan,
These apps & sites that aren't from Google have permission to access your account, notmyrealemail@gmail.com. Do you still want to allow access?
Review non-Google apps & sites

Windows
Read, send, delete, and manage your email, Manage your calendars, Manage your contacts
See all

Why you’re getting this email
Apps & sites can ask for permissions to see and change things like your emails, contacts, and documents.
Learn more
0
 
LVL 63

Expert Comment

by:☠ MASQ ☠
So did you checkout that you've actually given that permission and it's still needed?
(https://support.google.com/accounts/answer/3466521)

A quick check here and no-one has "Windows" specifically listed as an OAuth authorized app.

Even if correct it's always worth checking your settings regularly :)
0
 

Author Comment

by:Ryan
Windows 10 is just set up that way as I have the only email address I use set up as my Microsoft account.  I just thought it was funny.
0
Verizon Cloud Breach As many as 6 million U.S. Verizon customers' PINs, names, addresses, and account details are at risk after one employee at Verizon did not safeguard access to customer information. Take action to protect yourself by changing your PIN immediately.
1

Microsoft Access

218K

Solutions

51K

Contributors

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.