Hello,
This is a question regarding MS-Access programming.
1. Network environment:
I got a room with 50 people answering the phone and logging the topics
of the incoming calls. Each has a PC, and the PC's are connected by
LAN to a Windows 2000 server PC.
2. Software Environment:
I built a small MS-Access database program which has the topics as
YES/NO fields. There are also a date/time field and a COMPUTERNAME
field for each logged call. Currently all of the users are opening this
program, which resides on a shared-location on the server, and feeding
directly to the server.
3. My wishlist:
I want to make a program which resides locally in a shared location on
each of the user's computers, and feeds to a database local to the
user's computer. At some instance, I, the network-administrator, will
have a program which logs into each of the shared locations of the
user's computers, opens the current users' database and harvests
their data to my own database table by way of SQL INSERT INTO.
4. My problems:
These shared locations, of the users, are protected by a
login/password. I must keep the login/password on. I need a
programmatic way to log into the current shared location. How do I do
it? OpenWorkspace only handles the password of the user in ACCESS
itself, not in the network. Do I have to use DDE/SendKeys to handle the
dialog being opened when I log in manually?
Thanks in advance,
Max.