473,836 Members | 1,256 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Handling Remote Data Entry

759 Contributor
Hello !

I have a database (Access 2007).
In this database a form (a table) must be filled each month.

Can I define an application in SQL Server to collect the input via Internet ?
I think so (but I need an answer to be sure).

The main question is if I can update my tables (.mdb) using the SQL Server's table.

I ask because I don't wish to "waste" my time now to learn SQL Server. (I know that is not a wasted time. But not NOW)

Thank you !
Dec 17 '11 #1
8 20501
nico5038
3,080 Recognized Expert Specialist
For the internet data scraping you're better off in the MS SQL topic area.
about: 'The main question is if I can update my tables (.mdb) using the SQL Server's table.'

This is easy to achieve by defining an ODBC connection and use that to link an Access table to.

Use in the Start menu the "Data sources(ODBC)" application and define a connection. Next in MS Access select a new linked table and in the filetype combo select "ODBC" and your defined connection.

Nic;o)
Dec 17 '11 #2
Mihail
759 Contributor
Thank you for reply, Nico !
Is the first time you answer to a question of mine, so I think that you are an expert to this area. Glad to meet you !

I understand from you (my English is not very good, so I am not sure) that MS SQL is a better choice for my problem. Is this your advice ?

Thank you again !
Dec 17 '11 #3
Mihail
759 Contributor
After I post I google a little bit looking for MS SQL and I realized that is the same thing with SQL Server. Sorry for that, but I am more than newbie here.
Dec 17 '11 #4
NeoPa
32,584 Recognized Expert Moderator MVP
Mihail:
Can I define an application in SQL Server to collect the input via Internet ?
This makes sense, but there are so many things it could mean - as the internet is a word which covers the connecting together of so many machines and networks. Even if the term 'Web' were used, this could still cover an enormous array of possibilities.

Nico's answer reflects an expectation that you're referring to web scraping - a technique whereby information is read from web pages as HTML by your program and parsed into data that makes sense. This may well be what you're thinking of, but it would help if you explained exactly what you mean by your question in this respect. Web scraping is a pretty advanced and particular subject and the code may need to be specific to the individual pages that you're expecting to scrape. General purpose web scraping can get very complicated indeed and is very hard to get reliably right (as there are so many different web pages in the world with so many different approaches used).

Email is another one of many options that could be described as 'via the internet'. This may, or may not, have pre-formatted data. You can see that without something more specific it is hard to deal very directly with your question.

PS. I also get confused sometimes over MySQL, MS SQL and SQL Server. The first two look very similar, but the second two are the same. Confusing.
Dec 17 '11 #5
Mihail
759 Contributor
Hi, NeoPa.
While myself I don't know exactly what I am looking for is very difficult to explain.
I'll try but sorry if my poor understanding (combined with my poor English) will not allow you to understand what I mean.

Simplified, this is the sketch of real fact:
My database is designed to compute how much energy consume a house.

The structure of the database is:
First branch:
Towns -> Streets -> Houses -> Rooms -> Bulbs
Second branch:
DateOfReadings -> ReadBulb(ID_Rea dBulb, ID_DateOfReadin gs, ID_Bulb, Energy)

There are a lot of "readers" for that. One "reader" for each street. They read the energy for each bulb, write to the paper and come to the headquarter (with this papers). Here other employes fill in a form form_ReadBulb, for every bulb, the energy.
This form is based to ReadBulb table. It allow to select a street then to fill all readings for all bulbs from that street.

My purpose is to avoid extra times (wasted times) for all this employes. So I think that the readers can be easily trained to fill itself, at their home, a form with their "readings".
For that I need to connect they, somehow, to my database.
My "genial :))" idea is to define a simple application (maybe in SQL Server but not necessary) to do that.
After all I'll see how to update my database (Nico say that is possible. I'll ask later how if I can't teach myself)

How I see now the situation I'll need to have users (readers) accounts and passwords. Based on this accounts the form I'll use must filter data to show only bulbs from one street (one reader). But this is other story. Not for now.

For now I must start and I don't know from where.

Note please that collecting data via e-mail is the last option for me (I don't like MS Outlook and I wish to avoid using it as much as I can).

Thank you for interest !
Dec 17 '11 #6
NeoPa
32,584 Recognized Expert Moderator MVP
So, you want the various employees to be able to enter the data they've made notes of from remote sites yes?

The two main ideas that come to mind are :
  1. Design a web site yourself to allow them to enter the data directly into forms on the page. You would need to design it such that security is handled of course, as well as to ensure that the data entered is correctly identified as pertaining to the objects it is for (The correct bulb for instance). The main, and only, database would then be on the server and updated by the web page directly.
  2. Design an Access database project consisting of an FE and a BE such that the user could run this at their remote location and then transmit the BE database compressed (and possibly encrypted) to the central point for incorporating into the main system. The main system would have a database with pre-built links to the client BE (the one transmitted) which would allow it to upload the data intelligently.

    As the compressed client BE file is simply a file, how you handle the transfer can be very flexible. Email would work, but so would an upload via a web page if that approach is preferred. In truth, there are various options for this.

I hope these thoughts are of some help to you.
Dec 17 '11 #7
Mihail
759 Contributor
Yes, NeoPa. This is the final purpose.

I have no skills in web design. No HTML, no Java. So, if I chose to design a web sit I must start from zero. I don't know if it is possible to do that by using only the controls provided by a FREE site, without programming. FREE because this is a (very) small business and the money are a problem.

This problem (Remote Data Entry - thank you for help with title) do not burning me. So I I have time to stay in standby until I receive more ideas.
My skills are in VB, VBA, Excel, Access. Can I touch my purpose based on this skills (or very similar ?).
Any way, any idea is welcome.

Thank you in advance.
Dec 17 '11 #8
NeoPa
32,584 Recognized Expert Moderator MVP
I think #2 fits into that category. Mostly Access, but somewhere you need to manage transferring the client BE database. Email could be used, or even FTP (as long as you can get someone to set up an FTP site for you such that you can make the uploaded files available on your central network). I have done work before to enable a database project to :
  1. Enter the data.
  2. Compress the BE file using the WinZip Command Line executable.
  3. FTP the resultant compressed and encrypted file to an FTP site.

So, all that is possible from within Access using standard Windows executables and a single installable download from WinZip.

At the central end it only needs the FTP server to be set up to make the files available somewhere that is accessible to the network (It could prbably even be done using FTP if organising the files to be available locally were too much of a problem) and your code could process these files individually. It may involve each client file being renamed originally with a unique ID in the name to ensure multiple files don't clash, but changing the BE link for the central database is something I believe you've already dealt with (and if not then we certainly have done so here a few times - I believe Nico was one of the first to offer advice in that area if I remember correctly, though before your time).

In short, I believe such a project is certainly possible, if admittedly quite complex in places.
Dec 18 '11 #9

Sign in to post your reply or Sign up for a free account.

Similar topics

6
1608
by: Colin McNaught | last post by:
Hi, I find myself having to support a small ASP/VB/Access web application for a customer of mine. (Our main expertise is PHP/MySQL/Apache). Other than testing on the Customers ISP's Server, are there any low cost ways to set up a Server environment in our office to develop/support and test minor incremental changes to the application. We have a W2000 Professional and Office Professional system but no MS Server software. Colin
15
1471
by: uphid | last post by:
I've been tossing around an idea here in the shop for a while, and I am curious if anyone else out there would be interested. I am thinking of creating a server implementation for Access MDBs. It's a fairly straight-forward idea. The server would be a program that would listen for SQL commands, such as SELECTs or INSERTs to be sent to it (over TCP/IP). In turn, it would run the SQL against the local database and return either records...
5
1518
by: Eddie Clark | last post by:
I'm trying to access the items in a listbox from a client-side vb script. <asp:listbox id="ListBox1" style="Z-INDEX: 101; LEFT: 16px; POSITION: absolute; TOP: 120px" runat="server" Width="400px" Height="104px" AutoPostBack="True"></asp:listbox> I've tried several different ways using document.form1.listbox1 but nothing seems to work Any help would be appreciated.
0
1053
by: Robert Scheer | last post by:
Hi. I have an .aspx page that refreshes itself from 30 to 30 seconds. The pages uses meta-tags in order to refresh. This page verifies some data on a table in my database, and if there is a certain info present, a sound is played using the bgsound tag. The page works ok, but if I minimize the page that sound won't play. Is it possible to use HTML+TIME to access server resources before to
1
1698
by: Craig | last post by:
How can I access files on the server that are outside of the virtual directory of the web application. More Information: web application located here: C:\inetpub\wwwroot\FileAccessor File located here: C:\MyFiles
2
1668
by: keithgell | last post by:
I needed to import large CSV files into Access, when requested by a command in a .Net interface. Because Access does not have a bulk insert command, and I already have vba macros in Access that do the import, I simply called the vba macro from .Net using COM. Each time a csv file is successfully imported, I would like to raise a custom event in Access that the .Net interface can handle.
1
1645
by: satish mullapudi | last post by:
Hi all, I am using DB2 V 8.2 on RHEL. I am able to access the database created in the server from the server machine. but the clients connected to this server are unable to catalog this database to their machines & are unable to connect to this database. I am also not able to view the "Set up Communications" option. Please Help me out....... Thank You..........
1
1196
by: ahpooh82 | last post by:
hi all, i having a problem to access server folder. i got one folder inside server, which i already shared. but when i access that folder fail. dim host as string = "\\serverId\folder\file.xml" doc.Load(host) ..... error :System.IO.IOException = {"Logon failure: unknown user name or bad password.
0
1093
by: nethajireddy | last post by:
hello Techies.. I already placed in this forum but I did not get exact solution for my problem, we are using windows 2000 server and configuration is P-III 500Mhz processors (2), 512MB RAM. when users try to access server some times they can not access or it's too slow, I checked in TCPview, there TIME_WAIT is keep on increasing and then users are not able to access, for that i reduced time to 30 seconds( changed in registry) now...
0
1303
by: SteveBark | last post by:
Can anyone point me in the right direction as to what control structure I should put in place for the following requirement. I have an Access Server which I have 30 modems connected to. I need to utilise these modems to dial out and collect data from remote devices. The plan is to write a perl script that will process a list of devices to call from an input file read into an array. That array will be the controlling information to be fed...
0
9813
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9660
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10535
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10582
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10245
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9365
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7778
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6976
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
4005
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.