Hi.  I'm new to this board and have a few questions about using th
method referred to in the topic of this message
I have manually transferred over 1/2 million records from a text fil
into my Access table in under 1 minute, using File>Get Externa

GHudson has working procedures posted at
http://www.access-programmers.co.uk/forums/showthread.php?t=66320
They work. Relationships, however, and some minor default settings are
not preserved. Reestablishing some default settings and settings is a

I'm running a union query (12 unions over the same Object*). I'm
getting the following message: "Cannot open anymore databases"
* The object is another Query.
How can I avoid this problem?

I need to create a report that has a Group Header that pulls certain data
from the Detail section. It's something like this:
+--Report----------------------------------------

I have an Access db that I want to split (front end and back end) and
send to someone to use.  I, also, want to disable the 'bypass the shift
key' function so that this user will not have access to the source code.
I know how to do this (and it's working just fine on my PC) but ...

I am quite new to VBA and Access, but I am trying to figure out how to
export specific values from a table in Access, so I can save it in a
given cell in Excel.  I have been able to figure out how to open and
modify cells in my spreadsheet, but I don't understand how to select

An excellent solution for Access 2.0 and MAPI mail appeared
on microsoft's website...
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B99403
Searching their site for similar code functionality under Access 97

i have a standard SQL statement that works fine with MDB and DAO.
Now i've put my tables on SQL server to  use them via ODBC.
The same SQL let me update some fields but doesn't let me to update
certain fields. I can assing values to fields but when i perform the

Which are the options for publishing access information over an
Intranet?
Besides ADPs, are there any programs I can use for letting people use
Forms of an Access DB inside IE? I've been reading that ADPs can't

I have a button setup to run a macro that does a OutputTo command on a
query to Excel 97-2003. The macro runs fine, but after it is done for
some reason the SQL code in the query is deleted and it only does it
some of the time. I'm not quiet sure what is causing it because if I

I've lost ability to drag the slider bar at bottom of database window
in A97 on many occasions. Have no clue as to the origin of this.
Do know that its darned inconvenient. Comments appreciated.

Hello and thanks for taking the time to read this.  I've looked all
over the web and newsgroups and can't find a solution to my problem.
I've posted this question to the Access 2000 group as well - sorry for
cross posting.

What are the ways data can be transported/moved among these Products.
SQL Server, Access and Excel. The main ways are:
Replication Service, BackUp and Restore, Data Link Server,Import/Export
Utility, BCP Utility, Using Database APIs(DAO, ADO etc). Is there any

Firstly, please accept my apologies if this problem has already been
answered in other posts / groups. I have searched as best I can, but I
can't find the exact same problem elsewhere.
I have an AC2003 database (split into FE/BE) that provides (amongst

I've searched all the groups and only found 1 link on this, and that link
returned a 404.
Access2000
I have a form with a FindRecord command button. When the form is the only