Hi
At the moment I do not need to know the how-to's, just interested if what I am thinking of trying to do is likely to be possible.
1. Is it possible to write code that would enable an Access database to periodically connect through a secure office network to a remote server (SQL Server in another part of the country) and download (and or synchronize) selected table fields and records into a local MS Access table on a laptop?
In creating the tables on the Laptop's Access database, I imported many of the tables from the SQL server by using "Get External Data" and hooking up via ODBC connection. But I would like to be able to write some code that would trigger the laptop to attempt to check for changes on the SQL server automatically when the Access database is opened, and download the changed data if necessary. Or it could append new records to the relavent fields in the Access database.
It would be nice to have it so that the Access database would check the SQL server for updates and bring up a pop-up asking if the user wishes to download the updated data from the SQL server.
Maybe I should post this on the SQL Server forum as well/instead?
Look forward to any views on the possibility of doing this.
Thanks again
4  2781   MMcCarthy 14,534
Recognized Expert Moderator MVP
I understand that you can't link as you need the access database portable on the laptop. Writing code to download new data through the odbc link isn't a problem using vba but if there were any changes made to the data on the laptop this would be overwritten.
The code would be to create the odbc connection using code and download the tables again. However, the original table objects would have to be deleted and you may have problems with the relationships.
It's a complicated issue and if you are interested in following this path I will try to get someone with more experience in this area to advise you.
Mary
Hi
At the moment I do not need to know the how-to's, just interested if what I am thinking of trying to do is likely to be possible.
1. Is it possible to write code that would enable an Access database to periodically connect through a secure office network to a remote server (SQL Server in another part of the country) and download (and or synchronize) selected table fields and records into a local MS Access table on a laptop?
In creating the tables on the Laptop's Access database, I imported many of the tables from the SQL server by using "Get External Data" and hooking up via ODBC connection. But I would like to be able to write some code that would trigger the laptop to attempt to check for changes on the SQL server automatically when the Access database is opened, and download the changed data if necessary. Or it could append new records to the relavent fields in the Access database.
It would be nice to have it so that the Access database would check the SQL server for updates and bring up a pop-up asking if the user wishes to download the updated data from the SQL server.
Maybe I should post this on the SQL Server forum as well/instead?
Look forward to any views on the possibility of doing this.
Thanks again
Hi Mary
Thank you for the reply. I will carry on trying to get the basic database for the laptop finished, then consider if I try it on. It is not essential that I am able to link to the SQL server but would be very useful.
I'll get back it a little later if thats O.K.
again many thanks for your reply.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi Mary
Thank you for the reply. I will carry on trying to get the basic database for the laptop finished, then consider if I try it on. It is not essential that I am able to link to the SQL server but would be very useful.
I'll get back it a little later if thats O.K.
again many thanks for your reply.
No problem.
Mary
NeoPa 32,584
Recognized Expert Moderator MVP
You could probably do it without having to DROP any tables.
Unless you wanted to get very clever though, you'd probably have to replace all data from the table(s) with the full dataset(s) from the SQL Server. This may be time consuming depending on the amount of data.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Kaan ?cg?n |
last post by:
Hello NG,
we have created a database for our schedules on the SQL server 2000.
As we have many satellite stations, we created a merge publication.
The aim of this merge publication is to provide the satellite stations
with their "own" databases, in which they can alter their data and are
able to synchronise with the main server thereafter. At the same time
it is possible to enter data into the main server (in our main
office). The...
|
by: mbailey |
last post by:
Hello-
I have a Sql Server 2000 database offsite that I would like to back up
to a local machine. I am using Enterprise Manager on a local machine to
administer the remote db.
Whats the best way to schedule backups so the remote db is backed up to
the local machine?
Can this be done in Enterprise Manager?
Would you recommend any 3rd party software?
|
by: Lyle Fairfield |
last post by:
In a recent thread there has been discussion about Data Access Pages. It
has been suggested that they are not permitted on many or most secure sites.
Perhaps, that it is so, although I know of no site that has this
prohibition, and I have uploaded DAPs to various sites and used them
from those sites.
I do not understand why any site manager would prohibit DAPs. To the
best of my knowledge DAPs, as HTM files, are merely hosted on the...
|
by: _(d)IEGO |
last post by:
Hello everyone. I need help regarding the following:
Given the following table:
CREATE TABLE T1 (C1 nvarchar(10), C2 money)
INSERT INTO T1 VALUES ('A',1)
INSERT INTO T1 VALUES ('B',2)
INSERT INTO T1 VALUES ('C',3)
let's say that i have this table in a local server and i want to upload
|
by: Mukesh |
last post by:
Hi
I have Microsoft Enterprise Library 2005 installed on my local system.
I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql
Server 2000.
I am developing a web application in which i am using data Access
Application Block for data access.
I have a remote web n data server with asp.net 1.1 support
| | |
by: Mukesh |
last post by:
Hi all
As per my earlier conversation with Ciaran (thx for reply) I have
installed the MS APplication block on the server , when i ran Build
Enterprise Library file and Install Services from (batch files )
programme files menu it was asking for visual studio 2003 , I have only
.net framework on the server how can i use the MS application block
data access library on my server plz help...
Mukesh Agarwal
|
by: Senthil |
last post by:
Hi All
We are having a VB application on SQL. But we need to collect
information from persons who will be offline to verify data and insert
new data. Generally they will be entering the data in Excel spread
sheets which can be uploaded to the database using the application
after some validations.
But rather than Excel I was looking at Infopath with Access as the
database, to create validation rules and collect data offline that can
be...
|
by: Guineapig1980 |
last post by:
Hi all
I am trying to copy data from one database server to another. I only
want to copy one table's data, not the entire database. The part that
I am having trouble with is connecting from one database server and
connect to another then telling it to insert into the second database
server.
Not sure if this is how it works.
|
by: =?Utf-8?B?QWRyaWFuTW9ycmlz?= |
last post by:
Hello!
I'm trying to copy a file from another computer on the network that I do not
have permission with my current logon details to access.
If I open the folder using the Windows file manager with the path "\\
192.168.2.2\temp" (where temp is a shared directory on server \\192.168.2.2),
windows prompts for a User Name and password of a user who has permission on
that computer to access that directory. If I enter valid details, the...
|
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...
|
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,...
| | |
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...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
