Recent content by wm2005

Thanks Lupins.

I have two backend database MDB's on a network being accessed by multiple MDE frontend applications. The data in the two backend MDB's relate to each other. So I have had to setup the relationships in the frontend app. But of course the tables linked from the two different databases wont...

Legendary! Your too kind, thanks.

Its true, this is a little unstable. I suppose the other solution would be to store an array of values taken from the database, and only populate the fields I want displayed in columns on the listview. Thereby interacting with the array instead of the control for getting at record IDs etc...

Thanks Zameer. That works, though will need some tweaking to make it usable on multiple listboxes where the hidden/locked columns are more than first two. I guess I could use the Tag property for this. Will

Does anyone have a clever idea on how to easily lock a listview column? Obviously setting its width to 0 will hide it, but still allow the user to resize and see its contents. Any help most appreciated. Will

Hi Crowley. I couldnt say. Im just interested in getting the maximum performance out of my database. As such I always run my select queries in 'snapshot' mode wherever I dont need to update the returned records, and set locking to 'no locks' if possible. And for action queries, Im thinking...

Afternoon all... Does anyone have any 'best practices' they would like to share in terms of using action queries? In other words, when should you, and should you not wrap your query in a transaction by setting this property? Will

Thats great, thank you for your insight, it really is appreciated. Will

I see. Thats enlightening, thanks Jim. Thanks Lupins. So I guess you could say that if using a shared access backend its best to connect to it via DAO rather than ADO, and if connecting to any other database (eg MSSQL or MySQL) then ADO connections would be better suited. You see I always...

Sorry for the delay in replying, I was away over the weekend. I come to this from a web background and have used action and parameterised queries stored in the backend for some time, all accessed via ADO execute commands (and snapshot, read-only recordsets where necessary). Now Im new to...

Firstly thanks for all your comments everyone - much appreciated. Ok Im just playing devil's avocate here, but there may be merits to having the queries shared backend. 1. Security By not storing queries (or tables) in the frontend, and encrypting all the other objects into an MDE there is no...

In a multi-user file-server split access database, is it better to store the queries on the frontend or the shared backend, and why? WM

Why on earth have I not used the ListView control before... Dim l As MSComctlLib.ListView Set l = Me.lvwTest.Object With l .View = lvwReport 'Add Headings .ColumnHeaders.Add , , "Name" .ColumnHeaders.Add , , "Surname" .ColumnHeaders.Add , , "Address" '...

Good point. What I should have said is that I am populating the data manually (call me crazy) via an ado connection from a remote database. For control of data flow, and more importantly near bullet-proof security I dont want any link to the data in the client application except for what is...