Recent content by Nishidh

So How to convert the format to JET 4.0 format?

Hi datAdrenaline, Once again thanks for reply. Yes, Access 97 is really NOT part of this situation ... I am dealing with VB6.0 and JET 4.0. Database is created only in Access 97. And access 97 is not installed on my PC. I am using JET OLEDB 4.0 to access the database. Both my Front End and...

Hi datAdrenaline, Thanks for the reply. Yes, you are correct. Database is created in MS Access 97 in some other machine. I do have MS Access 2003 installed on my PC. I am not directly accessing databse through MS Access. I am accessing database through VB 6.0 and JET OLEDB 4.0... and yes...

Hi datAdrenaline, Once again thanks for reply. Yes you are very true that if record is accessed by one user n access to the same record by another user will give error for concurrency, evenif we have record level locking enable. I want to make sure in code that recordset is opened in...

Hi Banana, I read one article in which it is written that Jet OLEDB 4.0 supports MS Access 97, is it true? Thanks, Nishidh

Hi datAdrenaline , Thanks for the reply. I am USING VB6 to interface with an MDB file created by Access 97 through JET OLEDB 4.0. I read one article in which its been mentioned that Jet OLEDB 4.0 is compatible with Access 97. Thanks for the reply. Nishidh

Hi banana, Thanks for the reply. My Access 97 database is shared by 2 application. Front end App and Data Entry App. Front End appl users use the database to view the data. Data Entry appl users enters the new data, change the data and delete the data from shared access 97 database. In...

Hi datAdrenaline, Thanks for the reply. I am USING VB6 to interface with an MDB file created by Access 97 through JET OLEDB 4.0. I read one article in which its been mentioned that Jet OLEDB 4.0 is compatible with Access 97. Thanks for the reply. Nishidh

Hi Keith, Thanks for the reply. I need to use Access 97 for the client requirement. I am using Visual Basic 6.0 for front End - GUI.

Hi Thanks for the quick reply. One MS Access 97 database is accessed by Front End and Data Entry applications. So in this case, how can we manage concurrent access to database at record level? so we can avoid unnecessary application crash? Thanks, Nishidh

Hi, I have MS Access 97 database. I need to use ADO to access database in VB 6.0 application through JET OLEDB 4.0. I want to know that whether MS Access 97 supports the Record level locking for above specification. If it supports, please let me know how to do it? Thank you very much in...

MS Access 97 properties set in tools>Options>advance tab are accessible by JET OLEDB? Hi, I am using MS Access 97 with VB 6.0. I am using JET OLEDB 4.0 to retrieve data from MS Access 97. I am using ADO to access the database. I have some of the properties set in MS Access for Locking...

How to set Record Level Locking - MS Access 97 VB 6.0 through JET OLEDB 4.0 Hi, I am accessing MS Access 97 using VB 6.0 with ADO object through JET OLEDB 4.0. I have 2 different applications. One for Data Entry to enter the data in MS Access Database. Another application is Front End to...