VB Forum / Database Access / October 2004

I have an MS Access database of company names (2.2million of them) and
i want to find a particular company that a user enters in a textbox.
WHich is pretty easy to sort out.
Now the problem I have is that some companies names don't follow a

Hi,
I need to copy a table from one access mdb to another. Is there a quick and
easy way to do this in code? I need to drop the existing tables from the
target db and replace them with the new ones. The really important part is to

List:
Is there any way to determine the next value of an autoincrement field
in a Jet database?
I know how to grab it at update time.  What I need to do is grab it at

Could someone please help me with code to save and retrive images using VB6
and a access database
Thank you

I am have a numeric field "Sequence" in DBGrid1. If I change the Sequence of
a record and close the form that contains DBGrid1, it is updated to the DB.
However, when I change the Sequence value and run a command button procedure
that uses the Sequence of that record, it shows ...

I'm just trying to open a stream doing the following:
Dim s As New ADODB.Stream
s.Type = adTypeBinary
s.Open

In a database I have a list of accounts with multiple records. I expect a
certain status (i.e "curr") at the last record for each account. If the
expected last record is not there (i.e. status is not "curr") then I would
like the encountered last record to reflect a status of "off". ...

I want to create a recordset from a dbf (dbase IV) file using SQL with a
group by statement. Is this possible?
I receive a strange error message, saying that (translated from dutch) the
selected setting of the sorting sequence is not supported by the operating

I have a file of binary fields I have loaded into a database.  It was
inported as one field.  I would like to seperate the data into fields but
there is no delimiter. Does anyone out there have any ideas.  Microsoft
informed me that to their knowledge this has not been done since ...

I'm writing a database application which could have multiple instances
logged in to the same database, I need a quick way to work out if an
instance has exclusive access so it can perform maintenance tasks.
I don't want to use a Logged In table because that would leave false ...

we have the same problem as mentioned here:
Any ideas ???
Thankx
Martin

Look at the following code:
Private Sub cmdEnter_Click()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogOpen)

I have a problem with biding(I think) a combo box with text boxes.
The combo and text boxes on my form are loaded with the correct data.
But, when I click on the combo box and select a different data member
the combo box reflects the selected change(text changes) OK but my

That is the question. What is wrong with this sentence?
"Select 123.idunit, 123.unit, description from 123 inner join mainunits on
123.idunit = mainunits.idunit"
When I try to open those two tables in a INNER JOIN sentence, I receive the

I use the Schema.ini to read text files.
I know about extensions key in the registry
I can get in.txt to work but if I put multiple periods
ie. in.in.txt - it doesn't work. Is this a limitaion???