I have been asked to convert an access 2002 application to mssql 8.0 (keeping
the front end in access).
I have searched your site for information.
1)How do I actually transfer the mdb tables to mssql?  I could not find this

is it possible in the adp application im creating in access 2k3 to
create a routine that will allow the end user(only 1) to backup a sql
database and restore the database at will?
thanks for any and all help!

Hi. I'm new to this list and to working with ADP's so forgive the
newbie questions!  I am in the process of upsizing an Access 2003
database to an Access ADP/SQL Server app and thus need to make lots of
syntax changes to queries, etc.  A form has a combo box that

I've got a small Problem. I want to copy several rows out of (Ms SQL) Table
A into Table B. Table A and B are the same and are within the same DB
Is that possible?
Thanks for the help

Pardon the cross-post--I must have overlooked this NG when originally posting
to microsoft.public.access.reports.  The below includes my original post as
well as some new findings.  Original problem still exists.
X.

2. I would like the form to requery and display new connection info in the
textbox when I change the connection with File, Connection from the
built-in menu bar..
3. I tried putting the requery in the form's OnConnection event, but that

I have a web tracking program that writes it's data to a MSDE database.
Unfortunately it writes each day's data to a different table. It names them
connection_events_2005_10_20 then connection_events_2005_10_21 etc... I need
to create a report by the week from all of these tables ...

I have an Access project that I created from an existing Access
database.  SQL is 2000, Access is both 2000 and 2003.
The existing Access tables had field names like [IDF DATA(1)],
[IDF DATA (2)], [IDF DATA (3)].  Those names are ok in SQL as long as

I have filters I have to apply to an access form that are more than 255
characters:
Division IN ('Administration','Recreation',.... etc. to beyone 255
characters.

Let me paint a picture...Access 2000 frontend, linking to a SQL Server
backend, inherited database, me  - fairly new at this! :o)
The developer has, for better or for worse, (I'm not sure), designed a
frontend that grabs a set of order records from SQL and pulls them into

I'm trying to put an existing FE MDB under SourceSafe Control using Access
2003 and SourceSafe 6.0 Add-In.
I can add the database, check objects out, make changes, and check back in.
Everything appears to be OK.  But when I execute the CreateDatabase from

The company I work for currently has all their data in Excel spreadsheets.
We want to set up an actual database using MSDE/SQL Server Express as the
back-end, and Access as the front-end.
The question at this point is whether we should use .adp, or just use .mdb

I am about to start developing  a multiuser aplication using SQL-server and
ACCESS FRONT-ends.
A friend of mine who is familiar in Dot.Net programming is advicing me not to
use ACCESS. (He thinks that a performance

I need insert in my report a grafic. But I need to pass two parameters, the initial date and the finish date of the report.
how can I pass this two parameters, if the grafics objets dont have any inputparameters?
thanks a lot

Should I use a stored procedure or a view when filling a record source in an
.adp?