Search results

arnel awesome thank you so much!!! Jacek

thank you! I have BE with password and linked FE. I forgot BE pass. Can anybody help with this trick? Colin, you said that only FE is 128 so BE is ...? Jacek

https://www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_encrypt_a_split_database_in_microsoft_access_2016.cfm this method for FE will set up very special password which can be decrypted only via brute force? Jacek

Thank you Colin, It is BE. But what is a different with BE and FE? You can swith between them? I was jsut linking table from FE databse to BE database and thats it. How we can have 2 different things here? Can you please explain more or send any links to read more? Jacek

thank you Pat!

Hi Guys, i have Excel connected to Access FE linked to MS SQL Server BE. How to do proper security? I mean Excel is connecting to Access database but how to give certain user access to Access but with password? IT is possible? If it is only VBA i will have issue because VBA is easilt...

this is accdb

Thank you Guys for very nice tips! Jacek

Hi Guys, i forgot my database access. It is easy to break the pass? What encoding script is used to secure access? Best, Jacek

" It's only a couple of lines of code but I'm in the middle of a bridge game and can't break away to get it for you. If you still need it in a couple of hours, I'll dig it out. " Please. " My interpretation. Create empty DB with table(s) and keys required. That is your Master. Anytime you...

hmm i am not sure if i understood Pat Hartman. 1. First create empty database with keys and relationships - master 2. Copy it - child 3. Create link between master and child. 4. Put data to the child? Hmm? Jacek

Auntiejackie56 thanks, this seems to be very nice method. I will have composite keys - how to make them to be updated? Just joined them in query or add additional field with concatenaed key? How you would do this? Jacek

thank you CJ_London, "Simply replace the temp db on the next reload. " How to achevie this? Use VBA in order to create temp database and relink tables? Jacek

Hi Guys, I have seperate table not connected to any relationships which i have to just import to Access from csv and update what we currently have. And now what is better? 1. Clear all table record and just replace all (without deleting table). 2. Delete whole table and replace with new 3...

thank you Guys!!! Yes i am always asking because when i am doing something i do this in good way :) Or trying to understand all and be sure what i am doing. After discussion i fixed relationships: Thank you Guys for sharing with your knowledge and magnificient experience. Best, Jacek

Hi Guys, I have relationships something like here: And also i am using tblVolumes and there i have reference to serverClassID (i am not using relationships here because i have already used them in seperate case as above). Now i got one new table --> tblServerDetails where i have also key...

thank you Colin

Thank you Guys! I will handle it now!

you mean something like here? https://razorsql.com/docs/access_alter_table.html

thank you Colin, this is nice but what if you would have it will required all the time manually input system name into first part of union query. Jacek