Search results

Tim, You wrote << In this context, the mildly interesting thing about Rich's DB is that no front-end form is bound to the permanent Incoming table. Therefore -- if you believe what various others say -- there's less chance that the incoming table will become corrupt. >> That's right. I did...

Pat, << I don't understand why you are looking for a way to avoid using a query or table as the form's recordsource. >> Some reasons: 1) it *might* be more reliable, multiple users would not be updating the same work table at the same time. I think a disconnected ADO recordset would be the...

Tim, After more research, this seems to be the situation: With Access 2K I can use either an ADO or a DAO recordset as the source for a form. But an ADO recordset from the "Jet" provider is not updatable :( So it looks like a DAO recordset is the only option if I want to avoid using a query...

You wrote << If I read this right, after a user logs in records are created in a work table that's located, I presume, on the server. The client opens a form bound to this table, which means this set of recs is pulled across the wire. After the user saves, the same set of records moves back...

Overview ======= I am converting several apps from Access 2.0 to Access 2000. The apps will have the same function and look-and-feel. Your experiences and suggestions will be much appreciated. Boring Detail Section ============== One app is a batch data update. The business purpose is workflow...

This sounds like several sub-issues. First, I think it is better to use "property" procedures and private variables than to use global variables. Versions of Access from 97 on up support Property procedures. Put the private variables and procedures into one module. Second, what is need for an...

Newman, << I now have a 15M BE and a 285M BE. (The 285M being only one table... the one that grows to much.) >> Mon Dieu ! (That's the other phrase I remember from high school:)) I think you need to find a way to redesign the app so one table is not 285M. Without knowing what the users are...

Newman << If the problem is caused by the queries, I don't see how using multiple BE would let me compact them. The BE with the table that grows would not compact anyway. >> In a previous post, you said there is a problem compacting a BE because it was too big. I am *assuming* that you have...

Newman, << What can I do to make the db grow less then? >> Can you create multiple BEs and distribute tables between them? That way each BE will be smaller and easier to compact. RichM

You wrote << I just tried it and I was able to change a query... >> Yup, memory failure at this end :) Meanwhile, if you go to Tools/Security/User and Group Permissions and select permissions by Group you can remove "Modify Design" and "Administer" permissions from the group Users. You can...

Newman, << I do use a delete query and a add query... could that be the problem? >> Yes. When you delete, the space that was filled by the deleted records is not "recovered". You must compact the BE to recover the free space. RichM

First, I don't believe the users can "change" a query in a front end that has been converted to an MDE. Second, you can use internal permission settings so that members of the group Users can not modify the design of queries. RichM

Sounds like 2 different situations with icons. In a shortcut on a desktop, you can specifiy an icon. This is true for Win NT, 2K, XP, etc. In an MDB, you can specify an icon for the Access window. This is true for Access 97 and up. It is an options under "Startup". Is this what your are...

Andrew, I don't have the time to make a complete working example for you. I suggest you look into Access "Help" and use ODBC as a keyword for search. You should find some general examples of attaching tables with code. RichM

you wrote << is the tblClientDataCollection the better choice as the form's Record Source. >> Yes, it is. That will let you bind fields on the form to fields in the table. You can create a control bound to a query that reads from tblDataMartClients; either a listbox control or perhaps a...

Brent, To recap; you want to insert fields into tblClientDataCollection, some fields will come from tblDataMartClients, other fields will come from manual entry. Some fields in your form, NewReferrals, need to be bound to the corresponding fields in tblClientDataCollection. Other fields on...

Andrew, You can supply the user ID and password in a string like this: strConnect = "ODBC;DSN=ORAORIP;SERVER=ORIP;UID=userID;PWD=something" This assumes you connect with code in a module. RichM

Sara, << When you select the type of contract, does this just select the necessary corrsponding fields from tblSteps? (you can really *do* that?!) I wouldn't have the first clue about coding that... but i can do a search and post back if I have troubles. >> I imagine some kind of New Contract...

kbrooks wrote << Everything I've read about splitting a database has talked about leaving the backend on the network server and putting the frontend on individual PC's. Is there any reason the frontend couldn't stay right where it is on the network server, and put a shortcut on the desktop? <<...

Mike, As far as I know, the variable data type should not matter. In Access 2K I have used things like (Optional strSomething As String = "", etc) with no problem. I have not tried this with Acc97 or whatever the latest version might be. RichM