How to avoid ftping data all the time - Microsoft Access / VBA

Rakshas

Looking for a solution where I can have a desktop app that updates the
mdb file on my server automatically without having to FTP the table.
Even better would be some kind of a web form that does the updating. I
know I can code this myself but if there is a built in solution within
Access, I would pee myself in happiness.

Nov 13 '05 #1

Subscribe Reply

1346

Trevor Best

Rakshas wrote:

Looking for a solution where I can have a desktop app that updates the
mdb file on my server automatically without having to FTP the table.
Even better would be some kind of a web form that does the updating. I
know I can code this myself but if there is a built in solution within
Access, I would pee myself in happiness.

Have you looked into replication?

BTW, upstairs, first on the left.

Nov 13 '05 #2

Larry Linson

"Rakshas" <rv********@gma il.com> wrote in message
news:11******** *************@g 43g2000cwa.goog legroups.com...

Looking for a solution where I can have a desktop app that updates the
mdb file on my server automatically without having to FTP the table.
Even better would be some kind of a web form that does the updating. I
know I can code this myself but if there is a built in solution within
Access, I would pee myself in happiness.

If your server is on a LAN with the desktop system on which the user would
be running Access, you can simply split the database into front-end
(queries, forms, reports, macros, modules, and perhaps some local lookup
tables) on each user's machine and a back-end (tables, relationships, and
data) in a shared folder on the server, link the tables in the back end on
the server from the front-end on the user's machine, and use them as if they
were local.

If your server is across a slow WAN or the Internet, you'll need to use a
different approach. The only one that is all-Access is Data Access Pages...
usable only on a Windows server with Access installed, by users running
Internet Explorer 5.5 or later, with the Office Web Extensions installed. As
with most web-based applications, the UI cannot be nearly so rich as Access
or other local UIs. It is not exactly a "wave the magic wand and your Access
database is on the web and accessible" but it should be easier than creating
a web-based database with ActiveX Server Pages (.asp) or ASP.NET.

Larry Linson
Microsoft Access MVP

Nov 13 '05 #3

Similar topics

1460

FTPing a zip file

by: D Elkins | last post by:

I am trying to write a small web interface to allow users to upload a zip file to our server. Below is code: //The form <FORM action="ftp_upload.php" method=post enctype="multipart/form-data"> <input type="hidden" name="MAX_FILE_SIZE" value="10000"> <input type="file" name="userfile"> <br> <input type="submit" name="Upload File" value="Upload File"> </FORM>

PHP

2849

Avoid 'GET' method

by: el_roachmeister | last post by:

Is there a way to make a text link post to a form without passing all the parameters in the url? The urls tend to get very long and messy. I often wonder if there is a limit to how long they can get?

PHP

1516

How to avoid two DB calls during page life cycle.

by: Peter Rilling | last post by:

I have an interesting issues that, although I not blocking me, is not very performance. Maybe someone can suggest a better way of doing this. 1) I have a page that displays a grid with command links such as Delete. Obviously if this link will delete the item of the current line. 2) The grid is initialized during the Init event so that the events can be bound. It is my understanding that events do not get fired unless the object...

ASP.NET

2883

What do People do to avoid Tight Coupling?

by: Charles Law | last post by:

Take a solution with a project hierarchy along the lines of an n-tier system, so that we have a data layer, business layer and presentation layer. The presentation layer is coupled to the business layer, and the business layer is coupled to the data layer. So far so good. Suppose the data layer raises an event, and it passes Me (the sender) as an object, and e (MyEventArgs, a descendent of EventArgs) to the layer above (the business...

Visual Basic .NET

2261

doubt in strcmp

by: Sameer | last post by:

Hi friends, I am beginner in C++. I am using g++ compiler. below is my code which gives error as " invlid conversion from 'char' to 'const char*' ..Plz help me with this. #include <iostream.h> #include <string.h> int low_range(char symbol) ; int main(int argc, char **argv)

C / C++

4524

How to avoid runtime switch/case code based on data type?

by: Fei Liu | last post by:

Hi Group, I've got a problem I couldn't find a good solution. I am working with scientific data files in netCDF format. One of the properties of netCDF data is that the actual type of data is only known at run time. Therefore a lot of template based trick isn't too useful. Considering datafile float x(3) 3.5, 2.5, 8.9 double y(3) 2.7, -2.3, 1.2 int z(3) 5, 2, 3

C / C++

4729

how to avoid date overlapping in MSAccess

by: gzaxar | last post by:

Hi to all in forum. It is my first post here. I am quite new in MsAccess programming. Here is a problem which i am facing to. I want to keep records of employees CV's. More specifically i want to keep the data regarding experience but i need to avoid time overlapping. I use the following tables - among others- EmployeeTb(means employee's table, Edu_ExperTb (means educational experience table) and Prof_ExperTb (means all other experience...

Microsoft Access / VBA

22041

How to avoid stack overflow in C????

by: amit.atray | last post by:

Environement : Sun OS + gnu tools + sun studio (dbx etc) having some Old C-Code (ansi + KR Style) and code inspection shows some big size variable (auto) allocated (on stack) say for ex. char a; (this type of code and other complex mallc/free etc is used frequently and total approx 450 files, each file is of approx/avg 1000 line,

C / C++

2361

How do i write Set based queries and avoid a cursor?

by: CK | last post by:

How do I write a set based query? I have a groupSets table with fields setId, idField, datasource, nameField, prefix, active Data: 1,someIDfield, someTable, someField, pre1, 1 2,someotherIDfield, someTable, someotherField, pre2, 1 3,somethirdIDfield, someTable, somethirdField, pre3, 1 4,somefourthIDfield, someotherTable, somefourthField, pre4, 1 I need to generate records in another table by constructing queries from the data in groups...

Microsoft SQL Server

8402

What is ONU?

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...

General

8829

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8734

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

8508

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

6172

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5633

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4164

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4323

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1627

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General