Working with a downloaded table form a Lotus Notes contact manager. Now in
access call tblclients.
I query certain info. to update the records.
BUT...'Is Null' does not work. It comes back empty and there are definitely

I'm running into a problem automating Word from an
Access '97 application in XP (this problem doesn't occur
in NT).  My code creates a word object, opens an existing
word template, fills in bookmarks, saves the document, and

I have a whole bunch of Access97 databases which we are
converting to Access2000.  Most of the converted simple
ones perform okay.  Of course, a few will need more
attention.

When converting an Access97 database to AccessXP got two
error massages
Missing or broken VBE reference to file 'dao2535.tlb' and
Missing ot broken VBE reference to file 'Itsctn31.ocx'

I wonder who could help me with this.
Is it possible to migrate an already programmed database
in MS Access to SQL Server or this needs complete
reprogramming?

Has anyone tried to convert an Access 2.0 database to a
2000 or XP database.  I tried it and I also modified all
of the code that seemed to be incompatible, it works, but
it still acts like there are some bugs. When clicking on

I have created a database with all my contacts and thier
information in it.  I need to send an email informing the
people on my table to save the date for my wedding.  To
save money costs I want to email the invites to those who

Is there an easy method to import an Excel formula to an
Access db? I'm guessing that it would have to be converted
to be used in an Access query. Thanks

This is probably an easy one for you guys, whats the best
way of converting an excel wordsheet to an access file.  
Theres a fair amount of data too much to do line by
line.  I assumed even at worst case I could cut and paste

I'm using function LOWER to convert string i my table on
small size but Access gives me a message that the function
is not defined.Please, do you know another function?

Is there any way to import or convert an Appleworks
datadase to a Microsoft Access database??

Is there any way to migrate an access database to a
standalone product?  In other words, is there a way to
operate a access data base without the access program.  If
so what would be the basic steps, ie purchase from a third

After I converted from Access 97 to XP I started having
problems with “database needs to be repaired or isn’t a
database file” messages. The situation as follows:
1) There are 15 to 20 users may be working at a time (we

We have a number of apps written in VB6 using DAO 3.5 to create and massage
the data.   Quite often, we find a need to use ACCESS by itself to
manipulate one of the tables independently of the apps.
This wasn't a problem as long as we were using ACCESS 97 across the board.

I have this table named tblTrans and I need to
transfer this into MS-DOS Text format.
I have used the DoCmd.TransferText command.
My table looks like this: