473,400 Members | 2,145 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,400 software developers and data experts.

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 1376

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

Similar topics

2
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
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
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
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
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
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
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
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
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
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
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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...
0
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
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...

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.