Search results

Many thanks DB Guy, Isla and Steve. I just read the Microsoft documents online to understand how to activate the TLS protocol, , what would be the consequences for the users? Steve, how difficult is this to implement?

Hello everyone, I use an ODBC connection between a Maria DB and and a local Access DB. Every user has got his own local Access, in order to visualize data. My client seems concerned about this: he wonders how risky is an ODBC connection, and what would be the best way to maximize the security...

Hi Doc, Thanks for your answer. I may have used a misleading word here: I meant a directory more like a phone book : basically a list of people with different levels of details, grouped according different criteria, like in the picture below. I hope this makes my question clearer.

Hello everyone, I need to create some directories off several ERP extractions. As far as I can remember, I can use the mail merging system of Word (using labels), but an Access report would be very easy to generate as well. What I am not sure about is wether I can insert some titles or subtitles...

Hello, I just found a way to make it: - to visualise the datamodel, I charged the MaraDB tables into Powerpivot: there is a datamodel viewer tool: - then in Access, in the querymaker section, you can create "temporary" links between fields, this is just fantastic (it must have some limitation...

Hello all, I was asked to analyse some data that are in a MariaDB database. I firstly used Powerpivot but as the data model is quite complicated, I wonder if I can use the Access query maker instead (I cant use queries from the MariaDB database). So I have just tried: I created linked-tables...

Thanks Pat, yes, I just learnt it.

Thanks a lot! The issue was indeed that I was working with the Drivers 11 Native, instead of the brand new 17 version. It was necessary to create a new ODBC connection, and then to update the links between the FE and the BE. It works just fine now. Etxe

Ok, I increased the update retry interval, and it seems to work better. Many thanks again Minty. As I know you use a lot SqlAzure BE, have you faced issues regarding the "connection fails" error message? If so, what is the strategy to manage this issue?

Hello everyone, With an Access FE-SqlAzure BE application, it happens quite often that an error message appears because the connection atempt lasts too long, or at tleast I guess this is the reason. Sometimes it works perfectly during hours. Is it possible to increase the lag time in the ODBC...

Solved the problem: need to create a connection from the ODBC connection wizard (MySql 8.0 ANSI drivers), then you will find it in the Powerpivot conenction wizard.

Ok, it worked: I droped the index, then I successfuly ran the query (it didn't work righ-clicking). Thanks again. Etxe.

Hello everyone, I want to download datas from a MySql db into Powerpivot using ODBC, and more precisely the connexion string generator included in PowerPivot. ODBC drivers have been downloaded, but I do not succeed. I know that there is another way, starting from MySql, and creating a new...

Ok, I will try this evening, I will tell you, many thanks again Minty

I wrote the following query: ALTER TABLE [dbo].[Contacts_t_ListeContacts] ALTER COLUMN [Nom_contact] nvarchar(255) NOT NULL and the following message appears: Msg 5074, Niveau 16, État 1, Ligne 1 The index 'Contacts_t_ListeContacts$t_ListeContactsNom_contact' is dependent on column...

Ok, I am connected with SSMS, now I need to learn how to make a change directly in SqlServer!

Hello everyone, I would like to alterate a field, from short text to long text in a SqlAzure table, used via an Access FE. What would be the best way to do so, I don't know if I need to delete and rebuild the relations between the tables. Many thanks in advance. Exte.

Very strange, we checked again and it works now. Maybe it takes a few hours to accept a connection from a new machine? The firewall rule is that any IP address is accepetted from 0.0.0.0 to 255.255.255.255

Hi again, I installed the ODBC Drivers for x64 in the new machine, and here is what appears when I use a form linked to an SqlAzure table: If I clicl into a linked table, and try to update the link: here is the zoomed message : I tried to update the link, but no way to make the...

Allright, thank you. Hello Minty, Thank you very much for this detailled answer, that helps me a great deal. And thank you very much to the other contributors. Etxe.