Re: A little help with access forms.
From: Albert D. Kallal (PleaseNOOOsPAMMkallal_at_msn.com)
Date: 09/22/04
- Next message: jez123456: "switch between xp and 2003"
- Previous message: JC: "Re: Importing Shortcut Menus and ImportSpecs from older version of"
- In reply to: Terry: "Re: A little help with access forms."
- Next in thread: Terry: "Re: A little help with access forms."
- Reply: Terry: "Re: A little help with access forms."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 17:36:25 -0600
"Terry" <ttrapp.spam.me.not@org.insurors> wrote in message
news:LXf4d.230$Xy5.203@fe61.usenetserver.com...
> Well, that is the thing. The refresh method does not display the data that
> is actually in the database.
The refresh method will not show new records that you add, but it will show
changes to existing records (at least it should).
You of course do expose and have timestamp fields on any of those linked
tables..right? (both m-access, and sql-server use time stamp fields to
figure out when to update things, and also when things where updated. You
want to always expose these timestamp fields to ms-access).
> Only if I exit and reopen mdb file, or use the
> Reload method
Ah, I think you mean .requery method here..right?
> information. The problem I am running into now is that it's simply too
> slow
> moving back to the correct record after a reload.
Likely, you have a form with lots of records loaded..and you should not. I
would fix your design to not have so many records loaded, or as mentioned
get the "refresh" method working here.
> It
> appears that you can't use views in an mdb file :(
I use views all the time to sql server. In fact, for reports, and especially
any query that tries to join multiple tables..that should be placed on the
server, make into a view, and then you link to that view from ms-access.
There is NO reason to try and make a join on the client side, that stuff
should be done serve side. Remember, since your database engine is now sql
server, then likely don't have any problems of performance with such a
powerful database engine at your service. Since you are using sql server,
then using c++, VB, or ms-access on the client side will make NO difference
in terms of performance here.
-- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com http://www.attcanada.net/~kallal.msn
- Next message: jez123456: "switch between xp and 2003"
- Previous message: JC: "Re: Importing Shortcut Menus and ImportSpecs from older version of"
- In reply to: Terry: "Re: A little help with access forms."
- Next in thread: Terry: "Re: A little help with access forms."
- Reply: Terry: "Re: A little help with access forms."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
