How do I know which version of MSJET40.dll is currently being used by
Access on my PC?
and can I distribute an older version and still expect it to work?
If not, can I go back to an older version on my PC so that I can

is there any non-windows option to convert a .mdb file to a text file
database? Comma or tab separated values would be best...
I need the raw data only, but I don't have access to any win platform:
no Win OLE, no Visual Basic, no Win platform for mdb2txt...

I have created an append query and I am having a problem with the
format of the number column when it appends.  For example.  4.5 appends
as 4,a value of .5 appends as 0. I have adjusted the append query to
standard format three decimal places and have done the same for the

I have the following code to open a second A2000 mdb. It opens the second
mdb Ok but it the second app alos closes immediately. What do I need to do
to hold the second mdb open while work in it?
Public Sub OpenAddIn()

I'm trying to track down a problem we're having with our MDB growing
in size. We have a Windows service that is accessing a MDB constantly.
Part of what this service does is "refresh" the contents of a table by
deleting all records and then inserting into it. This is a process

I`m in the process of migrating a Access 2002 (Run in 2000 mode) from
Windows 98 to Win2K Server. It is a shared resource via a file share on
the 98 Server. Client systems are Win98 with the shared drive mounted
and the application run via the shared drive.

I have a subform called PaymentDetails and would like to dynamically assign
the recordsource after the form/subform is opened.
The recordsource for Payment Details is "PaymentDetails_qry" which uses
a function to filter the Invoice #.   The invoiceID is not known until after

I'm trying to write the results of a query, a name, ID number, and
date
out to a notepad .txt file to
print on a "legacy" printer.

Does anyone know of a way to change the length and width of a form in
code? Say if someone presses a button the form doubles in size to
reveal a some text boxes. I just need the code for the size changes if
such code exists?

I have a database that I inherited that has query in it that has
hidden fields when it is in design view.  Datasheet view shows the
fields and when I switch back to design view it appears as though
those columns are compressed.  If I try clicking between the columns

Hello all. I need to post a graphic but I understand that it is not allowed
in the newsgroups. I know how to upload a graphic to my website and how to
compose the link that will access it there. I don't know how to include that
link it in my post. Any help will be appreciated. ...

Here's a weird problem.  I've seen it before on clients' machines, but now am
having it on my own for the first time.  What has changed is that I've just
gotten a new computer and it has WindowsXP (service pack 1 only).  I'm working
in an A97 database.

Wondering if anyone can help me...
I have a created a table with a tick box field in it for a large number of
records. I have also created a form and in the form is a Text Box and a
Command button ( please see http://webmonky.myby.co.uk/despatch.jpg ).

i am about to release an access database (all tables and front end are
in ms access 2000), where certain trustworthy users wish to make their
own read-only queries for flexibility in reporting.
in oracle and ms sqlserver we can create read only views that the

I Started working on a db I'm building as a hobbie, However it has
turned into quite a project. I have copyrighted it just incase. Now I'm
wondering How do I assess its value if I wanted to sell it? Is it worth
a can of Coke or a pound of coke. How do I establish which? Should I