Please can someone give me the code to search through a database and replace
one letter with another letter? So that it doesn't have to be done manually
each time.
replace code -

Hi to all..
can i do scheduled backup in access 2000?
there's a script?
thx

I have an application in Access 2003 which allows users to access a back end
Access database on a server.  This is distributed as an Access run time
application using Access Developer Extensions. I want to allow the users to
select the path to the linked files at run time.  Is ...

My code needs to create a new bank database for each new job.  My routine
below does this fine when Access is installed but 429's on machines with only
runtime.   I now understand that Runtime requires a filename but have also
found that creating a new database (mde) file is ...

My 2003 Access application, packaged with MS Developer Extensions, installs
fine.  However, I receive the dreaded 429 error on all machines that it is
installed on when the CreateObject is used.  
I have had a user run regsvr32 "C:\Program Files\Common Files\Microsoft

I have a query that is a make table type.  I want to use it to archive files
into daily uploaded tables that indicate what was loaded on a specific date
to our main office.
The basic code was built using the wizard and when I open the query in SQL

I am following the instructions in Paul Overway's white paper on
distributing the run time for Access, using Access 2002.
I have run msiexec on the AccessRT.msi and the Office1.cab file (Access
2002  appears to use Office1.cab and not AccessRT.cab like 2003 does).

I have developed an Access Database (MS Access 2000) that handles scheduling
for my company's maintenance needs.  I am currently trying to devise an email
notification scheme so whenever a new maintenance ticket is created, there is
an option to notify the appropriate owner.

DLookup("[Edit_Num]", "F1120S", "[SSN] = [EIN]")
The F1120 is input first then a F1120 verfier form is opened and input is
VERIFIED 100% to be identical.
I.E the above process worked fine brining back the right information using

Like many, I am trying to make a PDW package actually work. That is, install
my MS Access application complete with required library files for
distribution. I understand that this is something that can't be done in its
own right and that if I don't use a third party piece of ...

Is it possible to update a Front-End with windows script (vbs)?  I've got a
short and simple script setup to check a version and copy the MDE if
necessary, but the following code results in a flash of Microsoft Access,
then it disappears (I assume because the script is finished ...

Hi can anyone help?
I have an .mde file distrivuted to my clients and all of clients can share
the .mde file but with one client I get a message that says the following
"you do not have an exclusive access to the database at this time."

What process and files do I need to have or use to take an existing Microsoft
Access Professional 2003 database application file in   *.mdb format and
place on another separate computer and be able to acccess the forms, reports,
etc of that *.mdb application.

I have Access 97 and 2003 because I have licensed versions of Office 97 and
2003. I need Access 2000 probably, plus developer tools for all three if I
want to start building apps for people and giving them runtime versions if
they require it. I think 2003's tools come only with ...

Is there a way or is it not possible to update your application without
uninstalling?
Reason for asking is if someone has a good ideal about a feature,
report,etc., and I want to use that persons ideal in my application(which it