I am based in Atlanta and our server is in Orlando. I recently wrote an
Access application that runs very well; however, the runtime is poor when the
application has to access the server. I would like to try the Desktop SQL
Server but, according to my reading on this, the ...

I need to import an old Foxbase database into Access.  Is there anyway to do
this?

I have an access 2003 database.  I will be bringing in and Excel 2003 value
but the column a is key or needs to remain the same with the same data in
table and column b will change when inventory is changed and I need to be
able to import in just the column b changes and have ...

I have a Access application with two linked SQL-server tables.
How can I distribute this application without asking the user to set up an
DSN-datasource on their clients.
I can not use 'Trusted Connection'.

Good morning,
I have an Excel workbook which contains multiple worksheets.   These
worksheets are linked to an Access database.  The users will input the data
in the worksheets, and my database is pulling the data from those worksheets.

I am trying to import data from a table in db III format into Access 2003.
I noticed that sometimes the Access in not matching the case of the
characters.
for example, its importing "721((,A" as "721((,a"

My database is updated daily and one table is very large so when I import my
data to this table, I am now getting an Access error message ' Your computer
is out of disk space. You wont be able to undo this paste append ' .  Why
this message and what can I do about it ( is it ram ...

I'm using the TransferSpreadsheet function in vba to export a query to an
Excel file.
I have 5 queries that I would like to export (via vba) to 5 separate Sheets
in a single Excel file.  I want the User to be able to click a single button

I have a report in MsAccess that I want to export to Excel.  To export to
Excel, I'm usin MsAccess' function (i.e. Tools/Office Links\Analyze It With
Ms Excel or Files\Export).  The report has 3 groups.
The problems that I'm having are:

I need a way to dynamically process input CSV files with varying
schemas. I have not found a way to get Access to ignore extra or
missing columns. For example, suppose I set up a work table with 30
columns. Sometimes I want it to automatically import a 10-column table

I'm doing some testing on what happens if a user starts my app and the path
to the back-end file is not valid.
I puposefully changed the folder name for the backend file, so that Access
would have a problem.  Thereafter, I immediately get an error message when I

i KEEP GETTING A MESSAGE STATING THAT i AM HAVING A "SPOOLER" PROBLEM AND
THAT IT IS SENDING THE INFORMATION TO MICROSOFT.  HOW CAN I FIX THIS PROBLEM?

Import of text does not work for files over 4GB because it was developed
under FAT32. The Microsoft Text driver has not been touched for years and
years. Some new functionality with regards to the built in functions would be
nice. Example, a REPLACE function and many others could ...

I have Access Frontend with odbc to foxpro data.  Can get to data in 2gb
foxpro table, open in query or report, then close report.   Task Mgr shows
Access at 0 CPU and 120mb+.  Try to open again and Access locks up.  Is there
a better way to 'close' the query or report - or do I ...

I have a macro set up that exports data from a query in Access2K to Word
2K...  
Currently it is set up to pull ALL records in the query, but I'd prefer it
to export only the record the is currently showing up on the form.  Here is