I use the command
    DoCmd.RumSQL (select * into tempTB from table1)
in VBA.
The command runs fine but only insert 199 items. (tabel1 has 3000 items)

I want to read in an Excel spreadsheet (multiple sheets from a workbook),
update some of the cells, then transfer that range of cells back to the
spreadsheet. I don't mind treating the whole sheet as a table, but the ADO
Update method doesn't work and I can't find any other ways ...

Is is possible to change the font used in the SQL view of queries? Not a
big deal. but I was somewhat surprised to not find anything in the options
dialog.
Thanks.

I have a main from based on a table, sorted in ascending text order, with a
subform, based on a temporary table sorted on Surname. When actioned the
subform sorts on a different field, the 1st in the subform irrespective of
what I try and do. I need to keep the temporary table to ...

If i'm importing and exporting excel from access, I can do this until the
cows comes home.  Where I have the probem is I need to either pull or update
a particular cell in a table or have the ability to format the cell.
From what I found (trial & error) is that the user must have ...

I may have to install a runtime Access 2003 on a citrix setup. Is there
anything noteably different between setting up the runtime on citrix vs
ts? I'm not likely to have direct access to the citrix server, so it's
going to be tough to troubleshoot if there are issues.

I am trying to access a table using a module in Access 2003. The help
documentation tells me to add this line:
Dim dbs As Database
I get an error that says "User-defined type not defined"

We have numerous Access 2003 Databases.  When we install the full access
version on a user machine all works fine, i can view employee details etc.  
When i install the Development package that i have created from Developer
Extensions, i cannot right-click within a Database.  Is ...

I'd like to install Access Runtime on an Office XP System.
When I ran the setup program from my deployment package I wrote over the
Office XP files.
Is there a way to install ONLY the MS Access 2000 runtime ?

I'm creating a database in Access 2000. I've creted parameter queries to
prompt the user for a job number prior to showing the records in a data
sheet. What I need is code to:
1) After prompting the user to enter a "job name", list all the job names in

I've created a switchboard that opens reports.  If I try to print the reports
while the switchboard is open, the focus goes to the switchboard and prints a
copy of it instead of the reports. I tried creating a custom menu just for
the reports but I can't seem to attach it to the ...

Hi! I have buy the access developer extension 2003 (ADE) to create client
access application to distribute with access runtime (with MSDN Enterprise).
But, now I need to distribute the client application with access runtime for
2000. Does the ADE 2003 version works in it?

I downloaded several patches, updates for runtime Access XP but I still have
problems with the installation in windows XP proffesional Service Pack 2.
First It says that the language is different, when I change it to English (I
live in Greece) then files for NT is missing.

Hola, estoy haciendo un archivo por lotes que ejecuta un xcopy y quisiera saber como me refiero a la ruta (path)actual en el mismo.....
Es decir, imaginen que la letra de unidad de CD-Rom es variable, en algunas pc es D: en otrs puede ser E: y en otras x: .... como pongo en la ...

We want to have an existing maintenance database alert particular individuals
when a new record has been added to the database so the correct person can do
the work requested on the new record.  Several people will have access to the
database to be able to check, but we would ...