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

Create ADP in MS Access 97

Hi,

My question es very simple:

Can I create a ADP file in MS Access 97 for updating tables, views,
functions and stores procedures for a SQL Server database in a remote
server. I'm using Windows XP Pro.

In MS Access 2003 this is very easy to do, but my client only have a MS
Access 97 version.

We need update function and stores procedures in a remote server. Also
we have access to the remote database.

Thanks in advance.

Felipe.

Jan 12 '07 #1
3 2910
No. ADPs were introduced in Access 2000, so A97 knows nothing about them.

You can attach tables and views in A97, but not create an ADP.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<hs*****@gmail.comwrote in message
news:11**********************@38g2000cwa.googlegro ups.com...
>
My question es very simple:

Can I create a ADP file in MS Access 97 for updating tables, views,
functions and stores procedures for a SQL Server database in a remote
server. I'm using Windows XP Pro.

In MS Access 2003 this is very easy to do, but my client only have a MS
Access 97 version.

We need update function and stores procedures in a remote server. Also
we have access to the remote database.

Thanks in advance.

Felipe.
Jan 12 '07 #2
On the other hand, I've worked with Access clients using linked Tables and
Views via ODBC drivers, since Access 2.0, with good success. ADP is
definitely NOT necessary for Access to be used and useful in a Client -
Server environment, with any ODBC-compliant server DB.

On the other hand, I worked on enhancing an ADP, and despite some 'unusual
design decisions' because the original implementer was a 'refugee from a
different language', they can be used and useful in a Client-Server
environment, also -- provided the server DB is Microsoft SQL Server.

Larry Linson
Microsoft Access MVP
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...
No. ADPs were introduced in Access 2000, so A97 knows nothing about them.

You can attach tables and views in A97, but not create an ADP.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<hs*****@gmail.comwrote in message
news:11**********************@38g2000cwa.googlegro ups.com...
>>
My question es very simple:

Can I create a ADP file in MS Access 97 for updating tables, views,
functions and stores procedures for a SQL Server database in a remote
server. I'm using Windows XP Pro.

In MS Access 2003 this is very easy to do, but my client only have a MS
Access 97 version.

We need update function and stores procedures in a remote server. Also
we have access to the remote database.

Thanks in advance.

Felipe.

Jan 12 '07 #3
hsal...@gmail.com wrote:
We need update function and stores procedures in a remote server. Also
we have access to the remote database.
I think that you cannot update function and stored procedures in a
remote server in the Access 97 UI. Of course, you can alter procedures
etc from any com compliant application by referencing ADO, or late
binding to ADO and using SQL. TTBOMK one should be able to establish an
ODBC connection from Access 97 and then run pass-through queries to
accomplish the same end.

A free alternative for your client to update function and stored
procedures in a remote MS-SQL Server is to download SQL Server
Management Studio Express.
http://go.microsoft.com/fwlink/?LinkId=65110
TTBOMK this utility is backwards compatible with previous versions of
MS-SQL. The interface is friendlier than Access's interface (for this
work of altering procedures etc.) and so I use it rather than any
version of Access for this purpose. In addtion it will generate Change
Scripts eg.
ALTER TABLE dbo.Tasks
ADD Whatever nchar(10) NULL
which can be used in the manner described in my first paragraph.

Jan 12 '07 #4

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

Similar topics

3
by: Ian | last post by:
The beginning of my assembly that I am getting the access error from looks like this. ********************************* Imports System.EnterpriseServices Imports System Imports...
4
by: intl04 | last post by:
How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...
9
by: Albretch | last post by:
.. I am trying to create a database in a MS Access DB via JDBC drivers. I have tried both sun.jdbc.odbc.JdbcOdbcDriver and ids.sql.IDSDriver From some reason both drivers Exceptions tell me...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
2
by: richard.nicholl | last post by:
Hi, My application is in Delphi 5 with an Access database. I'm trying to populate a TdbGrid pointing to a TTable component. Using a TQuery I create a stored procedure (with a unique name that...
3
by: KEMDignam | last post by:
I have upgraded my computer to Access 2003, but I have not converted my databases since all of my clients still use Access 2000. I need to create a new MDB, but Access is telling me that I will...
3
by: MLH | last post by:
With Access 2.0 and ADT, one could create "stand-alone" apps that would launch using msarn20.exe. You didn't have to launch Access 2.0 then open your app. The tool used to create these runtime...
1
by: Arend Jan Nijenhuis | last post by:
Hi, I'm fairly new to .Net, but an expert in Microsoft Access VBA. For a large Access application, I want to create some sort of custom control (COM interop?) in VB.Net, to be used in an Access...
10
by: Minh | last post by:
I search in all the Disscussion but can not found. How can I create a MS Access Database file using C# code with a given Table Structure ? For example, I want to create a Access Database File...
27
by: max | last post by:
Hello, I am a newbye, and I'm trying to write a simple application. I have five tables with three columns; all tables are identical; I need to change some data in the first table and let VB...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.