I am using the FileSystemObject  to copy files on a computer
Dim MyObject as Object
Set MyObject = CreateObject("Scripting.FileSystemObject")
MyObject .CopyFile "C:\My Documents\Test.txt", "C:\New Folder\Test.txt"

I have an acquaintance who is doing some A2003 development who was
asking a question on another forum (not a technical one) about an SQL
problem he's having.
As far as I can tell, he *is* using Jet as the database engine, yet he

I'm looking for a way to reference the string name of an enumerator.  I know
in VB.net you can do "MyEnum.ToString" and get the name instead of the
integer value.  Is there a way I can do something similar with an Enum
created in Access?

I will explain this situation using a scenario. Let's assumed that i'm
working on a library system where i need a loan form that will only
show books that are available for loan. In this case, this form has a
main form that shows library member's details and its subform shows the

I need to import an Excel file.  For reasons I won't get into, I cannot
just link to the file or do an import specification, so I need to do it
via code.
I know of two ways of doing this - via a recordset and using the Excel

I have an Access 97 application that has a basic form (Transcript) and
subform.  The subform has a query as a recordsource that returns
records from a table:
SELECT DISTINCTROW Transcript.NCID, Transcript.TransCode,

trying to begin to learn database using vb6, ado/adox, mdb format, sql
(not using access...just mdb format via ado)
i need to group the values of multiple fields
- get their possible variations(combination of fields),

I have a database with all the research capabilities of professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search
my entire database for the keyword entered by the user and show up

i have 1 field in format date/time, in format tab i set mmm-yy.
my goal is when i type 02-05, the record will be FEB-05.
But it records May-06(current year){i think 02-May-06).
any help with appreciated.

I'm looking for guidance in doing a specific delete query.  Let's say I
have two tables, A and B.  Each table has a numeric key field that is
type long integer.  Now, let's say that table B is a subset of the ID
numbers in table A.  I would like to delete all records from A that

I am relatively new to Access. I can join tables and run queries but I am
stumped on this one. I have a SAP table downloaded called Roles that contain
a range of values for transactions. There is another table with all the
transaction values. The Roles table has a value From and ...

I am running IIS v6.1 on a virtual hosting server. Changing the default
metabase value is out of the question. Can someone tell me how I can fix
this script? Thank you.
<%

I know that you can format url's withing an Access database but can you
physically attach Word, Excel or pdf files within one? I need to attach
backup documents into a database I am creating. Any suggestions for a
workaround or alternative solution? Thanks

I've been given a heads up on a task that might coming my way. I don't have
full details yet but understand that it involves getting the access
application to connect to a web application to get quotes. All I have so far
is that it may involve http POST requests and XML messaging. ...

Just like everybody else nowadays, you are facing infinite amount of
information everyday. how can you keep those that truly matters to you?
MemoDepot allows you to do just that, and much more!
- Capture any information, store as notes in your MemoDepot account,