473,504 Members | 13,601 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access2000 ADP Connection to SQL Server

In general, can I just use the Connection feature in an MS Access ADP
project (File>Connection) to set my connection once and forever to the
SQL Server for my ADP Project and then just distribute it to my
clients?
Is this the right way to do this?
Any help is appreciated.
LQ
Jul 20 '05 #1
0 1379

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

Similar topics

2
1620
by: jason | last post by:
Is there a specific path I can follow to upsize my access 2000 database which has: 20 tables - mixture of primary and foreign tables 20 queries (action, select etc) Built on top of this...
0
697
by: Lauren Quantrell | last post by:
In general, can I just use the Connection feature in an MS Access ADP project (File>Connection) to set my connection once and forever to the SQL Server for my ADP Project and then just distribute...
3
1290
by: Paul | last post by:
For the past several projects, I have been using an Access 2000 .adp file to create and manage the database on the remote SQL Server. It has worked very well for me and is a very fast, simple way...
1
2625
by: Mario Crevits | last post by:
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with Access97 for several years now. We are in an Access97-2000 migration project. I'm writing a wizard for the end-users to...
4
1393
by: owen | last post by:
I want to use an Access 2000 database to power my .ASP web pages. Typical example would be somebody filling in a form on the web page and saving it to the database when they click a 'Submit'...
3
1530
by: Bruce Acciavatti | last post by:
I've split a rather large Access2000 database that resides on a network drive, by keeping the back-end on the network drive and placing the front-end on the client's hard drive, linked to it. Both...
3
1775
by: olle | last post by:
How to deal with a VBA-project that is damaged? Hi everyone. I am BigOlle from sweden and I have been working with Accees for ten years I am now working on a project that started in Access97...
10
3056
by: hugh welford | last post by:
Hi Have just installed IIS7 on Vista and am trying to access a .mdb file through ASP. Getting server error. I think the problem is in the file permission. Under XP Pro/IIS6 is used to have to...
3
1530
by: Ale | last post by:
Hi all, how can I execute a large amount of DDL Queries on Access 2000? I've a DDl/SQL Script file which defines a data structure with CREATE TABLE, ALTER TABLE UPDATE TABLE, etc. etc. I know...
15
4485
by: ravno | last post by:
I am developing an application in MS Access2000 - back-end database MS SQL 2000. When the application starts up, it refreshes link to backend like: ConnectStr =...
0
7213
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,...
1
7017
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...
0
7471
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...
0
5610
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,...
0
4698
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...
0
3187
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...
0
3176
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1526
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
754
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.