3027 (read only database) doing an Execute Insert

Hi,

Thank you for posting in the community! My name is Kevin, and I will be
assisting you on this issue.

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you have some problem when inserting
records from a text from using text file driver. The problem only appears
on Win2K machines. If there is any misunderstanding, please feel free to
let me know.

I cannot tell why this happens because lack of information. I need to know
more about the system you're working on. Would you please help me collect
some information about what database are you working on? What is the
version of DAO? If an error occurs, what is the error message displayed on
screen? Thanks for your cooperation, if I have these information, it might
be much more quickly for me to work out a solution for you.

As far as I know, the privilege table is something in MySQL database. Are
you working on a MySQL database? Here is a link I found in MySQL official
website which explains privilege table.

http://www.mysql.com/articles/mysql_intro.html#SECTION0002000000

If anything is unclear, please feel free to reply to the post. I'm standing
by to be of assistance.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

Kevin,

It only happens on some Win2K machines. On others the same program works
fine.

The database is a Jet database not an SQL database. The version of DAO is
3.51.

The error number is 3027. The message is:
"Can't update. Database or object is read-only."

As I said, the program has already inserted a record into a table of the
database, and the tables have been built.

Thanks,

Wally

"Kevin Yu [MSFT]" <v-kevy RemoveThis @online.microsoft.com> wrote in message
news:GV9Q1fX5DHA.1988@cpmsftngxa07.phx.gbl...
 > Hi,
 >
 > Thank you for posting in the community! My name is Kevin, and I will be
 > assisting you on this issue.
 >
 > First of all, I would like to confirm my understanding of your issue. From
 > your description, I understand that you have some problem when inserting
 > records from a text from using text file driver. The problem only appears
 > on Win2K machines. If there is any misunderstanding, please feel free to
 > let me know.
 >
 > I cannot tell why this happens because lack of information. I need to know
 > more about the system you're working on. Would you please help me collect
 > some information about what database are you working on? What is the
 > version of DAO? If an error occurs, what is the error message displayed on
 > screen? Thanks for your cooperation, if I have these information, it might
 > be much more quickly for me to work out a solution for you.
 >
 > As far as I know, the privilege table is something in MySQL database. Are
 > you working on a MySQL database? Here is a link I found in MySQL official
 > website which explains privilege table.
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://www.mysql.com/articles/mysql_intro.html#SECTION0002000000</font" target="_blank">http://www.mysql.com/articles/mysql_intro.html#SECTION0002000000</font</a>>
 >
 > If anything is unclear, please feel free to reply to the post. I'm
standing
 > by to be of assistance.
 >
 > Kevin Yu
 > =======
 > "This posting is provided "AS IS" with no warranties, and confers no
 > rights."
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

Hi Wally,

I've checked this and found that this is a know issue in Jet Engine 3.51.
It has been fixed in Jet 4.0. Would you please try to use Jet 4.0 to see if
it can resolved the problem? Please reference the DAO 3.6 library. It works
with Jet 4.0 while DAO 3.5 works with Jet 3.51.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

I have both msjet3.5 and 4.0 installed. How do I specify which text driver
I wish to use. I appear to be still using the 3.5 text driver.

Here is my database open statement. dbroot is the path the folder
containing the text files that are my tables.

Set gImpDB = WsObj.OpenDatabase(dbRoot, 0, False, "Text;CacheSize=500;")

Thanks
"Kevin Yu [MSFT]" <v-kevy.TakeThisOut@online.microsoft.com> wrote in message
news:CBq2t7l5DHA.1992@cpmsftngxa07.phx.gbl...
 > Hi Wally,
 >
 > I've checked this and found that this is a know issue in Jet Engine 3.51.
 > It has been fixed in Jet 4.0. Would you please try to use Jet 4.0 to see
if
 > it can resolved the problem? Please reference the DAO 3.6 library. It
works
 > with Jet 4.0 while DAO 3.5 works with Jet 3.51.
 >
 > Kevin Yu
 > =======
 > "This posting is provided "AS IS" with no warranties, and confers no
 > rights."
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

You can't specify just the text driver

You need to change you project references to DAO 4 and uncheck the DAO
3.5/3.51 box. You can't reference both in the one project.


Matt


<waldyn.benbenek.DeleteThis@unisys.com> wrote in message
news:Oi2Yafo5DHA.2064@TK2MSFTNGP11.phx.gbl...
 > I have both msjet3.5 and 4.0 installed. How do I specify which text
driver
 > I wish to use. I appear to be still using the 3.5 text driver.
 >
 > Here is my database open statement. dbroot is the path the folder
 > containing the text files that are my tables.
 >
 > Set gImpDB = WsObj.OpenDatabase(dbRoot, 0, False,
"Text;CacheSize=500;")
 >
 > Thanks
 > "Kevin Yu [MSFT]" <v-kevy.DeleteThis@online.microsoft.com> wrote in message
 > news:CBq2t7l5DHA.1992@cpmsftngxa07.phx.gbl...
  > > Hi Wally,
  > >
  > > I've checked this and found that this is a know issue in Jet Engine
3.51.
  > > It has been fixed in Jet 4.0. Would you please try to use Jet 4.0 to see
 > if
  > > it can resolved the problem? Please reference the DAO 3.6 library. It
 > works
  > > with Jet 4.0 while DAO 3.5 works with Jet 3.51.
  > >
  > > Kevin Yu
  > > =======
  > > "This posting is provided "AS IS" with no warranties, and confers no
  > > rights."
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

Hi waldyn,

As Matt said in his post, we have to reference DAO 3.6 library. Here are
the steps in VB6:

1. Select Project / References from the menu.
2. Uncheck Microsoft DAO 3.51 Object Library.
3. Check Microsoft DAO 3.6 Object Library. (DAO 3.6 works with Jet 4.0)
4. Click OK button.

Thus we changed our reference from DAO 3.51 to DAO 3.6. (3.6 is the latest
version of DAO currently.)

If the problem still peresists, please feel free to let me know. I am
standing by to be of assistance.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

I made those changes (referencing DAO 3.6) at the beginning and it did not
fix the problem.

For one thing, I believe it is still referencing Jet 3.5. Changes made to
the Text registry entry in Jet 3.5 are picked up and those made in the Jet
4.0 entry are not read.

The problem is the extention restriction that was introduced in 3.51 (KB
239105). Has this restriction indeed been lifted in Jet 4.0? The registry
entry for Disabled extensions still exists in Jet 4.0.

Furthermore the 3.51 code cannot read this entry well. I tried adding
extensions to the list and it blew up VB in design mode. It just stopped.

Thanks

"Kevin Yu [MSFT]" <v-kevy.DeleteThis@online.microsoft.com> wrote in message
news:MfLzJpw5DHA.3496@cpmsftngxa07.phx.gbl...
> Hi waldyn,
>
> As Matt said in his post, we have to reference DAO 3.6 library. Here are
> the steps in VB6:
>
> 1. Select Project / References from the menu.
> 2. Uncheck Microsoft DAO 3.51 Object Library.
> 3. Check Microsoft DAO 3.6 Object Library. (DAO 3.6 works with Jet 4.0)
> 4. Click OK button.
>
> Thus we changed our reference from DAO 3.51 to DAO 3.6. (3.6 is the latest
> version of DAO currently.)
>
> If the problem still peresists, please feel free to let me know. I am
> standing by to be of assistance.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

If I reference DAO 3.0, change the extensions, and create the new database
(the one into which I am inserting the records from the text file), I can
create the database. The key was changing the extensions. I am looking for
a solution that does not involve changeing to acceptable list of extesions.

Furthermore the database is a strange hybrid. It cannot be read by code
exptecting DAO 3.5, but it is not a Jet 4.0 database. Access 2000 claims it
is an old format database and can only open it in read-only mode.

Thanks for your help.

"Kevin Yu [MSFT]" <v-kevy RemoveThis @online.microsoft.com> wrote in message
news:MfLzJpw5DHA.3496@cpmsftngxa07.phx.gbl...
> Hi waldyn,
>
> As Matt said in his post, we have to reference DAO 3.6 library. Here are
> the steps in VB6:
>
> 1. Select Project / References from the menu.
> 2. Uncheck Microsoft DAO 3.51 Object Library.
> 3. Check Microsoft DAO 3.6 Object Library. (DAO 3.6 works with Jet 4.0)
> 4. Click OK button.
>
> Thus we changed our reference from DAO 3.51 to DAO 3.6. (3.6 is the latest
> version of DAO currently.)
>
> If the problem still peresists, please feel free to let me know. I am
> standing by to be of assistance.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
 >> Stay informed about: 3027 (read only database) doing an Execute Insert 

Hi Waldyn,

Since changing reference to DAO 3.6 cannot resolve the problem, it seems
that the problem is quite complex. We need to do some further
troubleshooting.

Based on my research, this problem can be caused by many reasons. Here I
listed some of them:

1. Please install the latest service pack for both Jet 4.0 and Jet 3.51.
You can download them from the following links:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7e82ef88-52ec-4a8f-
8bb2-8b06d6cb668d&DisplayLang=en

http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e-48b0-
b8d7-1781befde1f8&DisplayLang=en

After installing, please try to check KB 239105 again to see if this works.

http://support.microsoft.com/default.aspx?scid=kb;en-us;239105

2. The problem might have something to do with the length of the path and
file name that you're trying to import from. The length of path + filename
is greater than 64 characters. Please try to shorten the path and file name
to be less than 64 characters in total.


If the problem still persists, could you send me a package of code that
could repro the error? Please also let me know under what circumstances the
problem might occur. Remove "online" from the no spam email shown above is
my real email address.

Thank you for your cooperation. If there is anything unclear, please feel
free to let me know.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 >> Stay informed about: 3027 (read only database) doing an Execute Insert