Front end of a database

M

mtrimpin24

I'm having trouble getting a database to update. its split into a front and
back end. When data is entered in the table on the back end though, it never
updates on the front end until the database is closed and reopened. even
when i query the table again by attaching it to the "before update" on the
search button, it doesn't show up by the next search.
 
D

Dennis

The other guys might have a different response, but when I want to force the
posting up DB updates, I use DBEngine RefreshCache (don't remember the exact
syntax; haven't coded that bit in over a year.) Look it up in Access HELP and
you'll be on your way...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 Runtime Cannot Open Database After A Table Is Created In It 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Access 2007 DB and VPN issues 3
Front End being locked 7
protect master copy of front end database 4
One front End - Multiple Backends 23
ms access with sql server 3
Connecting two back end Databases 24

Top