BDE Problems with Access Files - Always opening them as Read Only.

[Robert Duchene]

I know I'm probably an idiot but I can't seem to figure out how to open an
Access table with BDE and have it NOT open Read Only.

I have a BDE Alias set to READ/WRITE called MyTable set to MSACCESS type
pointing to my table.

If I put a TTable and TDataSource on a form and link them. Set TTable to:

READONLY=FALSE
DATABASENAME=MyTable
EXCLUSIVE=False
READONLY=False
TABLENAME=Jobs

When I Activate the TTABLE object is forces my Access table into Read Only.

I have read the manual and found that there are certain things that need to
be set for a table to be opened for writing, however ONLY my Access tables
will not write. All other 'native' types are fine.

Any help would be greatly appreciated as I am stuck writing an appliction
until this gets resolved.

Robert Duchene
rduc...@compufax.com

[Bill Todd (TeamB)]

What BDE version are you using? What type of Access table (97, 2k)? Is the
Access database on your local hard drive? If it is on a file server do you
have write access on the server?

--
Bill Todd (TeamB)
(Questions received via email cannot be answered.)

[Robert Duchene]

Bill,

Access 97 is the database and it is on my local hard drive.

When I open the table in Access it is fine. If I close the table, open
it in Delphi with and go to Access, I am told by Access that the file is
in read only mode. If I close the file in Delphi, Access can write.
This happens to ALL Access files with Delphi. Any suggestions?

Bill Todd (TeamB) <bi...@dbginc.com> wrote in message
news:8eku20$99...@bornews.borland.com...

[Bill Todd (TeamB)]

Is the TTable.Exclusive property set to True in your Delphi app or are you
placing any explicity table locks? Those are the only possibilities I can
think of.

[Robert Duchene]

Bill,

Thanks for your help but nothing seems to work with this matter. If I
create a form and place all of the proper objects on it I can update, add,
etc. to my tables.

However I am trying to write a service and there is no Borland Documentation
that tells me why I am getting this error.

Are there any samples of Delphi code that show how to create a TTable, Open
a TTable, Edit a TTable and store a TTable ONLY through code for apps like a
service?

Although the book does say that there are certain options for writing to a
TTable, when I choose these options it is still in read only.

Thanks,
Robert

Bill Todd (TeamB) <bi...@dbginc.com> wrote in message

news:8evga1$jb...@bornews.borland.com...

[Bill Todd (TeamB)]

I certainly do not have any problem editing an Access 97 table with a Delphi
app using the BDE native driver and with Access at the same time. For sample
code, look at the Developer's guide and the sameple applications that come
with Delphi. A simple example is:

with Table1 do
begin
Open;
Edit;
FieldByName('SomeField').AsString := 'abc';
Post;
end;