workgroup file ..

MS Office Access

    Sponsored Links


  • 1. form in new instance
    in VB im able to create new form like this dim x as new form set x = formname what should i do in access ?
  • 2. What's wrong with this code???
    I keep getting the error message "Object Required" or 'Object Variable not set" if I take out the open statement. Sub UpdateStatus() Dim tblWIAStudentInfo As ADODB.RecordSet tblWIAstudnetinfo.Open Do Until tblWIAStudentInfo.EOF = True If tblWIAStatus_ID.OldValue = 1 Then tblWIAStatus_ID.Value = 9 ElseIf tblWIAStatus_ID.OldValue = 4 Then tblWIAStatus_ID.Value = 10 ElseIf tblWIAStatus_ID.OldValue = 5 Then tblWIAStatus_ID.Value = 11 ElseIf tblWIAStatus_ID.OldValue = 6 Then tblWIAStatus_ID.Value = 12 ElseIf tblWIAStatus_ID.OldValue = 7 Then tblWIAStatus_ID.Value = 2 End If tblWIAStudentInfo.MoveNext Loop tblWIAStudentInfo.Close End Sub
  • 3. how to cut from one and send to another
    I'm trying to get a way to cut a record from one table and paste it into another table via a command button on the form. I posted this problem on the "Forms" string but I was given an answer that doesn't work because there is no database variable type (at least not when I try to use Access 2000) Here's what I was given (keep in mind that it doesn't work): Private Sub Copy_Record_Click() Dim dbs as datbase set dbs = currentdb dbs.execute ("INSERT INTO table2 SELECT table1.* FROM table1 WHERE table1.criteria ='" & "this record" & "'") End Sub This only works if the criteria you are looking for is a string value. If you criteria is a number value, use this: dbs.execute ("INSERT INTO table2 SELECT table1.* FROM table1 WHERE table1.criteria =" & criteria) TIA Jim VanGordon
  • 4. access 2002 Using form filter or not??
    Hi there, I have inherited a database that has a form, which uses 2 dropdown listboxes to drilldown and finding a specific record in the form. (Plus, I am not very familiar with the system.) The Search / find logic is based on a 3 levels: level1 = Maintopic, Level 2 = Subtopic , 3rd level = Questions. The Form displays only the questions in relation to a subtopic. There may be several Question to a Subtopic. Now, if I want to add a new question, the program (as is) adds the question into the remainder of all other question ( = 250),( or rows of that table.) Obviously, I would expect to see only a record count of 8 records, if there were 8 questions in relation to the subtopic. What I like to see after a new question was added is that the form displays only records relevant to the Subtopic, with the new question the main focus ready for data entry. I thought to using the "domd.findrecord someid,,true,,true, accurrent,true" to filter on the Subtopic's Id Number, to get all relevant records, but then I am not clear as to how I am get the current record, which has the newly added Question displayed ,ready for the user to enter a new question. I mean the other option could be to use the subtopic I d number in the Underlining query as a filter, but I can't answer if that is the way to got at this stage. What other option do I have? Any other suggestions are most welcome. Kind regards Norman F

Re: workgroup file ..

Postby Gurtz » Fri, 01 Aug 2003 05:03:17 GMT

Thanks for your response,

No, I am not prompted to log in .. this is because I also 
pass the user name and password in the command line. If I 
give a gibberish workgroup file path in the command line, 
Access pops an error message at me, so I know it is 
reading the path and verifying that the workgroup file 
exists. It just isn't switching to it .. it simply uses 
whichever workgroup file I last joined. Something must be 
overriding the command line option, I guess..

Any other ideas?

is just a similar post
working for you.  But just to
to use the "most recently
a command line argument or
as defined by "Joining" a
you quite sure you have the
workgroup in the command line
open the file?

Re: workgroup file ..

Postby Rick Brandt » Fri, 01 Aug 2003 05:13:12 GMT

How are you determining that it is not using the MDW specified in the command line?
Try typing the command below into the immediate window and pressing <Enter>.  This
will indicate which MDW file Access is using.


Re: workgroup file ..

Postby Gurtz » Fri, 01 Aug 2003 22:37:52 GMT

Oh! That's great, thanks. I was just going to the 
Workgroup Administrator (Tools->Security->Workgroup 
Administrator) and reading what was listed 
under "Workgroup:". I didn't realize this would be 
innacurate.. The workgroups I'm testing are the same, but 
one is on the LAN, so I couldn't tell just by the 
available user names and such.

Thanks again!

specified in the command line?
and pressing <Enter>.  This

Re: workgroup file ..

Postby Rick Brandt » Fri, 01 Aug 2003 23:06:19 GMT

The workgroup shown in the Workgroup Administrator utility is your current "default"
workgroup.  This is the workgroup that will be used the next time you open Access
without specifying a workgroup file in the command line.  It has nothing to do with
what mdw file is being used by currently running applications.

Similar Threads:

1.File Locks on Workgroup File


I am having trouble with a database secured using a workgroup file. 
Essentially the workgroup system is working ok - to a point.

Unfortunately there is some instability in our database and it may crash 
during the day. This then can result in certain users being "locked" into the 
Workgroup.mdw file and the Workgroup.ldb file cannot be removed. We then have 
to speak to network administrators to kick the users out of this file.

I wondered if anyone had experience of similar issues, or what we can do to 
prevent this. Incidently we have no problem with users being locked into the 
actual database file Database.mdb

Thanks for your time,

2.Workgroup File


The Access database I upsized has a workgroup file which 
has about 100 users. How do I upsize this so that when an 
user opens the ADP file, a login page comes up and they 
only have the granted permissions. Is there a wizard or 
something I can use to do this?

I am totally new to this and would greatly appreciate any 
help. Thanks in advance. 

3.97 to 2003 conversion - Workgroup file not working

I have converted a 97 mdb to 2003 that uses access 
security. Everthing I've read states that the mdw file 
can still be used in 2003.  When I join the MDW and open 
the database I get a Runtime Error '3112' no permission 
to MsysAccounts.  I can open the security/user and group 
accounts and no users are listed.  If I try to add one of 
the uses it says the user already exists.

Any ideas? 

4.Workgroup file won't switch

Recently we migrated to Access 2002, I created new databases and imported the objects.  DBases that had "Security" on them, I removed security first, then imported objects in new 2002 ver. then re-established a workgroup file.  I created the special shortcut on my desktop to direct which workgroup file to use when opening  the database (worked correctly in ver. 97).  When I execute the shortcut, Access opens the database using whatever workgroup file was last used. Which I manually set to system.mdw without any databases open, but does not switch to my provrelsys.mdw when I open using special shortcut.  It will use the last used .mdw file no matter what database I open, even if it doesn't have security on it.  Thanks in advance...tossing ver. 2002 out the window!!

5.Linking the table from Access with workgroup file.

I have Back.mdf file secured with Back.mdw and I have no 
permit to administrate, but I have access (user and 
password) to read, write.

I need to link the tables from Back.mdb to Front.mdb 
witch has its own Front.mdw.

Is it possible for link process (TransferDatabase, create 
TableDef, connection or something else) to point out the 
workgroup file for the source table?

6. convert workgroup file from Access 2002 to Access 97

7. Workgroup File in MS Access 2003

8. Read password from workgroup file?

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 22 guest