Explore Databases on Experts Exchange

Expert Solutions for Your Tech Problems

Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes tha...

Read more
  • 830K Content
  • 45K Contributors

Expert Spotlight
Gary PattersonVP Technology / Senior Consultant

Experienced, hands-on IT expert.  IBM i / iSeries / AS/400, Windows, Linux, security, performance, web, mobile, SQL, RPG, Java, .NET, more.

Question

Idea needed - mapping/relating two tables together

2020-05-29
I'm helping my nephew with a project and I gave him the idea below, but want to see if anyone has …
Question

Trying understand code

2020-05-293
Can someone explain this code im trying to replicate a database that my boss gave me and i want to …
Question

Loading Forms slowly

byTony
2020-05-293
Hi,

I have an ms-access database (Front-End) together with MySQL (Back-End)

At the beginning …
Question

Help with SQL Query

2020-05-291
Hello EE, please see attachment a SQL file I did for you. Yuo can execute it to follow,


I am …
Question

Oracle Function as query

byJDCam
2020-05-295
Experts,
I want to modify an existing Oracle function. To test my modifications I am trying to run…
Question

Reassign broken reference libraries in VBA

2020-05-298
Hi:
References Dialog Box

Sometimes, when I send a copy of my MS Access application to the …
Question

PowerShell script doesn't run properly when used in a scheduled task

2020-05-293
Hi there,

I have a PowerShell script that needs to update an MS SQL Server database table field, …
Question

Need to count distinct occurrences of an ID

2020-05-296
I need to edit my query so that it counts the distinct occurrences of TempID.
It should be based on…
Question

Apply multiple payments against invoices by timekeeper

2020-05-294
SQL Server 2014.

I have a table that list invoices by timekeeper and the amount that they billed:…
Question

How to monitor nms.log efficiently?

2020-05-293
Hi Experts!

I am new to Linux and looking for an easy way to check anomalies off a Linux NMS …
Question

Getting a query cannot be completed message when attempting to compile my database to an MDE

2020-05-293
I have upgraded from Access 365 32-bit to Access 365 64-bit because I was getting frequent System …
Question

Which version of Microsoft ActiveX Data Objects should I use with Windows 10 and Access 365?

2020-05-293
When copying my access objects into a fresh database I need to setup the references again. My …
Question

Select count left join

2020-05-295
Hello,

I am asking for your help to help me correct this little bit of code.
In my tb_user …
Question

SQL 2016 Dataflow task error

2020-05-283
I am using SQL 2016 SSMS 64-bit to copy Access 2016 (.mdb) 32-bit data into an SQL table. Using …
Question

Query syntax in Access 2016 from different tables

byurjudo
2020-05-282
Hi Experts,
I have a query problem with address that involved with two tables.  one table is Client…
Question

way to determine the last numeric value after the last  ALPHA character AND after the last  "-" <dash>

2020-05-283
I have a column in a table that are similar to the following:
SLA-00100225-RSLR-A1-3-R15
Question

Google Mobile Usability Errors

2020-05-282
Hi Experts,

About a week or so ago I got an alert from Google Analytics that I have 2 Mobile …
Question

Mi dà un errore quando inserisco la password Più la tabella non si apre (Frm_Database)

2020-05-28
Good morning my name is Maurizio

And my problem that is driving me crazy is this:

If you try …
Question

SSAS Tabular - Dimension table

2020-05-283
I have a dimension table in a tabular model that has been setup to only retrieve records that are in…
Question

Connect to sql 2019 failing

2020-05-284
We recently installed sql 2019.  We are trying to create an odbc from a windows 2008 server but it …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more