FM to MS Access questions 
Author Message
 FM to MS Access questions
We develop Web sites on Macintosh and need to have them hosted by ISP
running Windows servers.

With FM 5.5, can we export our data to server running Access? Will we lose
formatting?

If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that all the
software we need?

Thanks!



Mon, 03 Nov 2003 20:26:12 GMT
 FM to MS Access questions

Exporting data straight from FMP to Access is going to be slow and
cumbersome (yes it will loose formatting). Not quite sure why you need
Access. FMP runs fine on Windows boxes, and I don't believe Lasso has an
Access module.

To serve out FMP files via Web Companion, you will also need Filemaker
Unlimited, as well as web serving software.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> We develop Web sites on Macintosh and need to have them hosted by ISP
> running Windows servers.

> With FM 5.5, can we export our data to server running Access? Will we lose
> formatting?

> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that all the
> software we need?

> Thanks!



Mon, 03 Nov 2003 23:15:25 GMT
 FM to MS Access questions
We dont' need Access, but we need to have our files served by an ISP that
uses Access. Would you suggest switching to an ISP that offers FM?
Quote:

> Organization: CenturyTel.Net
> Newsgroups: comp.databases.filemaker
> Date: Thu, 17 May 2001 08:15:25 -0700
> Subject: Re: FM to MS Access questions

> Exporting data straight from FMP to Access is going to be slow and
> cumbersome (yes it will loose formatting). Not quite sure why you need
> Access. FMP runs fine on Windows boxes, and I don't believe Lasso has an
> Access module.

> To serve out FMP files via Web Companion, you will also need Filemaker
> Unlimited, as well as web serving software.

> --

> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



>> We develop Web sites on Macintosh and need to have them hosted by ISP
>> running Windows servers.

>> With FM 5.5, can we export our data to server running Access? Will we lose
>> formatting?

>> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that all the
>> software we need?

>> Thanks!



Tue, 04 Nov 2003 00:38:04 GMT
 FM to MS Access questions
That question cannot be answered without understanding the other factors
involved. What is the difference between "...don't need Access..." and
"...need to have our files served by an ISP that uses Access"? Any Windows
box can "use" Access, and that shouldn't place any limitation on your choice
of provider, whereas requiring an ISP that can serve out FMP based pages
will constrain your choices.

Where does Access come into play?

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> We dont' need Access, but we need to have our files served by an ISP that
> uses Access. Would you suggest switching to an ISP that offers FM?


> > Organization: CenturyTel.Net
> > Newsgroups: comp.databases.filemaker
> > Date: Thu, 17 May 2001 08:15:25 -0700
> > Subject: Re: FM to MS Access questions

> > Exporting data straight from FMP to Access is going to be slow and
> > cumbersome (yes it will loose formatting). Not quite sure why you need
> > Access. FMP runs fine on Windows boxes, and I don't believe Lasso has an
> > Access module.

> > To serve out FMP files via Web Companion, you will also need Filemaker
> > Unlimited, as well as web serving software.

> > --

> > John Weinshel
> > Datagrace
> > Associate Member, Filemaker Solutions Alliance
> > Vashon Island, WA
> > (206) 463-1634



> >> We develop Web sites on Macintosh and need to have them hosted by ISP
> >> running Windows servers.

> >> With FM 5.5, can we export our data to server running Access? Will we
lose
> >> formatting?

> >> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that all
the
> >> software we need?

> >> Thanks!



Tue, 04 Nov 2003 01:22:52 GMT
 FM to MS Access questions
The ISP has Access on their Web server. Their PC-based customers create DB
files in Access, send them to the ISP, and have the DBs served via the ISP's
copy of Access.

In our case, we're on Macs so we CAN'T have Access.

We were thinking about using FM to create the files, export them, send the
exported files to the ISP, and (hopefully) have them work like real Access
files. (I thought this was what "ODBC" was about.)

The alternative is to abandon the ISP and sign up with one that runs FM.

Quote:

> Organization: CenturyTel.Net
> Newsgroups: comp.databases.filemaker
> Date: Thu, 17 May 2001 10:22:52 -0700
> Subject: Re: FM to MS Access questions

> That question cannot be answered without understanding the other factors
> involved. What is the difference between "...don't need Access..." and
> "...need to have our files served by an ISP that uses Access"? Any Windows
> box can "use" Access, and that shouldn't place any limitation on your choice
> of provider, whereas requiring an ISP that can serve out FMP based pages
> will constrain your choices.

> Where does Access come into play?

> --

> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



>> We dont' need Access, but we need to have our files served by an ISP that
>> uses Access. Would you suggest switching to an ISP that offers FM?


>>> Organization: CenturyTel.Net
>>> Newsgroups: comp.databases.filemaker
>>> Date: Thu, 17 May 2001 08:15:25 -0700
>>> Subject: Re: FM to MS Access questions

>>> Exporting data straight from FMP to Access is going to be slow and
>>> cumbersome (yes it will loose formatting). Not quite sure why you need
>>> Access. FMP runs fine on Windows boxes, and I don't believe Lasso has an
>>> Access module.

>>> To serve out FMP files via Web Companion, you will also need Filemaker
>>> Unlimited, as well as web serving software.

>>> --

>>> John Weinshel
>>> Datagrace
>>> Associate Member, Filemaker Solutions Alliance
>>> Vashon Island, WA
>>> (206) 463-1634



>>>> We develop Web sites on Macintosh and need to have them hosted by ISP
>>>> running Windows servers.

>>>> With FM 5.5, can we export our data to server running Access? Will we
> lose
>>>> formatting?

>>>> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that all
> the
>>>> software we need?

>>>> Thanks!



Tue, 04 Nov 2003 01:39:31 GMT
 FM to MS Access questions
Well, still a bit confused about who "their PC-based customers" are. And I
do not understand how Access files can be "..served via the ISP's copy of
Access." Access files can't be served; the data in them can be passed (and
formatted) to software that can mark them up so that they will display
correctly in browsers.

If I am not misunderstanding Bob Osola, our resident ODBC expert, you do not
want to depend on FMP's wimpy ODBC protocol for dynamic data exchange-- at
least not in 5.03. The ODBC functionality has been beefed up in the new rev
(5.5), but I do not know if will accomodate realtime exchange, and even if
it did, I'd be surprised if it were not still a major speed bottleneck.
Unless speed does not matter, I suggest you find a way to do all the
database work either in Filemaker or in Access.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> The ISP has Access on their Web server. Their PC-based customers create DB
> files in Access, send them to the ISP, and have the DBs served via the
ISP's
> copy of Access.

> In our case, we're on Macs so we CAN'T have Access.

> We were thinking about using FM to create the files, export them, send the
> exported files to the ISP, and (hopefully) have them work like real Access
> files. (I thought this was what "ODBC" was about.)

> The alternative is to abandon the ISP and sign up with one that runs FM.


> > Organization: CenturyTel.Net
> > Newsgroups: comp.databases.filemaker
> > Date: Thu, 17 May 2001 10:22:52 -0700
> > Subject: Re: FM to MS Access questions

> > That question cannot be answered without understanding the other factors
> > involved. What is the difference between "...don't need Access..." and
> > "...need to have our files served by an ISP that uses Access"? Any
Windows
> > box can "use" Access, and that shouldn't place any limitation on your
choice
> > of provider, whereas requiring an ISP that can serve out FMP based pages
> > will constrain your choices.

> > Where does Access come into play?

> > --

> > John Weinshel
> > Datagrace
> > Associate Member, Filemaker Solutions Alliance
> > Vashon Island, WA
> > (206) 463-1634



> >> We dont' need Access, but we need to have our files served by an ISP
that
> >> uses Access. Would you suggest switching to an ISP that offers FM?


> >>> Organization: CenturyTel.Net
> >>> Newsgroups: comp.databases.filemaker
> >>> Date: Thu, 17 May 2001 08:15:25 -0700
> >>> Subject: Re: FM to MS Access questions

> >>> Exporting data straight from FMP to Access is going to be slow and
> >>> cumbersome (yes it will loose formatting). Not quite sure why you need
> >>> Access. FMP runs fine on Windows boxes, and I don't believe Lasso has
an
> >>> Access module.

> >>> To serve out FMP files via Web Companion, you will also need Filemaker
> >>> Unlimited, as well as web serving software.

> >>> --

> >>> John Weinshel
> >>> Datagrace
> >>> Associate Member, Filemaker Solutions Alliance
> >>> Vashon Island, WA
> >>> (206) 463-1634



> >>>> We develop Web sites on Macintosh and need to have them hosted by ISP
> >>>> running Windows servers.

> >>>> With FM 5.5, can we export our data to server running Access? Will we
> > lose
> >>>> formatting?

> >>>> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that
all
> > the
> >>>> software we need?

> >>>> Thanks!



Tue, 04 Nov 2003 02:18:36 GMT
 FM to MS Access questions
If I can refer you to this web page:

http://www.hostpro.com/hosting/shared/win2k_mission200.html

In the database section of the features list, click on the Microsoft Access
item and a popup window will explain what they mean.

Thanks.

Quote:

> Organization: CenturyTel.Net
> Newsgroups: comp.databases.filemaker
> Date: Thu, 17 May 2001 11:18:36 -0700
> Subject: Re: FM to MS Access questions

> Well, still a bit confused about who "their PC-based customers" are. And I
> do not understand how Access files can be "..served via the ISP's copy of
> Access." Access files can't be served; the data in them can be passed (and
> formatted) to software that can mark them up so that they will display
> correctly in browsers.

> If I am not misunderstanding Bob Osola, our resident ODBC expert, you do not
> want to depend on FMP's wimpy ODBC protocol for dynamic data exchange-- at
> least not in 5.03. The ODBC functionality has been beefed up in the new rev
> (5.5), but I do not know if will accomodate realtime exchange, and even if
> it did, I'd be surprised if it were not still a major speed bottleneck.
> Unless speed does not matter, I suggest you find a way to do all the
> database work either in Filemaker or in Access.

> --

> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



>> The ISP has Access on their Web server. Their PC-based customers create DB
>> files in Access, send them to the ISP, and have the DBs served via the
> ISP's
>> copy of Access.

>> In our case, we're on Macs so we CAN'T have Access.

>> We were thinking about using FM to create the files, export them, send the
>> exported files to the ISP, and (hopefully) have them work like real Access
>> files. (I thought this was what "ODBC" was about.)

>> The alternative is to abandon the ISP and sign up with one that runs FM.


>>> Organization: CenturyTel.Net
>>> Newsgroups: comp.databases.filemaker
>>> Date: Thu, 17 May 2001 10:22:52 -0700
>>> Subject: Re: FM to MS Access questions

>>> That question cannot be answered without understanding the other factors
>>> involved. What is the difference between "...don't need Access..." and
>>> "...need to have our files served by an ISP that uses Access"? Any
> Windows
>>> box can "use" Access, and that shouldn't place any limitation on your
> choice
>>> of provider, whereas requiring an ISP that can serve out FMP based pages
>>> will constrain your choices.

>>> Where does Access come into play?

>>> --

>>> John Weinshel
>>> Datagrace
>>> Associate Member, Filemaker Solutions Alliance
>>> Vashon Island, WA
>>> (206) 463-1634



>>>> We dont' need Access, but we need to have our files served by an ISP
> that
>>>> uses Access. Would you suggest switching to an ISP that offers FM?


>>>>> Organization: CenturyTel.Net
>>>>> Newsgroups: comp.databases.filemaker
>>>>> Date: Thu, 17 May 2001 08:15:25 -0700
>>>>> Subject: Re: FM to MS Access questions

>>>>> Exporting data straight from FMP to Access is going to be slow and
>>>>> cumbersome (yes it will loose formatting). Not quite sure why you need
>>>>> Access. FMP runs fine on Windows boxes, and I don't believe Lasso has
> an
>>>>> Access module.

>>>>> To serve out FMP files via Web Companion, you will also need Filemaker
>>>>> Unlimited, as well as web serving software.

>>>>> --

>>>>> John Weinshel
>>>>> Datagrace
>>>>> Associate Member, Filemaker Solutions Alliance
>>>>> Vashon Island, WA
>>>>> (206) 463-1634



>>>>>> We develop Web sites on Macintosh and need to have them hosted by ISP
>>>>>> running Windows servers.

>>>>>> With FM 5.5, can we export our data to server running Access? Will we
>>> lose
>>>>>> formatting?

>>>>>> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that
> all
>>> the
>>>>>> software we need?

>>>>>> Thanks!



Tue, 04 Nov 2003 03:12:20 GMT
 FM to MS Access questions
I see. You mean that that particular ISP offers Access hosting, but does not
seem to offer FMP hosting. You have done your work in Filemaker, and want to
host the files using the work you have already done.

If that is correct, then, yes, I would try to find an ISP that will host FMP
files. Unfortunately, not all ISP's that host databases host FMP databases,
but many do. There is a list on Filemaker's site
(http://www.filemaker.com/products/isp.html#Americas), but it is a fairly
incomplete list, and I would search the web for more. Once you have some
likely candidates, contact them to find out about how they price (per file,
per hit, per storage space?), how well they know FMP hosting, how long
they've been in business, etc. There is a lot of variety.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> If I can refer you to this web page:

> http://www.hostpro.com/hosting/shared/win2k_mission200.html

> In the database section of the features list, click on the Microsoft
Access
> item and a popup window will explain what they mean.

> Thanks.


> > Organization: CenturyTel.Net
> > Newsgroups: comp.databases.filemaker
> > Date: Thu, 17 May 2001 11:18:36 -0700
> > Subject: Re: FM to MS Access questions

> > Well, still a bit confused about who "their PC-based customers" are. And
I
> > do not understand how Access files can be "..served via the ISP's copy
of
> > Access." Access files can't be served; the data in them can be passed
(and
> > formatted) to software that can mark them up so that they will display
> > correctly in browsers.

> > If I am not misunderstanding Bob Osola, our resident ODBC expert, you do
not
> > want to depend on FMP's wimpy ODBC protocol for dynamic data exchange--
at
> > least not in 5.03. The ODBC functionality has been beefed up in the new
rev
> > (5.5), but I do not know if will accomodate realtime exchange, and even
if
> > it did, I'd be surprised if it were not still a major speed bottleneck.
> > Unless speed does not matter, I suggest you find a way to do all the
> > database work either in Filemaker or in Access.

> > --

> > John Weinshel
> > Datagrace
> > Associate Member, Filemaker Solutions Alliance
> > Vashon Island, WA
> > (206) 463-1634



> >> The ISP has Access on their Web server. Their PC-based customers create
DB
> >> files in Access, send them to the ISP, and have the DBs served via the
> > ISP's
> >> copy of Access.

> >> In our case, we're on Macs so we CAN'T have Access.

> >> We were thinking about using FM to create the files, export them, send
the
> >> exported files to the ISP, and (hopefully) have them work like real
Access
> >> files. (I thought this was what "ODBC" was about.)

> >> The alternative is to abandon the ISP and sign up with one that runs
FM.


> >>> Organization: CenturyTel.Net
> >>> Newsgroups: comp.databases.filemaker
> >>> Date: Thu, 17 May 2001 10:22:52 -0700
> >>> Subject: Re: FM to MS Access questions

> >>> That question cannot be answered without understanding the other
factors
> >>> involved. What is the difference between "...don't need Access..." and
> >>> "...need to have our files served by an ISP that uses Access"? Any
> > Windows
> >>> box can "use" Access, and that shouldn't place any limitation on your
> > choice
> >>> of provider, whereas requiring an ISP that can serve out FMP based
pages
> >>> will constrain your choices.

> >>> Where does Access come into play?

> >>> --

> >>> John Weinshel
> >>> Datagrace
> >>> Associate Member, Filemaker Solutions Alliance
> >>> Vashon Island, WA
> >>> (206) 463-1634



> >>>> We dont' need Access, but we need to have our files served by an ISP
> > that
> >>>> uses Access. Would you suggest switching to an ISP that offers FM?


> >>>>> Organization: CenturyTel.Net
> >>>>> Newsgroups: comp.databases.filemaker
> >>>>> Date: Thu, 17 May 2001 08:15:25 -0700
> >>>>> Subject: Re: FM to MS Access questions

> >>>>> Exporting data straight from FMP to Access is going to be slow and
> >>>>> cumbersome (yes it will loose formatting). Not quite sure why you
need
> >>>>> Access. FMP runs fine on Windows boxes, and I don't believe Lasso
has
> > an
> >>>>> Access module.

> >>>>> To serve out FMP files via Web Companion, you will also need
Filemaker
> >>>>> Unlimited, as well as web serving software.

> >>>>> --

> >>>>> John Weinshel
> >>>>> Datagrace
> >>>>> Associate Member, Filemaker Solutions Alliance
> >>>>> Vashon Island, WA
> >>>>> (206) 463-1634



> >>>>>> We develop Web sites on Macintosh and need to have them hosted by
ISP
> >>>>>> running Windows servers.

> >>>>>> With FM 5.5, can we export our data to server running Access? Will
we
> >>> lose
> >>>>>> formatting?

> >>>>>> If we use FM 5.5 Pro, Dreamweaver, and Lasso Suite for DW, is that
> > all
> >>> the
> >>>>>> software we need?

> >>>>>> Thanks!



Tue, 04 Nov 2003 03:40:45 GMT
 FM to MS Access questions


Quote:
> If I can refer you to this web page:

> http://www.hostpro.com/hosting/shared/win2k_mission200.html

> In the database section of the features list, click on the Microsoft
> Access item and a popup window will explain what they mean.

Philip, as John says, the mere act of hosting any database on a webserver is
not enough to display it automatically. You still have to build a front-end
which mixes your text and graphics with the external data by including
server-side script in your HTML. On an FM-hosting ISP, you'd write CDML or
Lasoo code inside your HTML to get at the data source. On an NT site you'd
write ASP code to pull the data. Both are good technologies, but Access is a
poor choice for any site expecting more than low thousands of hits per day.
It simply doesn't scale. SQL Server is the only serious choice for NT-based
hosts.

In any event, ODBC is not fully implemented in Filemaker 5; other apps can
read/write FM files, but FM (without buying a plug-in) can only *import*
from external sources. Worse still, as a Mac user, you cannot connect to
Access via ODBC *at all*, because there is no such thing as a Mac ODBC
driver for Access.

If you really *need* to stick with this ISP, you'll have to get a PC with
Access on your network, then, on the PC, import the FM data via ODBC into
Access, then re-export it up to the Access on the ISP. Yuk.

I suggest you change to an FM-supporting ISP. FM Inc maintain a list of FM-
friendly ISPs at:
http://www.filemaker.com/products/isp.html

--
Regds, Bob Osola



Tue, 04 Nov 2003 04:39:02 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. Exporting FM pro to MS access

2. FM -> MS Access with repeating fields

3. I have a Win FM Plugin for MS Access

4. CA-MILPITAS-111217--Management-MS Office-MS Word-MS Excel-MS ACCESS-ORACLE-GROUP CONTROLLER

5. CA-MILPITAS-111217--Management-MS Office-MS Word-MS Excel-MS ACCESS-ORACLE-GROUP CONTROLLER

6. question reg. MS-Access database access using VB3

7. Newbie question: login screen while trying to get access to MS-Access database

8. QUESTION: How to use Borland C++ 4.0 to access MS Access 2.0 databases

9. MS-Access 97 to SQL Server to MS-Access 97


 
Powered by phpBB® Forum Software