Search results

Not recommended share FrontEnd database with user ? I suppose is the correct way to do having FE and BE for multiple users database. Cheers

Thank you for answer, yes i saw it but is not clear to me. It could be possible to get an example of reconnection in a small vba function? Thanks.

Good afternoon everyone. Having a FrontEnd MS Access DB (shared with users) with one linked ODBC Table (located in another separate database) I'm looking to a function who can reconnect that ODBC Table when the end user doesn't have any DSN. This because I would like to avoid to create a DSN on...

Yes absolutely, if I'm not wrong I mentioned in my ideal flow in another message, the replace (update) of the shadow table will be done as soon as after I sent e-mail (which means there are modification). Ok noted, in any cases I can manage if required in the future. Thank you, Cheers

You talking about the shadow Table ? if yes, this is "my copy" table from the linked one (i don't have access to BE Database of the linked table so i can't add any table).

OK noted, i will create the shadow table in my BE database and i will link it in the FE then i will clean and re-build (delete/append records) everyday. Yes i will add the same index I have in the Main Table (Project_ID) Yes the idea was to create a table where i have one field...

Actual size is 15000 Records I will send unique email to multiple recipient with one excel (or csv) file which include 2 fields: Project , Old Date and New Date. This file i will create based on the verification i do (with the check query).

Thanks a lot for detailed and clear explanation. Lets say that the "time" is not a problem, I'm planning to do such verification one time per day and i will provide feedback based on this period of time. Also, i want "only" focus on the "change" of one field for "existing" Projects, i know could...

Any idea why all button in Data Macro are disabled in the Table Label ? I open a local table just for test the Data Macro functionality but I can't use any button (Before/After Events, Named Macro, etc.) are all disabled. I just did a test creating new db with one table and there it work. It may...

Thank you, it is exactly my Idea i tried to explained (step by step) in my previous messages. The only thing to understand was refer to the "tblCheck" which I need to create everyday by copy of the linked table in order to have something to compare with (as you well explained). In any case i...

Ok this is clear but, in order to have something to compare as you said, at the first run I should add in the log table the actual value (RFSU_PLANNED_DATE) for all Projects, . Now my question is: what if user add some new project in the Linked table (which i don't have control, i have only a...

Ok, clear, but this is only to understand if I need to do the verification process or not but my main issue is how I can understand if the value of one field is change in the same linked table ? Data Macro can be used only in local table (that's why i though to create a copy), any other...

As I said, this table is not under my control, is linked to my database trough ODBC hence, unless I do local copy, I cannot add any field.

The benefit is to use it everyday to compare with the live table (linked) in order to verify the differences. This is what i though otherwise, how i can control the modification in the same "live" linked table ? Because it is not clear to me in your explanation. Where i should add that code ...

Yes, exactly the above process i described. Cheers

My work around it was exactly partially described: the idea, assuming i'm not familiar with Data Macro (but i will read some documentation about), is : - Assuming i want to do the control one time per day (at the first logon of the frontend, any user); - Assuming i will create a daily local copy...

The problem is that i don't have the form where the modification it may be done by the user so how I can control something i don't have in my db? Sorry maybe I don't have enough experience but as far i know i can control the event only if i can manage the form (so the event), if not please...

What if I decide (at the first logon for example) to create a local table by copy of the linked one and apply the DataMacro on that local table which is owned by Access in this case ? But, as I said, I need support on how it works DataMacro (how and what to do). Cheers

Thanks first of all. The external application is another database, not sure which one but most probably SQL. So, am i wrong to say that I should find some work around ? or, if it is possible to use Data Macro, someone can be so kind to explain how to work with that ? I check some documents in...

Good morning everyone. Actually I have a need to send an automatic e-mail to users whenever a field of a specific table is change. The table is part of an external application and is linked to my access database trough ODBC connection and users may change that field trough that application. I...