473,321 Members | 1,748 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,321 software developers and data experts.

coordinating file management

s
I need to coordinate file management between three computers.

Users need to enter all file names and would like to store file
names,date changed,person
changed etc. into a database. User Friendliness is main priority.
I would like one machine acting as database server on which data
entries will be stored.
The entries can be made by any of the three machines using a front end
interface.
Also using the front end the user should be able to query the database
to get results based
on certain keywords(like part of paper name) in addition to search
based on paper
name,date changed. The database has to be backed up
periodically(preferably automatically).
I am thinking of using Visual Basic as front end. For back end is
Access possible to use(can
it be set up to act as server on one machine which can service queries
from other machines
as well as its front end client) or other databases(SQL,MySQL,Oracle)
which support such
functionality need to be used.
I would appreciate any feedback for the front end,back end and design
considerations.
P.S. I am quite new to this so please excuse my faults. Please excuse
me for reposting but I did not get any feedback from previous post.

Apr 29 '06 #1
1 1443
Are these three machines on the same LAN, or were you planning on using the
Internet to connect them? If the first, then Access could be used as the
data store, and I suspect you will find it far easier to use Access to
create the front end / user interface than Visual Basic.

Do you plan to create this yourself? If so, you are going to need a good
deal more training, knowledge, and support than you will be able to obtain
via isolated newsgroup posts, but we can answer specific questions when you
run into stumbling blocks.

For good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP

<s@mailinator.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
I need to coordinate file management between three computers.

Users need to enter all file names and would like to store file
names,date changed,person
changed etc. into a database. User Friendliness is main priority.
I would like one machine acting as database server on which data
entries will be stored.
The entries can be made by any of the three machines using a front end
interface.
Also using the front end the user should be able to query the database
to get results based
on certain keywords(like part of paper name) in addition to search
based on paper
name,date changed. The database has to be backed up
periodically(preferably automatically).
I am thinking of using Visual Basic as front end. For back end is
Access possible to use(can
it be set up to act as server on one machine which can service queries
from other machines
as well as its front end client) or other databases(SQL,MySQL,Oracle)
which support such
functionality need to be used.
I would appreciate any feedback for the front end,back end and design
considerations.
P.S. I am quite new to this so please excuse my faults. Please excuse
me for reposting but I did not get any feedback from previous post.

May 6 '06 #2

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

Similar topics

1
by: serge calderara | last post by:
dear all, I have problem accessing section group in my configuration application file. I got an error saying thta I can have only one section ???? here is my application configuration looks...
3
by: kimimaro | last post by:
hi below is my save function that is used to placed data from the C program to a text file for future usage. void save() { FILE *save; int i = 0; save=fopen("employeerecord.txt", "a+");
27
by: Smithers | last post by:
Until now I have worked on small teams (1-3 developers) and we've been able to stay out of each others way. Now I'm about to start work on a project that will have 5 developers. I would appreciate...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
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...

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.