cannot write record into Access97

[Eric]

Hi everyone, I created my Access XP database and coverted
it to Access 97. It works fine in my development site,
which is Window XP OS. But, it is not working on other
PC, either on Window 2000 or Window XP. I am using MS Jet
3.5.1 and didn't set any password on my database. Did I
miss something...?? Please help me, thanks

 

[Bruce M. Thompson]

Hi everyone, I created my Access XP database and coverted

it to Access 97. It works fine in my development site,
which is Window XP OS. But, it is not working on other
PC, either on Window 2000 or Window XP. I am using MS Jet
3.5.1 and didn't set any password on my database. Did I
miss something...?? Please help me, thanks

First question: Is it possible that you included, in your application, some
features that don't exist in Access 97? Although it converted, if the file
contains any such features it is likely that it will not run or, at least, not
run properly.

Second question: Is this a split application? If so, did you convert both the
front-end *and* the back-end?

Third question (and this may sound silly): Is Access installed on the other
computers?

 

[Eric]

Thanks Bruce,
Sorry that I didn't mention clearly about my problem.

I'm using VB to create an application and connect to
that database at the same time. I connected to database
manually, withoud using a DSN.
I had successfully installed my developed application,
and still can see the previous record which contain
inside the database. The problem is I cannot store a new
record into it. Here is my setting in VB:

Set dbCnn = New ADODB.Connection
dbCnn.Provider = "Microsoft.Jet.OLEDB.3.51"

dbCnn.Mode = adModeReadWrite
dbCnn.Open DB_FileName

Thanks...

 

[Bruce M. Thompson]

Thanks Bruce,

Sorry that I didn't mention clearly about my problem.

I'm using VB to create an application and connect to
that database at the same time. I connected to database
manually, withoud using a DSN.
I had successfully installed my developed application,
and still can see the previous record which contain
inside the database. The problem is I cannot store a new
record into it. Here is my setting in VB:

Set dbCnn = New ADODB.Connection
dbCnn.Provider = "Microsoft.Jet.OLEDB.3.51"

dbCnn.Mode = adModeReadWrite
dbCnn.Open DB_FileName

I see (I meant to ask if you were using VB or something similar). I am not
really very familiar with ADO - I always use DAO when connecting via JET, so I
don't feel qualified to answer your question. There may also be issues here that
are specifically VB related, so you may want to post your question to one of the
VB newsgroups, such as:

microsoft.public.vb.database
.... or ...
microsoft.public.vb database.ado

 

[Eric]

Thanks for your help....

-----Original Message-----

I see (I meant to ask if you were using VB or something similar). I am not
really very familiar with ADO - I always use DAO when connecting via JET, so I
don't feel qualified to answer your question. There may also be issues here that
are specifically VB related, so you may want to post your question to one of the
VB newsgroups, such as:

microsoft.public.vb.database
.... or ...
microsoft.public.vb database.ado

--
Bruce M. Thompson, Microsoft Access MVP
(e-mail address removed) (See the Access FAQ at http://www.mvps.org/access)
within the newsgroups so that all might benefit.<<


.