I am using the read-only command line option to open a database as follows:
c:\....\msaccess.exe \\server\....\dbname.mde /ro
However when the database opens a dialog box is displayed saying "The
database 'dbname' is read-only.  You won't be able to save changes made to

Good Day..
I have posted this question on both the Excel and Access
groups because I'm not sure who can help me on this, I am
new to this stuff.

I have MDAC corruption and I can't reinstall MDAC.  When
I try to install MDAC 2.8 I get a message back telling me
that this version is already installed with windows.  I
am assuming SP2 for XP did this.  I really hate this

When a MsgBox is displayed, the corresponding Windows system sound (.wav)
will play. How can I link a different sound to the MsgBox without modifying
the Windows sound scheme?

Dim dbsTest As DAO.Database
Dim strTest As String
Dim rstTest As DAO.Recordset
strTest = "SELECT Val([Forms]![frmTest]![testField]) As

I am using windows 98 operating system.  How do I change to the xp operating
system.

I have huge application on access
I have reached to the limit of moduls on my application
Therefore i need to use referances. The problem is:
i have two mde: master, secondery when the master have referance to the

I am knocking a little app together at work with a view to expanding
features in the future.
It's intended for a garage/workshop for booking customers jobs in.
I want to control the whole thing with function keys and cursor keys. I have

A client has asked me to develop a membership system that reads and writes to
the magnetic stripe on plastic cards.  He has acquired a device that connects
to the PC COM1 port.  Can anyone point me to some help that explains how I
read/write to this COM1 device in Access please ?

Group:
I have an input form with fields that are bound to a table, and I want to
develop a VBA subroutine that will copy the contents of the prior record
(all fields) into the current record. Can anyone give me a hint as to the

I'm just looking for a discussion of the difference
between the following two lines of code:
   [FormTab].Visible = True
   [FormTab].SetFocus

Can anyone tell me how to load a .pdf file into Acrobat
Reader from within Access 2002 using code - assuming
knowledge of filename, filepath etc?
Any help much appreciated.

I had splitted my dbase in tables and in the other side I lefted the other
things my question is
Should I install the front in each pc or left it in the server and let all
the operators share it.

I am writing out a recordset to Excel using CopyFromRecordset.  Some
of the fields in the recordset are defined in Access as dates.  When
Excel opens, these fields are displayed as Julian dates, I think.
(37824 = 7/22/03)

How can I find out the name of a mdb to link tables to?
e.g. Mdb1 uses "Call Shell" to create a second instance of
MS-Access and open Mdb2. Mdb2 then needs to create links
to tables in Mdb1 using "CreateTabledef". The issue is