Thanks in advance.
I have a working ODBC connection to SQL Server 2000.
Today, one of out 5 SQL tables is showing a following error.
ODBC Call Failed

Access 2007. Database size 11MB, table has 9 fields already, and 5k records.
Want to add a picture from a digital camera to be displayed on a form. I
know I can make an OLE field to store them but I am concerned about the size
of the database.

    I have some monthly-rotine work to do ,inorder not to write the same
queries every month,I’ve put the problem on this discussion group,and Mr. Ken
Sheridan and Mr.  George Nicholson have kindly guided me as to save the
monthly data tables as the name current or previous,thus the ...

hi.. im really new at this access programming.. I need some help on this a i
dont what to do next..
I created a form where i have some input fields.. i have this form bound to
a table.. so those inputs are being sent to the table.. After this i created

I would like to move and/or copy an external binary file (actually zip in
the immediate case) from one directory to another using VBA.
The only alternative I can think of at the moment would be to create a batch
file and run it, but that's kind of corny - there must be a better way.

i think thats my hacker im not kidding

im being hacked, im near the edge right now!

I have records that are tracking locations and amount of money spent
in various categories.  Example:
Paris, 10/12/2007, 10500
Rome, 11/15/2007, 9000

someone is hacking me and i cannot stop him and hes taking my messages and
reverting them to gibrish. please help

I have always learn that you do not make a key with the length of 100
characters because it uses too much internal memory to process and slows the
system down.  Is this still true with SQL and VBA?  What suggestions would
you have me give my client?  They want the part number to ...

I have this code on the afterupdate of a combo:
   Dim X As Long
   X = Me.Recordset.RecordCount
   'If Not IsNull(Location1) And Location2 <> Location1 Then  'specify a

What is the best (most flexible) program to print envelopes from?

I would like to create a subform as a spreadsheet that has 2 columns.  The
first column uses a drop down menu to choose a category (using a 2 column
combo box).  I would like to have the choice made in the drop down menu for
category to automatically populate the second column, ...

I posted a message a few hours ago, and I got a very prompt reply (many
thanks!)
However, when I click on the link, only a blank page displays.  Below is the
link I click and the e-mail I recieved.  Please advise on how I can read the

I have PC one and PC two. In PC one I have nicelabel (nicelabel is an
application to create and print lables) installed with a specific label.
I would like to make it run that label from an access form. Is it possibel?
Regards,