Once a master database is moved to other location, it becomes a replica.
Can someone advise why it happens and how to change it back to master
database.
Thanks,

How can I export a table such that data in memo columns is sent to
separate files, with placeholders in the main file?
Thanks,
Andy

...by keeping it turned off.
I had been getting frequent corruption of my Access 2003 systems, after they
reached an arbitrarily large size (# forms and/or lines of code).  It was
ridiculous - sometimes happening twice a day or more.  Sometimes decompile

If I had a field called "Name" in an Access table "Contact Info", and the
field contained VBScript...
Function Main(rstFields)
  Main = rstFields.Item("FirstName").Value

I have a bunch of hidden, popup, non-modal forms.
Forms(myFormName).SetFocus makes myFormName visible.
However...
I have a bunch of non-hidden, popup, non-modal forms.

How can I get to the Procedure Attributes window? According to
documentation its in the tools menu of the MS Access VB editor. I can't
find it...its not there...
I'm using Access 2000.

Private Sub Paid_BeforeUpdate(Cancel As Integer)
Me.Due = Me.txtGTotal - Me.Paid
End Sub
is it possible if i change the value of "paid" then me.Due changes its

I have a very puzzling situation with a database. It's an Access 2000 mdb
with a SQL 7 back end, with forms bound using ODBC linked tables. At our
remote location (accessed via a T1 line) the time it took to go to a record
was very slow. The go to mechanism was a box that the ...

With all the recent discussions on ADPs and their lack of success, can
someone point me to some GOOD reading on what is required to link MDBs
to SQL Databases / Microsoft SQL Server 2000 Desktop Engine.
Also are their any good, concise summaries of key differences that

I have an Access 2K front end running on a Windows 2000 computer linked
to a MySQL database as a backend.
Recently after my Windows is updated I find that Access will not link
to MySQL. I have found that if I replace the msjet4.dll with an older

Where fields contain text, I've noticed that when they are first opened in a
form, all the text is hilighted. How do I avoid this? ... it's not
desperately important, but irritating! (I think it may be only memo fields)

My mouse wheel scroller works in all Access windows except Visual Basic
sub-windows. I am running Access 2002. Any ideas? Thanks.
S

I was doing fine with the query statement loading my list box until I
tried to add the additional criteria of ItemStatus = A (for Active).
Can anyone help?
Private Sub Form_Load()

I have a form in Access97 which facilitates a query against a production
Access database. Users will enter some search terms and see a datasheet
view of the results in a subform. The prod table is linked (the form is
not included in the production mdb file). I need to ensure that ...

I am unable to delete a subfolder that I have created programatically.
I am using a modification of the apiSHFileOperation by Dev Ashish
(http://www.mvps.org/access/api/api0026.htm) to copy the files.
A File Copy function is called as part of a loop to copy a series of