Hi guys,

I have 2 questions; I have found a lot of information about the problem of
access 2007 not recognizing access 2003 data base, I now I need to create a
trusted area, my question is I split the data base I have the forms, queries
and reports in the user’s PC, and the tables in the server, my first question
is do this; do I need to create this trusted area in the PC folder where I
have the application or in the server where I have the data, or in both?.

My second question; I split the database, I save a copy before the split, I
need to do some modifications to the system, what should I do, do I need to
do the modifications on the copy I save before the split and do the split
again, but I want to keep the same data base file the users are already
using, how can I connect the new application file on the PC’s to the old data
on the server.

I would really appreciate any help

Thanks

1. You need to create a trusted location to the Front-end, the one with the
forms, report,...

2. Typically once you split yor db, you would add all sort of extra
functionalities: automated table relinking, inactive user logoff,
administrative maintenance logoff,... And so if you were to make update to
your non-split version you'd have to redo this work everytime... So no, when
you make an update, you would do it in your split version of the db. If you
need to simply make changes to the front-end it is no big deal. You simply
make the changes and then 'push' the new version to your users. A great tool
for this is Tony Toew's Auto FE Updater available (for free, although
licensing is recommended and not expensive) at http://autofeupdater.com/

If you need to modify the back-end table then you must first boot everyone
off first. This is where having tools such as , inactive user logoff,
administrative maintenance logoff become crutial. Take a look at :

http://www.rogersaccesslibrary.com/forum/topic327.html
http://www.rogersaccesslibrary.com/forum/topic328.html

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Maracay" wrote:

> Hi guys,
>
> I have 2 questions; I have found a lot of information about the problem of
> access 2007 not recognizing access 2003 data base, I now I need to create a
> trusted area, my question is I split the data base I have the forms, queries
> and reports in the user’s PC, and the tables in the server, my first question
> is do this; do I need to create this trusted area in the PC folder where I
> have the application or in the server where I have the data, or in both?.
>
> My second question; I split the database, I save a copy before the split, I
> need to do some modifications to the system, what should I do, do I need to
> do the modifications on the copy I save before the split and do the split
> again, but I want to keep the same data base file the users are already
> using, how can I connect the new application file on the PC’s to the old data
> on the server.
>
> I would really appreciate any help
>
> Thanks
>

Hi Daniel,

Ok, I need to do the changes on the Splitted version, but what I dont like
is doing test on the real data base, there is a way to change the linked data
base for a test area data base while I am doing the changes, and after I am
done change the linked data base to the real data base and distribute this
version?

Thanks

"Daniel Pineault" wrote:

> 1. You need to create a trusted location to the Front-end, the one with the
> forms, report,...
>
> 2. Typically once you split yor db, you would add all sort of extra
> functionalities: automated table relinking, inactive user logoff,
> administrative maintenance logoff,... And so if you were to make update to
> your non-split version you'd have to redo this work everytime... So no, when
> you make an update, you would do it in your split version of the db. If you
> need to simply make changes to the front-end it is no big deal. You simply
> make the changes and then 'push' the new version to your users. A great tool
> for this is Tony Toew's Auto FE Updater available (for free, although
> licensing is recommended and not expensive) at http://autofeupdater.com/
>
> If you need to modify the back-end table then you must first boot everyone
> off first. This is where having tools such as , inactive user logoff,
> administrative maintenance logoff become crutial. Take a look at :
>
> http://www.rogersaccesslibrary.com/forum/topic327.html
> http://www.rogersaccesslibrary.com/forum/topic328.html
>
> --
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "Maracay" wrote:
>
> > Hi guys,
> >
> > I have 2 questions; I have found a lot of information about the problem of
> > access 2007 not recognizing access 2003 data base, I now I need to create a
> > trusted area, my question is I split the data base I have the forms, queries
> > and reports in the user’s PC, and the tables in the server, my first question
> > is do this; do I need to create this trusted area in the PC folder where I
> > have the application or in the server where I have the data, or in both?.
> >
> > My second question; I split the database, I save a copy before the split, I
> > need to do some modifications to the system, what should I do, do I need to
> > do the modifications on the copy I save before the split and do the split
> > again, but I want to keep the same data base file the users are already
> > using, how can I connect the new application file on the PC’s to the old data
> > on the server.
> >
> > I would really appreciate any help
> >
> > Thanks
> >

Simply use the Linked Table Manager to link your file to a temp back-end
version while you work and when you deploy your update your automated table
relink routine will automatically reconnect everything at run-time.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Maracay" wrote:

> Hi Daniel,
>
> Ok, I need to do the changes on the Splitted version, but what I dont like
> is doing test on the real data base, there is a way to change the linked data
> base for a test area data base while I am doing the changes, and after I am
> done change the linked data base to the real data base and distribute this
> version?
>
> Thanks
>
> "Daniel Pineault" wrote:
>
> > 1. You need to create a trusted location to the Front-end, the one with the
> > forms, report,...
> >
> > 2. Typically once you split yor db, you would add all sort of extra
> > functionalities: automated table relinking, inactive user logoff,
> > administrative maintenance logoff,... And so if you were to make update to
> > your non-split version you'd have to redo this work everytime... So no, when
> > you make an update, you would do it in your split version of the db. If you
> > need to simply make changes to the front-end it is no big deal. You simply
> > make the changes and then 'push' the new version to your users. A great tool
> > for this is Tony Toew's Auto FE Updater available (for free, although
> > licensing is recommended and not expensive) at http://autofeupdater.com/
> >
> > If you need to modify the back-end table then you must first boot everyone
> > off first. This is where having tools such as , inactive user logoff,
> > administrative maintenance logoff become crutial. Take a look at :
> >
> > http://www.rogersaccesslibrary.com/forum/topic327.html
> > http://www.rogersaccesslibrary.com/forum/topic328.html
> >
> > --
> > Hope this helps,
> >
> > Daniel Pineault
> > http://www.cardaconsultants.com/
> > For Access Tips and Examples: http://www.devhut.net
> > Please rate this post using the vote buttons if it was helpful.
> >
> >
> >
> > "Maracay" wrote:
> >
> > > Hi guys,
> > >
> > > I have 2 questions; I have found a lot of information about the problem of
> > > access 2007 not recognizing access 2003 data base, I now I need to create a
> > > trusted area, my question is I split the data base I have the forms, queries
> > > and reports in the user’s PC, and the tables in the server, my first question
> > > is do this; do I need to create this trusted area in the PC folder where I
> > > have the application or in the server where I have the data, or in both?.
> > >
> > > My second question; I split the database, I save a copy before the split, I
> > > need to do some modifications to the system, what should I do, do I need to
> > > do the modifications on the copy I save before the split and do the split
> > > again, but I want to keep the same data base file the users are already
> > > using, how can I connect the new application file on the PC’s to the old data
> > > on the server.
> > >
> > > I would really appreciate any help
> > >
> > > Thanks
> > >

Thanks

"Daniel Pineault" wrote:

> Simply use the Linked Table Manager to link your file to a temp back-end
> version while you work and when you deploy your update your automated table
> relink routine will automatically reconnect everything at run-time.
> --
> Hope this helps,
>
> Daniel Pineault
> http://www.cardaconsultants.com/
> For Access Tips and Examples: http://www.devhut.net
> Please rate this post using the vote buttons if it was helpful.
>
>
>
> "Maracay" wrote:
>
> > Hi Daniel,
> >
> > Ok, I need to do the changes on the Splitted version, but what I dont like
> > is doing test on the real data base, there is a way to change the linked data
> > base for a test area data base while I am doing the changes, and after I am
> > done change the linked data base to the real data base and distribute this
> > version?
> >
> > Thanks
> >
> > "Daniel Pineault" wrote:
> >
> > > 1. You need to create a trusted location to the Front-end, the one with the
> > > forms, report,...
> > >
> > > 2. Typically once you split yor db, you would add all sort of extra
> > > functionalities: automated table relinking, inactive user logoff,
> > > administrative maintenance logoff,... And so if you were to make update to
> > > your non-split version you'd have to redo this work everytime... So no, when
> > > you make an update, you would do it in your split version of the db. If you
> > > need to simply make changes to the front-end it is no big deal. You simply
> > > make the changes and then 'push' the new version to your users. A great tool
> > > for this is Tony Toew's Auto FE Updater available (for free, although
> > > licensing is recommended and not expensive) at http://autofeupdater.com/
> > >
> > > If you need to modify the back-end table then you must first boot everyone
> > > off first. This is where having tools such as , inactive user logoff,
> > > administrative maintenance logoff become crutial. Take a look at :
> > >
> > > http://www.rogersaccesslibrary.com/forum/topic327.html
> > > http://www.rogersaccesslibrary.com/forum/topic328.html
> > >
> > > --
> > > Hope this helps,
> > >
> > > Daniel Pineault
> > > http://www.cardaconsultants.com/
> > > For Access Tips and Examples: http://www.devhut.net
> > > Please rate this post using the vote buttons if it was helpful.
> > >
> > >
> > >
> > > "Maracay" wrote:
> > >
> > > > Hi guys,
> > > >
> > > > I have 2 questions; I have found a lot of information about the problem of
> > > > access 2007 not recognizing access 2003 data base, I now I need to create a
> > > > trusted area, my question is I split the data base I have the forms, queries
> > > > and reports in the user’s PC, and the tables in the server, my first question
> > > > is do this; do I need to create this trusted area in the PC folder where I
> > > > have the application or in the server where I have the data, or in both?.
> > > >
> > > > My second question; I split the database, I save a copy before the split, I
> > > > need to do some modifications to the system, what should I do, do I need to
> > > > do the modifications on the copy I save before the split and do the split
> > > > again, but I want to keep the same data base file the users are already
> > > > using, how can I connect the new application file on the PC’s to the old data
> > > > on the server.
> > > >
> > > > I would really appreciate any help
> > > >
> > > > Thanks
> > > >

Maracay <(E-Mail Removed)> wrote:

>I have 2 questions; I have found a lot of information about the problem of
>access 2007 not recognizing access 2003 data base, I now I need to create a
>trusted area, my question is I split the data base I have the forms, queries
>and reports in the user’s PC, and the tables in the server, my first question
>is do this; do I need to create this trusted area in the PC folder where I
>have the application or in the server where I have the data, or in both?.

Note that the Auto FE Updater can also automatically create the trusted locations for
you on the client PC. Once you've used the wizard to create your confifguration
file then update the configuration file and go to the Trusted Locations screen.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

Daniel Pineault <(E-Mail Removed)> wrote:

>Simply use the Linked Table Manager to link your file to a temp back-end
>version while you work and when you deploy your update your automated table
>relink routine will automatically reconnect everything at run-time.

Note that I also have the main menu in red for the programmers when
linked to live data. Just so the programmers have less chance of
making a mistake.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/