WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Splitting and networking database

 
Goto page Previous  1, 2
   Home -> Office other -> Table Design RSS
Next:  Reports and E-mails Pt.2  
Author Message
sweeneysmsm

External


Since: Oct 08, 2006
Posts: 42



(Msg. 9) Posted: Wed Oct 01, 2008 7:25 pm
Post subject: Re: Splitting and networking database [Login to view extended thread Info.]
Archived from groups: microsoft>public>access>tablesdbdesign (more info?)

Hi, Armen.

Thanks so much for the relinker. It worked like a charm. I just have one
more question. I feel a bit like Columbo who says 'There was just this one
other matter..."

I split the database and made the install package with the developer
extensions. I do encounter one problem and I just want to know if that is
part of the runtime version of Access. When a user is am using the front end
with the runtime version of Access. and a linked back-end, they seem to have
no filtering options. They can't click into a field which displays data they
are looking for , eg, the name of a State, and then right click and choose
filter by selection. There seem to be no filtering options available in the
runtime version of Access. Is this true? (I'm also going to post this as a
separate question in the event that having said my question was answered, you
no longer get messages as to new comments on the thread. Thank you again for
your help.

Mary

"Armen Stein" wrote:

> On Wed, 24 Sep 2008 09:34:08 -0700, sweeneysmsm
> <sweeneysmsm.DeleteThis@discussions.microsoft.com> wrote:
>
> >Regarding the relinking code:
>
> Hi Mary,
>
> I don't have that book in front of me, but it seems that both
> ztblVersionTable and modStartup are part of the relinking code used in
> the examples. You would need to bring in any necessary pieces. One
> issue is that by its name, I assume that the table does some version
> checking too, which you may not want or need.
>
> You might want to use a more "standalone" relinker utility. Your post
> prompted me to do something I've been thinking about for a long time -
> make our relinker available. It's at:
> http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
>
> The file is J Street Access Relinker.
>
> This should work fine for you, and doesn't need any of its own tables.
> If you want to try it, just follow the instructions in the Read Me
> table.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
>
Back to top
Login to vote
Armen Stein

External


Since: Aug 05, 2006
Posts: 225



(Msg. 10) Posted: Thu Oct 02, 2008 7:07 am
Post subject: Re: Splitting and networking database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Wed, 1 Oct 2008 19:25:01 -0700, sweeneysmsm
<sweeneysmsm.DeleteThis@discussions.microsoft.com> wrote:

>When a user is am using the front end
>with the runtime version of Access. and a linked back-end, they seem to have
>no filtering options. They can't click into a field which displays data they
>are looking for , eg, the name of a State, and then right click and choose
>filter by selection.

Hi Mary,

This may have been answered in your other thread, but it sounds like
you have Shortcut Menus (the official name for Right-Click Menus)
turned off in your Startup Options. The runtime doesn't prevent them
from working.

So glad the relinker worked well for you.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
Back to top
Login to vote
sweeneysmsm

External


Since: Oct 08, 2006
Posts: 42



(Msg. 11) Posted: Fri Oct 03, 2008 5:42 am
Post subject: Re: Splitting and networking database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you so much. I will try and research how to adjust the Startup Options
in the Runtime version. Somebody should write a small book on the runtime
edition. It would be a great help!

Thank you so much.

Mary

"Armen Stein" wrote:

> On Wed, 1 Oct 2008 19:25:01 -0700, sweeneysmsm
> <sweeneysmsm RemoveThis @discussions.microsoft.com> wrote:
>
> >When a user is am using the front end
> >with the runtime version of Access. and a linked back-end, they seem to have
> >no filtering options. They can't click into a field which displays data they
> >are looking for , eg, the name of a State, and then right click and choose
> >filter by selection.
>
> Hi Mary,
>
> This may have been answered in your other thread, but it sounds like
> you have Shortcut Menus (the official name for Right-Click Menus)
> turned off in your Startup Options. The runtime doesn't prevent them
> from working.
>
> So glad the relinker worked well for you.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
>
Back to top
Login to vote
Armen Stein

External


Since: Aug 05, 2006
Posts: 225



(Msg. 12) Posted: Fri Oct 03, 2008 8:33 am
Post subject: Re: Splitting and networking database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Fri, 3 Oct 2008 05:42:01 -0700, sweeneysmsm
<sweeneysmsm DeleteThis @discussions.microsoft.com> wrote:

>I will try and research how to adjust the Startup Options
>in the Runtime version.

You can just set the Startup Options in the MDB, then create the MDE
and distribute it. The MDE will retain those options.

We usually don't bother to change the Startup Options in the MDE. We
set them in the MDB and then bypass them during development using the
Shift key on launch.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
Back to top
Login to vote
sweeneysmsm

External


Since: Oct 08, 2006
Posts: 42



(Msg. 13) Posted: Sat Oct 04, 2008 6:50 am
Post subject: Re: Splitting and networking database [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you! This has been so very helpful.

Mary

"Armen Stein" wrote:

> On Fri, 3 Oct 2008 05:42:01 -0700, sweeneysmsm
> <sweeneysmsm.DeleteThis@discussions.microsoft.com> wrote:
>
> >I will try and research how to adjust the Startup Options
> >in the Runtime version.
>
> You can just set the Startup Options in the MDB, then create the MDE
> and distribute it. The MDE will retain those options.
>
> We usually don't bother to change the Startup Options in the MDE. We
> set them in the MDB and then bypass them during development using the
> Shift key on launch.
>
> Armen Stein
> Microsoft Access MVP
> www.JStreetTech.com
>
>
Back to top
Login to vote
Display posts from previous:   
       Home -> Office other -> Table Design All times are: Eastern Time (US & Canada) (change)
Goto page Previous  1, 2
Page 2 of 2

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
 Office
  Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET