Access with Delphi

  • Thread starter Thread starter Bob Watson
  • Start date Start date
B

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
 
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
 
Yeah, the owner has a lot invested in
mdb. Have not been able to convince
them to change.

Thanks
 
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
Click to expand...

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.
 
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)
 
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
 
[email protected] said:
im just sick and tired of seeing access apps that crap out after 10
users
Click to expand...

Funny. One of my apps has 25 users and is working quite well.
and ACCESS DATA PROJECTS do a lot better than that
Click to expand...

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
 
Back
Top