Search results

Perfect, thank you. I guess that Sql Express would be enough?

Hello everyone, I developped a Access FE-Sql Azure BE tool, that I have already installed on a few machines. It works well, but all of these users had already Sql Management studio installed. Now, I need to distribute on machines that do not have SSMS: is it mandatory to install SSMS, or is...

This is very encouraging, thank you very much, and have a good day. I will try later, and will mark this discussion as "solved" if the process is successful. Etxe.

Allright then, I will try to create only one string gathering all the data, I haven't managed it so far. Thank you very much for your time. Etxe.

Ok, I learnt something, thanks.

Ok, I just learnt how to create a pass trough query. To make sure I have understood: - considering the fact that the string "strAllCriteria" is the result of list boxes - considering the fact that all the other fields come from the SqlAzure tables - considering the fact that the table finally...

Hello Isaac, in my case this is a yes/no field

You are right, the data are in the BE. And the criteria as well. (once again, I assumed it was safer to put the table that is populated by those data at the local level because I am concerned about 5 different users doint many delete insertinto queries at the same time at the same time: I may be...

Very useful answer, thanks Minty. Here is the bottle-neck step: str_SQL_finale = "INSERT INTO DSP_RDV_PREPA_t_transi_ChoixPraticiensAppels_OuiNon (ID_Contact, Integrer_ListeAppels, Nom_contact, Prenom_contact, Date_dernier_rdv, Nom_structure, Fonction, Specialite, Profession...

Exactly, this is what I meant to say, not that easy for me in english. I just ran a few trials, but it is not very successful: I read that relations beetween local tables and linked ones could be a problem. I had another idea: maybe creating a sql azure intermediate table for every user: in this...

Hi Pat Minty and Isaac, Thanks for your answers. I have a very basic knowledge about how Access deals with shared data: my fear is the intermediate table that is often cleared and populated becomes a "bottle neck" table: can Access manage 5 users changing many elements of a table in the same...

Thanks Isaac, but I don't se I think these are different problems

Hi, Not sur if my explanation was clear enough. I think I need to create those tables before migrating: why? Because they must be linked to others tables and to a query. Maybe I am wrong here, you will probably tell me. Then my thought was that I could click on the linked table and chose...

Hi, I will migrate an Access back end into Sql Azure, but I do need to keep a couple of those at the local level, as I use them to select rows with yes/no fields before sending the data into to the proper table. What would be the best and safest way to do so please? Many thanks in advance. Etxe.

Hi I just changed the whole system, it was not necessary to have a subform, it works fine now. Many thanks. Etxe.

May I send you a sample database?

I had removed them already, the data dont appear (still appeal correctly in the query and the form used for the subform)

Hi, I just tried: it seems to clear the subform, even though the querydefs shows the correct data, and so does the original form that became my subform

Hello everyone, I have a form called "sf_re_ResultatRecherche" based on a querydefs called "re_ResultatRecherche". This form is included in a form called "DSP_RDV_PREPA_f_CreationListeAppels": the name of the subform in the form is sff_re_ResultatRecherche. When the VBA code runs, the querydefs...

Hi The DBguy, Yes, the trick was indeed to use the original subform name, it works. Thank you then, and have a good day. Etxe.