I'm trying to convert a complex .MDB database into .ADP.  This is all new to
me so I'm learning.  I have read here that ADp files don't have data.  If
this is so, where is the data?  Currently all my data resides on an MDB file
(I long ago split the code from the data).  What do ...

I have been using Access for about 15 years now, have taught myself enought
to fumble thru the VBA programming issues I wanted to use and now I feel like
I am back to square one.  I had been developing a front end for a SQL back
end using linked tables that were giving all kinds of ...

Has anybody experienced Timeout issues on updating NText fields in SQL
Server 2005?
Ive been using a procedure in an MS Access application, to read in the
contents of an Ntext

I still don't buy that this is either product-specific or amateur-specific.
I've seen countless numbers of experienced, formally trained (and who
learned it on their own) database programmers on every platform I've ever
used who use "tbl" for tables, "vw" for views, "usp" for ...

I have been using Access for many years.  I now need to upsize to SQL
because my website is getting much more traffic than it used to.  I
want to continue using my existing Access forms to populate the new SQL
database.

So I've used ado.net to retrieve me a data table and I want to drop
this as an mdb file. Does anyone know how to do this? Everyone seems to
be going in the reverse direction.
Thanks!

One of my developers tells me when using an Access ADP against a SQL Server
2000 back in there are concurrency issues.  He has seen one user edit a
record while another user has the same record open and then the second user
can make changes and save the record without receiving ...

i need to store a forms recordsource in a variable.
when i use me.recordsource i get a SQL statement.
the form is bound to a table - not a stored proc or view.
?

We are using .adp projects.  Lookup tables typically have a single field for
the key to a lookup table that populates combo box lists.
These lookup values are stored "as is" in the detail data tables, and RI'd
back to the lookup tables.  Example: lookup table primary key values ...

Hi, I'm opening a report from code and I'm using the Where parameter of
the OpenReport method.
Is there a way I can reference all or part of that where condition in
the report itself and print it in the Report or Page Header?

Does anyone know what the differences are between the full version and the
express slq server 2005 are?
Or send a link to a site that might lead me in the proper direction.
Thank you in advance.

i want to group by  date field and display it in format of dd/mm/yyyy.
the problem is when i use the order by  Format([dateCreate],"dd/mm/yyyy"),
its not order by real date.
any solution for that ?

I have a process that I need to move from an Access .mdb database to an
Access .adp project and I'm having trouble with one part.
I have a macro that opens a pop-up form for the client on the main form and
shows a "count" of how many employees that client has.  Then I copy that

I need to select data from a table that could come from one of two fields
depending on the values.  In Access query, I used the following and it worked:
BN: IIf([BranchRandom] Is Not Null,[BranchRandom],[Branch])
Can anybody tell me how to do it in SQL for a form in a ADP Project??

We have an ADP that was converted from an A97 database maybe 3 or 4 years ago.
Until recently, the lone front end was shared by about 10 users.  Corruption
got to be a very large problem in the front end.  Recently, each user got his
own individual .ADP.  Corruption is still ...