[OT] Changing filename to linked file in Access

Yahoo Archive
1
Brian,
I'm using Access 2000. They must have moved it to the other menu somewhere along the way.

Thanks for your help.

Troy

----- Original Message -----
From: Brian Stenglein <bstenglein@...>
To: vantage@yahoogroups.com
Sent: Tuesday, December 17, 2002 8:06 AM
Subject: [Vantage] Re: [OT] Changing filename to linked file in Access


Sorry Troy,

We must be using different versions of Access. We're still using 97.

Brian

--- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> Brian,
> When I go to Tools -> Add-ins, all I see is "Add-Ins Manager"
and "Crystal Report Wizard". How do I add the Linked Table manager
to the Add-ins?
>
> (and for that matter, why does the "Crystal Report Wizard" ask me
for a database password?)
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Brian Stenglein <bstenglein@c...>
> To: vantage@yahoogroups.com
> Sent: Monday, December 16, 2002 8:54 AM
> Subject: [Vantage] Re: [OT] Changing filename to linked file in
Access
>
>
> Troy,
>
> Have you tried using the Linked Table manager in Access? It's
still
> kind of a hassle, but probably not as bad as what you're facing
now.
> You'll find it under Tools -> Add-ins. It will allow you to keep
the
> same table in Access and point it to an new Excel file/Location.
>
> Hope that helps.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> > I LINK Excel files in Access for use in Crystal reports. If I
> change the name or location of the Excel file, I have to recreate
the
> links in Access, along with the Queries as well. Is there way to
> change the name and/or location of a Linked file with out
relinking
> it (and the Queries?). It kind of a hastle when testing various
> options.
> >
> > Troy Funte
> > Liberty Electronics
> >
> >
> > [Non-text portions of this message have been removed]
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
2
I LINK Excel files in Access for use in Crystal reports. If I change the name or location of the Excel file, I have to recreate the links in Access, along with the Queries as well. Is there way to change the name and/or location of a Linked file with out relinking it (and the Queries?). It kind of a hastle when testing various options.

Troy Funte
Liberty Electronics


[Non-text portions of this message have been removed]
3
Troy,

If you wish to maintain the same links and queries while still being
able to change the underlying Excel data, you must be sure to maintain
the same filename, pathname and file structure for the Excel files.
In other words, your columns and cell content formats must remain
the same. You can create empty Excel files with the needed formatting
and leave them in the folder as placeholders for Access.

Sometimes even then Access while turn up its nose at the data if it has
been refreshed, and you will have to relink. If you're not afraid of
a little VBA, here's something that will get you started:

http://www.mvps.org/access/tables/tbl0009.htm


have fun,
john



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, December 14, 2002 2:27 PM
To: Vantage
Subject: [Vantage] [OT] Changing filename to linked file in Access
4
I just wish there was somewhere in the access that stored the filename of the linked excel file, and then you could go in and just change the filename and path instead of re-linking, etc.

The VB code you mentioned looks interesting for some other scenarios, however.

Troy Funte
Liberty Electronics


----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Saturday, December 14, 2002 5:47 PM
Subject: RE: [Vantage] [OT] Changing filename to linked file in Access


Troy,

If you wish to maintain the same links and queries while still being
able to change the underlying Excel data, you must be sure to maintain
the same filename, pathname and file structure for the Excel files.
In other words, your columns and cell content formats must remain
the same. You can create empty Excel files with the needed formatting
and leave them in the folder as placeholders for Access.

Sometimes even then Access while turn up its nose at the data if it has
been refreshed, and you will have to relink. If you're not afraid of
a little VBA, here's something that will get you started:

http://www.mvps.org/access/tables/tbl0009.htm


have fun,
john



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, December 14, 2002 2:27 PM
To: Vantage
Subject: [Vantage] [OT] Changing filename to linked file in Access


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
5
Troy,

You can show the hidden tables, which do contain the linking info,
but they are not editable.

have fun,
john



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, December 14, 2002 3:37 PM
To: vantage@yahoogroups.com
6
John,
Where do you find those?

Troy

----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Saturday, December 14, 2002 8:22 PM
Subject: RE: [Vantage] [OT] Changing filename to linked file in Access


Troy,

You can show the hidden tables, which do contain the linking info,
but they are not editable.

have fun,
john



-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, December 14, 2002 3:37 PM
To: vantage@yahoogroups.com

















Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
7
Tools -> Options -> View

Check "Hidden Objects" and "System Objects"




-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, December 14, 2002 5:28 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] [OT] Changing filename to linked file in Access
8
Troy,

Have you tried using the Linked Table manager in Access? It's still
kind of a hassle, but probably not as bad as what you're facing now.
You'll find it under Tools -> Add-ins. It will allow you to keep the
same table in Access and point it to an new Excel file/Location.

Hope that helps.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> I LINK Excel files in Access for use in Crystal reports. If I
change the name or location of the Excel file, I have to recreate the
links in Access, along with the Queries as well. Is there way to
change the name and/or location of a Linked file with out relinking
it (and the Queries?). It kind of a hastle when testing various
options.
>
> Troy Funte
> Liberty Electronics
>
>
> [Non-text portions of this message have been removed]
9
You can do this with VBA Code. There is a code example on Microsoft's
website. I also believe I seen it as part of the northwinds database (In
Modules). If I remember correctly, it checks to see that a linked database
is still present in the same location, if not then it prompt for a new
database location to update the MSObjests table.
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Saturday, December 14, 2002 5:27 PM
To: Vantage
Subject: [Vantage] [OT] Changing filename to linked file in Access


I LINK Excel files in Access for use in Crystal reports. If I change the
name or location of the Excel file, I have to recreate the links in Access,
along with the Queries as well. Is there way to change the name and/or
location of a Linked file with out relinking it (and the Queries?). It kind
of a hastle when testing various options.

Troy Funte
Liberty Electronics


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
10
Brian,
When I go to Tools -> Add-ins, all I see is "Add-Ins Manager" and "Crystal Report Wizard". How do I add the Linked Table manager to the Add-ins?

(and for that matter, why does the "Crystal Report Wizard" ask me for a database password?)

Troy Funte
Liberty Electronics

----- Original Message -----
From: Brian Stenglein <bstenglein@...>
To: vantage@yahoogroups.com
Sent: Monday, December 16, 2002 8:54 AM
Subject: [Vantage] Re: [OT] Changing filename to linked file in Access


Troy,

Have you tried using the Linked Table manager in Access? It's still
kind of a hassle, but probably not as bad as what you're facing now.
You'll find it under Tools -> Add-ins. It will allow you to keep the
same table in Access and point it to an new Excel file/Location.

Hope that helps.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> I LINK Excel files in Access for use in Crystal reports. If I
change the name or location of the Excel file, I have to recreate the
links in Access, along with the Queries as well. Is there way to
change the name and/or location of a Linked file with out relinking
it (and the Queries?). It kind of a hastle when testing various
options.
>
> Troy Funte
> Liberty Electronics
>
>
> [Non-text portions of this message have been removed]


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
11
Troy,

Tools -> Database Utilities -> Linked Table Manager.

It is still tedious <g>.



have fun,
john





-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 16, 2002 6:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: [OT] Changing filename to linked file in
Access
12
OK. That's more like it. At least I can move a file and repoint without having to change the query.

Thanks.

Troy Funte
Liberty Electronics

----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Monday, December 16, 2002 11:25 PM
Subject: RE: [Vantage] Re: [OT] Changing filename to linked file in Access


Troy,

Tools -> Database Utilities -> Linked Table Manager.

It is still tedious <g>.



have fun,
john





-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 16, 2002 6:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: [OT] Changing filename to linked file in
Access



















Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
13
Microsoft Knowledge Base Article - 209730
ACC2000: How to Remove Linked ( Attached) Tables Using a Macro
The information in this article applies to:
Microsoft Access 2000

This article was previously published under Q209730
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a
Microsoft Access project (.adp).


SUMMARY
The TransferDatabase action is the macro equivalent of the Link Tables
command. However, Microsoft Access does not have an action to delete a link
to a linked (attached) table. To remove a linked table from the Database
window, select the table in the Database window, and then press the DELETE
key. You can also create a macro to delete a link to a linked table, or you
can call the action from Visual Basic code by using the DoCmd statement or
the RunMacro method.
MORE INFORMATIONTo delete a link to a linked table, create the following
macro, and then save it as RemoveTable:

Action: DeleteObject
Object Type: Table
Object Name: MyTable

Use a DoCmd statement or the RunMacro method to run the RemoveTable macro as
follows:
DoCmd.RunMacro "RemoveTable"

Last Reviewed: 8/6/2002
Keywords: kbhowto kbinterop kbusage KB209730


Hope this helps
Jeremy Leonard
IT Manager
K-T Corporation

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 16, 2002 11:43 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: [OT] Changing filename to linked file in
Access


OK. That's more like it. At least I can move a file and repoint without
having to change the query.

Thanks.

Troy Funte
Liberty Electronics

----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Monday, December 16, 2002 11:25 PM
Subject: RE: [Vantage] Re: [OT] Changing filename to linked file in Access


Troy,

Tools -> Database Utilities -> Linked Table Manager.

It is still tedious <g>.



have fun,
john





-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 16, 2002 6:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: [OT] Changing filename to linked file in
Access



















Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
14
Found this one too. It illustrates linking a table with VB Code.
Hope it helps.
Jeremy Leonard
IT Manager
K-T Corporation


ACC2000:
How to Use the Seek Method on Linked Tables
The information in this article applies to:
Microsoft Access 2000

This article was previously published under Q210266
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.mdb).


SUMMARY
Although you cannot use the Seek method directly on a linked (attached)
Microsoft Access table, by using Visual Basic for Applications, you can
create a workaround. This article demonstrates a sample user-defined Sub
procedure that you can use to link a Microsoft Access table and describes
how to use the Seek method to locate specified records.

MORE INFORMATION
Microsoft provides programming examples for illustration only, without
warranty either expressed or implied, including, but not limited to, the
implied warranties of merchantability and/or fitness for a particular
purpose. This article assumes that you are familiar with the programming
language being demonstrated and the tools used to create and debug
procedures. Microsoft support professionals can help explain the
functionality of a particular procedure, but they will not modify these
examples to provide added functionality or construct procedures to meet your
specific needs. If you have limited programming experience, you may want to
contact a Microsoft Certified Partner or the Microsoft fee-based consulting
line at (800) 936-5200. For more information about Microsoft Certified
Partners, please visit the following Microsoft Web site:

http://www.microsoft.com/partner/referral/

For more information about the support options that are available and about
how to contact Microsoft, visit the following Microsoft Web site:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

NOTE: The sample code in this article uses Microsoft Data Access Objects.
For this code to run properly, you must reference the Microsoft DAO 3.6
Object Library. To do so, click References on the Tools menu in the Visual
Basic Editor, and make sure that the Microsoft DAO 3.6 Object Library check
box is selected.

To use the Seek method on a linked table from the sample database
Northwind.mdb, follow these steps:


Create a new database and name it Db1.mdb.
On the File menu, click Get External Data, and then click Link Tables.
Select the Northwind.mdb file, and then click Link.
In the Link Tables dialog box, select Orders, and then click OK.
Create a module, and then type the following line in the Declarations
section if the line is not already there:

Option Explicit


Type or paste the following procedure:NOTE: In the following sample code, an
underscore (_) at the end of a line is used as a line-continuation
character.
Sub Seek_Attached_Table(Tablename, Indexname, SearchValue)
Dim db As Database
Dim t As TableDef
Dim rs As DAO.Recordset
Dim dbpath, SourceTable

On Error GoTo SA_Errors

Set db = DBEngine(0)(0)
dbpath = Mid(db(Tablename).connect, InStr(1, _
db(Tablename).connect, "=") + 1)
If dbpath = "" Then MsgBox "You've chosen a table already in the current
database", 64, "": Exit Sub

SourceTable = db(Tablename).sourcetablename

Set db = DBEngine(0).OpenDatabase(dbpath)
Set rs = db.OpenRecordset(SourceTable, DB_OPEN_TABLE)
rs.Index = Indexname
rs.Seek "=", SearchValue

If Not rs.NoMatch Then
MsgBox "Found It!", 64
Else
MsgBox "Not Found", 64
End If

rs.Close
db.Close

Exit Sub
SA_Errors:
MsgBox Error, 16, CStr(Err)
Exit Sub

End Sub

To run the Sub procedure, type the following line in the Immediate window,
and then press ENTER:
Seek_Attached_Table "Orders","PrimaryKey",11000

Note that the message "Found It!" appears.
REFERENCESFor more information about linking tables, click Microsoft Access
Help on the Help menu, type should I import or link a table? in the Office
Assistant or the Answer Wizard, and then click Search to view the topic.

Last Reviewed: 5/13/2002
Keywords: kbhowto kbProgramming KB210266


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 16, 2002 11:43 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: [OT] Changing filename to linked file in
Access


OK. That's more like it. At least I can move a file and repoint without
having to change the query.

Thanks.

Troy Funte
Liberty Electronics

----- Original Message -----
From: John Sage
To: vantage@yahoogroups.com
Sent: Monday, December 16, 2002 11:25 PM
Subject: RE: [Vantage] Re: [OT] Changing filename to linked file in Access


Troy,

Tools -> Database Utilities -> Linked Table Manager.

It is still tedious <g>.



have fun,
john





-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, December 16, 2002 6:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: [OT] Changing filename to linked file in
Access



















Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
15
Sorry Troy,

We must be using different versions of Access. We're still using 97.

Brian

--- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> Brian,
> When I go to Tools -> Add-ins, all I see is "Add-Ins Manager"
and "Crystal Report Wizard". How do I add the Linked Table manager
to the Add-ins?
>
> (and for that matter, why does the "Crystal Report Wizard" ask me
for a database password?)
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Brian Stenglein <bstenglein@c...>
> To: vantage@yahoogroups.com
> Sent: Monday, December 16, 2002 8:54 AM
> Subject: [Vantage] Re: [OT] Changing filename to linked file in
Access
>
>
> Troy,
>
> Have you tried using the Linked Table manager in Access? It's
still
> kind of a hassle, but probably not as bad as what you're facing
now.
> You'll find it under Tools -> Add-ins. It will allow you to keep
the
> same table in Access and point it to an new Excel file/Location.
>
> Hope that helps.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "Troy Funte" <tfunte@e...> wrote:
> > I LINK Excel files in Access for use in Crystal reports. If I
> change the name or location of the Excel file, I have to recreate
the
> links in Access, along with the Queries as well. Is there way to
> change the name and/or location of a Linked file with out
relinking
> it (and the Queries?). It kind of a hastle when testing various
> options.
> >
> > Troy Funte
> > Liberty Electronics
> >
> >
> > [Non-text portions of this message have been removed]
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> [Non-text portions of this message have been removed]