Do I have to disconnect from the database before I can change the ReadOnly from False to True?

Is that where I am going wrong? If so how?

Many thanks for any help.

I think it may be this:

ReadOnly = False or True

If, when compiling the program, I set it to False then I can Write a new record and read etc. But I cant backup the database as it's in use. If...

There is an option for 'Exclusive' which I have set to false so I assume this is the same as your 'Share Deny None'

I can't find anything to suggest Record Locking. What does this do? Does it lock...

I have a database working with VB6 and Jet. Everything works fine except that I now need the database to be accessed from a second machine on the network.

It appears that only one person can be...

I have a database all up and working and now need to create a grid view.

I am very new to VB and have been using the book Visual Basic in easy steps by Tim Anderson. On page 108 it describes how...

OK great thanks got it to work. The following code worked.

AdHocData.RecordSource = "select * from AdHocData order by StartDateTime asc"

Great, thank you, That fixed it. Sort of anyway ;)

It initially appears to have done nothing, but if I then close my program and restart it then the records are in date order. Is there some way...

Ah. OK thank you. I will do that.

Cheers

Yes I did register the component and it said it was successful. What else could be missing? I would have thought it was just the DLL

The date is stored as a text field in the database.

So it won't work because I used the field name StartDateTime?

I can understand it not liking just 'Date' but find it extremely odd that it does not like the above.

Is it possible to rename my...

I have a VB6 program running fine on the machine I wrote it. When I create and exe of the program that works also. If I export the program to another machine I get a 'Class not registered. Looking...

The date field is StartDateTime and I have added:-

Select * from AdHocData Order By StartDateTime

To the RecordSource line but it still does not sort via date order.

Please find attached the...

I have a .mdb database that contains various records. One of the fields is date, ie '19/10/2008 00:00'.
How do I sort the database by date?

I an a beginner and currently learning with the...

OK I finaly got it to work. Thank you for all your help.

This is what I needed to do:-

Private Sub btnNew_Click()

AdHocData.Recordset.AddNew

End Sub

Thank you. Could you please tell me how I would use the 'Where ID' in the following code to ensure it updates the current record?

Private Sub btnNew_Click()
AdHocData.Recordset.AddNew...

I have tried adding the subroutine and it works, except it always places the 'Duration' into a new record. So I have the record I was working on without and Duration info, then the next record it...

If I create a database that has 3 fileds per record; String1, String2 & ResultString. I want the user to enter in the first 2 strings then the program creates ‘ResultString’ by adding the String2 to...

Thank you for that. It make sense.

I am in the UK and it appears to return DD/MM/YYYY as a date string. So in my case I assume the DateDiff will expect to see something like '01/01/2008 23:00' for...

I am trying to write a program to store booking info for TV feeds. Most of the program is working fine, it stores all the info I need. One field is duration of feed which I am at the moment adding...