filemaker versus access 
Author Message
 filemaker versus access

hi everyone,
i wonder if you can help in what is basically a "which one is the
best" question?
at work we are using a very old mac version of filemakerpro (1.0 or
something) on the only remaining mac computer (a power pc) the
database has lots of scripts linking staff hours to which school they
are in so on, which have been built up over years which would be a
REAL pain to reconfigure
however we need to convert the database to pc so that everyone else
can work with it....

basically our choices are:
1. find a way to convert to msaccess (we have a site licence so
everyone can already use this) - by far the cheapest option
2. upgrade to filemaker pro5 for pc, but only run the database on one
machine, due to cost. If this is the case will it convert all the
scripts?
3. a combination of the above - convert to fp5 and then to msaccess -
don't know if this is possible or even advisable

i don't have any burning desire to use msaccess other than it is
installed on all our machines at work and we don't have a large budget
(working in education)

sorry for being so longwinded but thanks for your time!

cheers,
mark,
m/cr.



Wed, 30 Jul 2003 21:08:50 GMT
 filemaker versus access

The old version of FMP matters. If it is really "...filemakerpro (1.0 or
something)", you may need an intermediate step to open the file in 5. If it
is 2.1 or later, you can open it directly in 5 on a Mac, and then in 5 on a
PC. If the PC and Mac are networked, you will need a separate license for
each.

If the original is indeed 2.1 or later, you may not need to alter anyt
aspect of the database, as it ought to run perfectly with no modification.
that begs the question, however, of what all those improvements have been in
aid of, as the latest version offers a myriad of features (most
predominately relational databases) not available inthe early versions.

2.1 files actually will open on a PC; the problem would be to find a
license.

As for "converting" to Access, there really is no such thing, although you
ought to be able to export the data to a perfectly build Access file. But
any Access solution would need to be built from the ground up.

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


Quote:
> hi everyone,
> i wonder if you can help in what is basically a "which one is the
> best" question?
> at work we are using a very old mac version of filemakerpro (1.0 or
> something) on the only remaining mac computer (a power pc) the
> database has lots of scripts linking staff hours to which school they
> are in so on, which have been built up over years which would be a
> REAL pain to reconfigure
> however we need to convert the database to pc so that everyone else
> can work with it....

> basically our choices are:
> 1. find a way to convert to msaccess (we have a site licence so
> everyone can already use this) - by far the cheapest option
> 2. upgrade to filemaker pro5 for pc, but only run the database on one
> machine, due to cost. If this is the case will it convert all the
> scripts?
> 3. a combination of the above - convert to fp5 and then to msaccess -
> don't know if this is possible or even advisable

> i don't have any burning desire to use msaccess other than it is
> installed on all our machines at work and we don't have a large budget
> (working in education)

> sorry for being so longwinded but thanks for your time!

> cheers,
> mark,
> m/cr.



Thu, 31 Jul 2003 00:37:21 GMT
 filemaker versus access
thanks, John
i think it may be 2.1 because i tried  importing the some of the
database into the trial version and it worked a treat

one very happy man :-)

cheers,
mark,
m/cr.



Fri, 01 Aug 2003 00:29:09 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Filemaker CDML versus XML

2. UNION versus OR versus IN in SQL 7

3. NULL versus IN (NULL) versus IS NULL

4. V.C++ versus V.Basic versus Delphi

5. V.C++ versus V.Basic versus Delphi

6. Tables versus Dbspaces versus Databases

7. queries versus tcursors versus filters

8. Access versus SQL server for data storage for a new start up company

9. Access versus SQL

10. Sql Server versus Access

11. Access versus SQL Server

12. Access as client for SQL Server 2000 versus Visual Studio


 
Powered by phpBB® Forum Software