Search results

Thank you CJ_London. But composite index can i see on diagram? Or only with primary keys like i have ? Why is better to use composite index and how to relate it ? Yes this is just example where i created composite primary keys... Jacek

Hello, thanks! What do you mean? I will have in flat file specified primary keys and table fields. How can i create sql string from it and why? Thanks, i have small tables up to 50 fields max. It should work i hope. Jacek

Hello Guys, i have model where i have composite keys (primary keys - unique ones). And what i need to do is creating relationships between tables. What i will get i will get just flat files with composite keys specified and will have to join them to see only structure in diagram. It is good...

Hi, i would like to ask you Guys do you have method to import DDL structure from from example flat file like CSV and import it to Access? It has to be written in VBA? It is possible to set up relations and so on ? Or not? Please help, Jacek

Thanks arnel!

Hello, i have situation where not all my tables are visible on screen. They just on the left on screen (sometimes Access does this strange thing for me) and i can not bring them back! It is any solution for this? Jacek

thank you Guys!

Hello, It is possible to check it easily in SQL? Or should i use VBA? I imported tables but somebody added newcolumns which i didnt detect and i goe error via queiries. How to avoid it? Jacek

hi Guys, thank you! when i forgot password i have just used online password crackers. Jacek

I like your articles Colin, they make direction where to check those security hidden methods :)

Love it!

hi Pat, but it is easy to break up i think this login form? Jacek

Pat this is general question. How to do this properly. I will adjust environment but i have to know what is the best.

thank you. Ok so secure whole Access Databse with 128 bit encryption it is only way.

Hi theDBguy, thanks! For example to connect to Access from Excel you are using connection string in VBa like: Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Path\To\File.accdb";Jet OLEDB:Database Password="MyPassword"; but you have to provide password so VBA code it is easy to break...

Thank you Colin!!!

Hi namliam, thanks! Yes you can just use select queries from Access in Excel and sql keep in Access only. This is nice way but there is no security with adodb connection and wondering it is possible somehow... Jacek

thanks! I think workbook password is set up with 256-bit encryption. Can anybody share link woth other methods to find lost password? Just for the future? Jacek

Yes it is. Guys. about the trick it is the same what arnelgp provided? Jacek

hmm thank you. I am not catching entirely. I love have Access a FE because set up queries is easy like for a child. i do not want to resign from it. It is possible to secure for example Access FE with password and not encode it in VBA or enforce access to show msgbox with input password when...