By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Create ADP in MS Access 97

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.