Access with Delphi

[Bob Watson]

I have an Access 97 file and have created
a "front end" using Delphi (Borland) and
ADO components. The Delphi app, as well
as Access 97, are multi-user.

But, whenever I add information
with the Delphi App, I cannot see it with
Access until I close the file and open it
again. Is there some sort of refresh capability
within Access. I suppose there is a buffer
somewhere that needs refreshing.

Thanks for any help,
Bob Watson

 

[aaron.kempf]

uh me.requery or me.refresh

depends on what you're doing

 

[aaron.kempf]

im sorry i didn't read your post correctly.

i would reccomend looking for a refresh capacity in Delphi; not in MDB

ps - mdb is crap use sql server or msde

 

[Bob Watson]

Yeah, the owner has a lot invested in
mdb. Have not been able to convince
them to change.

Thanks

 

[Dirk Goldgar]

im sorry i didn't read your post correctly.

i would reccomend looking for a refresh capacity in Delphi; not in MDB

ps - mdb is crap use sql server or msde

Just a note to let the reader know that, despite Aaron Kempf's strident
partisanship of SQL Server, an awful lot of people think the MDB file
format is the best possible tool for its niche.

 

[david epsom dot com dot au]

There is a Jet cache: it caches both reads and
writes.

You can reduce the size of the cache, reduce
the write-back interval, use transactions
(which by default write through) or set
implicit transactions synchronous. Look at

application.dbengine.setoption


(david)

 

[aaron.kempf]

Dirk

I'm sorry that you're an MDB wimp also-- ADP rock MDBs' world

any day of the week-- easier development; more stable / reliable
solutions

im just sick and tired of seeing access apps that crap out after 10
users
and ACCESS DATA PROJECTS do a lot better than that

 

[Tony Toews]

im just sick and tired of seeing access apps that crap out after 10
users

Funny. One of my apps has 25 users and is working quite well.

and ACCESS DATA PROJECTS do a lot better than that

Sure. But as has been pointed out elsewhere ADPs have their quirks
too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm