Problem: Network programming, OpenWorkspace?

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.

.

Relevant Pages

  • Re: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)
  • RE: Sharing data between distributed apps
    ... the other computers immediatly? ... computer (on the same network) must retrieve that name and show it to the ... In your program connect to that database using ADO.Net ... > Server and understand them well enough. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Problem: Network programming, OpenWorkspace?
    ... Network environment: ... I built a small MS-Access database program which has the topics as ... 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 ...
    (comp.databases.ms-access)
  • Re: Physical Computer Location
    ... These computers are on a network, so presumably they have network cards. ... Keep a record of the MAC address, associated in a database with the ... Modeled after the famous Black Hat event in ...
    (Security-Basics)
  • XP Pro Workgroup Permissions over LAN
    ... Trying to share a database across a simple peer-to-peer network ... I have seven computers in the workgroup. ... The second computer gains access via the network. ... XP Pro that I've missed? ...
    (microsoft.public.windowsxp.security_admin)
Loading