By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Save a new form in MsAcess in a multiuser database will open

P: 1
I am creating a new form(s) in MsAcess while it is open by more then one users
I have no trouble
Expand|Select|Wrap|Line Numbers
  1. '------------------------------------------------------------
  2. ' Module    : Create_the_Employee_Tables_and_Forms
  3. ' DateTime  : 10/02/2007
  4. ' Author    : John C Devonshire
  5. ' Purpose   : Create the Employee Tables and Forms
  6. '------------------------------------------------------------
  7. Sub Create_the_Employee_Tables_and_Forms()
  8. '**** Resetting switches
  9. On Error GoTo Err_Create_the_Employee_Tables_and_Forms
  10. strNameSub = "Create_the_Employee_Tables_and_Forms"
  11. 'Call AutoComments_Sub
  12.                 DoCmd.SetWarnings False
  13.             If intNumber_Next < 6 Then
  14. '*************************************************************
  15. '**** WE MUST MAKE SURE THE INPUT TABLES ARE CLEARED OF DATA *
  16. '*************************************************************
  17.     Call Clear_New_User_Table
  18. strNameSub = "Create_the_Employee_Tables_and_Forms"
  19. '*************************************************************
  20. '**** CREATE THE FORMS AND TABLES BY USER NUMBER             *
  21. '*************************************************************
  22. strUserNumber_TMP(intNumber_Current) = strUserNumber & "_" & intNumber_Next & "_TMP"
  23.                 DoCmd.CopyObject , strUserNumber_TMP(intNumber_Current), acTable, "EDU_New_User_" & intNumber_Next & "_TBL"
  24. strUserNumber_FRM(intNumber_Current) = strUserNumber & "_" & intNumber_Next & "_FRM"
  25.                 DoCmd.CopyObject , strUserNumber_FRM(intNumber_Current), acForm, "EDU_New_User_" & intNumber_Next & "_FRM"
  26.             Else
  27.                 DoCmd.CopyObject , strUserNumber_TBL, acTable, "EDU_Returning_User_TBL"
  28.             End If
  29.                 DoCmd.SetWarnings True
  30.                 DoCmd.Restore
  31.     Call Get_Forms_And_Tables
  32. Exit_Create_the_Employee_Tables_and_Forms:
  33.     Exit Sub
  34. Err_Create_the_Employee_Tables_and_Forms:
  35. MsgBox err.Number
  36. MsgBox err.DESCRIPTION
  37.     Call AutoErrorMsgbox_Sub
  38.     Resume Exit_Create_the_Employee_Tables_and_Forms
  39. End Sub
  40.  
when there is only one user

and no trouble with the table when there are multiusers

but error 2501 appears with the form copy in multiuser envirnoment

What am I missing

Thanks
Oct 12 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
It should be possible to open multiple instances of a form.
I've read about this in chapter 2 of the Access CookBook.
Check the sample database 02-11.MDB from the Chapter2 zipfile that can be downloaded from:
http://examples.oreilly.com/accesscook/CDROM/

Nic;o)
Nov 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.