I am writing a program that will export access tables to Excel.  The problem that I am having is that Excel has a limit of 65536 rows per worksheet, so data ends up missing from the worksheet.  Is there a way that I can export the remaing rows of data to another worksheet?  DoCmd ...

I'm creating a database for my department.  Many of the
computers accessing this database will be Access 97 Run-
Times. The IT person told me that, concerning the err
object when error trapping, I only can use the err.number

I'm receiving an error message on when an access db is
opened by a remote user who I sent the file to.
It's associated with a Switchboard not opening up when
file is lauched.

I bought XP developper tools Kit, and i just want to install the access
runtime. How to do it ??
Thanks
Jerome

Any known problems usiing an app developed in Acess 2000
as a runtime program, running in Access XP?

I've created a split Access 2003 database. I package it with MS Visual
Studio Tools for the Microsoft Office Systems. The location of the backend
database is different in production than it is in development. How do I have
the installation ask for the new backend location or is ...

I'd like to see some examples of a finished Access application, particularly to view the user interface.  I'd like to make my application look more professional but not sure what to do.  Thanks for your help,  Maggie

Does anybody know abour the availabilty of an access2003 Runtim eor
Access2003 Office Developer Toolkit?

Is there add-ins or dlls which will allow Access to run like a client server
database.
I have some very large (>500Mbytes) Access 97 databases that I want to "play
with" across the internet using the standard access 97 interface (including

Group:
I would like to use custom icons to represent my front-end and back-end
database files. Can this be done? If so, how is it done? What do I have to
do in order to install them? Do I need a special program to install the

KB article 824278 (http://support.microsoft.com/default.aspx?scid=kb;en-us;824278&Product=acc2003) indicates that Visual SourceSafe support can be added to Access 2003 with the VSS addin from Office XP Developer.  How do you install this?  I've tried using the standard setup ...

The Access 2000 Runtime that came with my Office 2000 Developer is old - it lacks the security patch and SP3.  As such, my users have to install the updates after installation.  Does anyone know of a way that I can include an up-to-date Access 2000 Runtime in my deployment ...

Thank you, Vinson,
I will work on that and will be back to the forum to tell
abuot the result.
But I remember something else.. Hasn't anybody encounter

When installing the runtime developer application I have made a *.reg -file. In that file I have asked it to make two registrations which are:
[HKEY_CURRENT_USER\Software\VB and VBA Program Settings\MRD-SYSTEMDATA\Sti]
"2sprog"="F:\DATA\PAED\DATABASER\2SPROG\DATA2SPROG.MDB"

We are running Access2000(front-end) SQL server (backend).  When we try to
either compile or run an ADE, we receive the message "Error Accessing File.
Network connection may be lost".  When you go to File-Connection-Test
Connection- the message "The connection succeeded" pops up.  ...