G
Guest
I created a database that when a user inputs information in a form and then
clicks a button on the form to merge to word, the vb runs a program to pull
information from our AS400, merges that information with standard names and
phone numbers, then merges the data into a word document. Each time I input
a different claim number on the form, a make-table query runs to dump the
AS400 information for the new claim number into a one-record table.
Everything works great on my system.
However, I want multiple users to be able to use this database as well and
if one person is running the make-table query and is using the one-record
table that is generated from it, then another person can't be trying to use
it at the same time. I have thought about replication and splitting the
database, but don't know which one is best. The other users won't be adding
data to most of the tables - I'm the only one that will do that (i.e. we get
a new employee in that needs to be added the employee table). However, they
do run a make-table query that generates a one-record table.
If I do replication, I have a problem with one of the functions:
*******************
Function Get_WINS_Info()
Dim hProcess As Long
Dim taskId As Long
Dim cmdline As String
cmdline = ("c:\Program Files\NGS\Qport\Qport.exe ""P:\Hlock\qport\WINS
Info for Forms.iqp""")
taskId = Shell(cmdline, vbNormalFocus)
hProcess = OpenProcess(SYNCHRONIZE, True, taskId)
Call WaitForSingleObject(hProcess, WAIT_INFINITE)
CloseHandle hProcess
MsgBox "Click here to continue after QPort has returned your records."
End Function
***********************
that calls a program to pull data from our AS400. The stored program that
actually pulls the information is "P:\Hlock\qport\WINS Info for Forms.iqp",
which dumps information into my database. In the replications, the function
would need to refer to another person's directory on the public drive. For
example, in Mary's case, it would need to say "P:\Mary\qport\WINS Infor for
Forms.iqp". Thus, replication won't work. However, I was thinking that
perhaps, the program could be called if I referenced the current folder
somehow, then ran the WINS Info for Forms.iqp from the current folder. Is
this possible? If so, how would I do that?
Also, if anyone has any suggestions on how to make this available to mutiple
users with the Make-Table problem (deleting/creating tables) and preventing
lock-outs, I would really appreciate it.
Thanks for any suggestions.
clicks a button on the form to merge to word, the vb runs a program to pull
information from our AS400, merges that information with standard names and
phone numbers, then merges the data into a word document. Each time I input
a different claim number on the form, a make-table query runs to dump the
AS400 information for the new claim number into a one-record table.
Everything works great on my system.
However, I want multiple users to be able to use this database as well and
if one person is running the make-table query and is using the one-record
table that is generated from it, then another person can't be trying to use
it at the same time. I have thought about replication and splitting the
database, but don't know which one is best. The other users won't be adding
data to most of the tables - I'm the only one that will do that (i.e. we get
a new employee in that needs to be added the employee table). However, they
do run a make-table query that generates a one-record table.
If I do replication, I have a problem with one of the functions:
*******************
Function Get_WINS_Info()
Dim hProcess As Long
Dim taskId As Long
Dim cmdline As String
cmdline = ("c:\Program Files\NGS\Qport\Qport.exe ""P:\Hlock\qport\WINS
Info for Forms.iqp""")
taskId = Shell(cmdline, vbNormalFocus)
hProcess = OpenProcess(SYNCHRONIZE, True, taskId)
Call WaitForSingleObject(hProcess, WAIT_INFINITE)
CloseHandle hProcess
MsgBox "Click here to continue after QPort has returned your records."
End Function
***********************
that calls a program to pull data from our AS400. The stored program that
actually pulls the information is "P:\Hlock\qport\WINS Info for Forms.iqp",
which dumps information into my database. In the replications, the function
would need to refer to another person's directory on the public drive. For
example, in Mary's case, it would need to say "P:\Mary\qport\WINS Infor for
Forms.iqp". Thus, replication won't work. However, I was thinking that
perhaps, the program could be called if I referenced the current folder
somehow, then ran the WINS Info for Forms.iqp from the current folder. Is
this possible? If so, how would I do that?
Also, if anyone has any suggestions on how to make this available to mutiple
users with the Make-Table problem (deleting/creating tables) and preventing
lock-outs, I would really appreciate it.
Thanks for any suggestions.