Search results

I have a problems which seems simple, but it's made me doubt everything I have learned about this; I suddenly find myself unable to grasp what I belive is a very small and easy solution, but I cannot!! (Either that or I have stumbled upon a real conseptual problem without realising it :) ) This...

Hi :) (A2K format, but running on XP, etc) I have used Microsoft’s Security FAQ and recommendations on this forum and build a split database; secured with one worgroup file for development and one for customers: what is the most appropriate way to upgrade the backend database content (tables...

hi :) I'm using 2003 and 2000 and want to have "Auto Compact" on, so when users exit, it will compact and repair. I'm using the security measures described in the Access Security FAQ and in this forum. I therefore have 2 workgroup files, one for development and one for distribution. My own...

Hi all :) I'm planning to use the "compact on exit" functionality to keep my db's neat. I have understood that I also have to grant "Exclusive mode" to the database object to the users of my db (not to Users group, but my own users group). Does this have a security implication? As I'm running...

My frustration is definitively on the way up, as A 2003 keeps crashing, without giving me any clues as to why. I have an A2K database (actually 3) split into FE/BE. Works like a charm with A2K and A2002(XP), but I'm having serious problems with A2003. First off; does anybody know how to...

Hi all :) I'm in need of some expertise here (running A2K on XP pro): I've got a db, split into a FE and BE. I have a workgroup file built to the spec of the Access security faq. At the moment I'm doing development, and I was creating the shourtcuts to start access with the workgroup file. For...

Hi :) I'm currently in the process of testing security before shipping my database off. I have read the access security faq, but I'm not sure which option to go for. The main factor that makes me doubt, is that the db will be sent to locations that I will not be able to physically get to...

Hi :) I have a strange problem, where I might do something stupid, but none the less, it's a puzzler (to me at least). I do an ALTER TABLE to add a new column. After that I have a routine that get's the TableDef for that table, and loops (as It fails if I ask for it directly) until i finds...

I'm suffering with a bit of a performance drag, but it's all due to workarounds from earlier problems. So as well as asking for a way to increase the perfomance I want to appeal to your knowledge and creativity to see if there is an alternative solution to this. Tables Orders (ID, ItemID...

Hi all :) I have a summarised sub-form, based on dates, so I have to use a crosstab query. Because of the varying column names (dates), I'm using VBA to create the query. In addition the underlying query has a parameter that needs to be set. I have the code in a function (below), called from...

Hi :-) I though this was going to be really simple, but it was not. Maybe I'm overlooking something really simple (which will explain the lack of posts I found on it). Consider a table with col1, col2, col3 etc. In a query you want to decide which column to use runtime i.e: select colx, coly...

Hi all :-) I have searched for this particular problem, but no solutions found so far. Forgive me if I have missed it. If I have, just point me in the right direction... I have a query I need to run in VBA (DAO) as dnamic and it needs parameters. Also, if the query is run another way, the user...

HI :) I'm having a strange problem. I found no posts on this, so I guess I'm doing a real rookie mistake. I have this function (simplified): Function someFunction(aDate As Date) Dim rst As New ADODB.Recordset Dim rstSQL As String rstSQL = "SELECT col FROM [query];" MsgBox...

Hi all :) Consider the following: I have orders from an order table, a table for delivered items (as customer might not get wat is ordered due to various reasons), a client table and an item table. My current problem revolves around the packers form, to enter what is delivered in a simple...

Greetings :cool: (Thanks for an excellent forum, by the way!) I have a 2,5/3 dimensional problem, which my lack of solving, is taken out on my hair :( I'm working with A2k, more specifically a production system. The major thing is the orders. The "special" thing is that the orders are for...