473,326 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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.

Aug 12 '06 #1
1 1612
<mp*****@gmail.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
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.
Ok
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.
Not optimum, but go on...
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.
Why? You are already getting all of the data in a central database with no
additional effort. The only thing you should do is split your current app. One
file with just the tables goes on the shared server location and you give each
user their own copy of a front end file that contains all other objects and
links to the data file.

This way each user runs their own applicaiton file, but all data is stored in
one central location. It is trivial to modify the app so that each user's
network ID is stored when they create or modify records if that is what you are
going for.
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?
It's a bad idea. Just don't do it. The split app with a single data file is
the standard for multi-user Access applications. The only time to consider
something like what you are describing is when the users aren't on the same
network so changes have to be consolidated via a separate process. As long as
they are all on the same LAN there is nothing to be gained by doing this.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Aug 12 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jay | last post by:
Hi, I implemeneted an FTP client and server long time back using Java. I found sockets porgramming in java quite useful and easy to handle. I now wanted to implement a similar program using C++....
6
by: John Walton | last post by:
Hello, everyone. I just began school, and they already assigned us science fair. Since I'm in 8th grade, I get to do demonstrations for our projects. I'm probably going to demonstrate Python's...
4
by: Wayne M J | last post by:
I have "Professional .Net Network Programming" and "Network Programming for MS Windows 2nd Ed", but I find both of these to be lacking in what I am looking for. Has there been any books printed...
6
by: Eric | last post by:
Does anyone know of any GOOD network programming book(s) that are C# based, as well as any online tutorials and forums on network programming? Thanks
1
by: Ryman | last post by:
Hello, I've just recently began network programming for c# (bought the book C# Network Programming) and I've ran into a few problems. Whenever I click the submit button on the client (to send the UDP...
9
by: Mex | last post by:
Hi, I'm looking for a good book for beginners about Network Programming. Besides Stevens' book, I would like something specific for C++ language. Any suggestions? Thanks in advantage, Massimo
1
by: Ryan Liu | last post by:
Hi, I have a 100 clients/ one server application, use ugly one thread pre client approach. And both side user sync I/O. I frequently see the error on server side(client side code is same, but...
2
by: =?ISO-8859-1?B?RulybmFz?= | last post by:
Hey all, I have a URGENT problem and I hope someone could help me... scenery: I have a windows app, coded using C# (framework 1.1 - VS2003)... The exe and dlls of the app is are stored in a...
1
by: yukijocelyn | last post by:
Hi I am currently programming a TCP socket to transfer large files. My client is running on .NET application and my server is running on Java. I am using TCP socket to transfer file over the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.