Sorry, this is all a bit "after the fact", but I'm interested in oppinions
please as I may adopt this approach again:
I recently developed an application for a client which has to run on a very
slow and unreliable network. Replication is not on the menu for various

I searched this forum but didn't find anything like this that looked like it
was particular to .ADP files.  Maybe that's because it doesn't matter what
kind of file you're using.  If so, I apologize for being bone-headed.
We (not me, I didn't do it) have a .ADP front end housed on a ...

The customer uses windows 2000 and office 2000. I have made an access 2000
project (.adp file) as client connected via network to sql server 2000
server.
The problem is that import of excel worksheet via the client has become so

We are planning to move our database from Access to Sql server.But the front
end application to remain in Access.We will be creating ODBC links to the sql
server database to use its functionality. The problem is if while creating
the links in Access if  I do not supply the field for ...

Being new to access, I used the Query builder to identify the field list in
Report Generator. I'm creating a report in Report Generator that pulls across
multiple tables. As many as 8. When I get to the sixth table, it causes the
links to come up with an error. 5 tables is fine ...

Okay, I'm just about at my wits end trying to get this to work.  Here is our
setup:
Windows Server 2003 w/ Microsoft SQL server version 8.0.  We have a database
setup on the SQL Server along with an ADP project.  The ADP project works as

Would like to update a field with current logged in username (Active
Directory) whenever inserts and/or edits occur in a form. Using Windows
Authentication on SQL 2000. Dont know where to begin. Thanks

I just can't figure this out!  I have a mail merge that works with an Access
2000 parameter query (with linked Access tables).  Been working for months.
I've changed the parameter query to use linked SQL Server tables and it
works fine from Access.  When I try to connect the new ...

Goof morning,
I still have in the event log next messages :
Event Type: Information
Event Source: MSSQLSERVER

I would like to be able to identify the form that loaded a particular form
so I can do refreshes and updates to the correct form, is there an easy way
of doing this?
I was going to pass a paramater on launch to identify the calling form and

I have a table named Addressbook with fields:
ID int
Name nvarchar
I want to change the type of ID to:

Im trying to make a form in Ms Access ADP XP, and using a Back end SQL
Server 2000.
Everything is great, and works fine, But I will use this app by Internet.
Any advise in how to improve speed.  Maybe using lees combo boxes?  I use

I'm using a sproc to return role membership values and it worked fine when I
used just one input and output parameter. I run the sproc on the adp's main
form and set different global variables to true for every role the user is a
member of.  I want to try and pass all roles to the ...

How can I apply a digital signature my ADP files?  I have searched it, and
found the steps Microsoft gives to apply a dig. signature to a reg. Access
app, but I cannot find the places in my ADP.
Thanks,

I’m using sql 2000 and Access 2003. Ok, in Access to create a Parameter Query
you simply type in the fields criteria something like: [Enter a Trip No] and
you’re prompted to enter a Trip No.
With sql I’m trying to create the same type of Parameter Query that will ask