Access vs FileMaker

[cpatterson]

I have 2 questions.

1. I have a client who asked if it was OK for his database person to develop a database in FileMaker Pro 5 and then have me put it on the web for him. Users would query, add to and update this database. I know Access, but nothing about FileMaker. What are some pros and cons in using FileMaker vs Access?

2. Does anyone know the ODBC connection for FileMaker? I'm getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed

for this code:

Set conntemp = server.CreateObject("adodb.Connection")

conntemp.Open "DRIVER={FileMaker Pro}; DBQ=e:webfpdbtest.fp5"

Set RS = conntemp.Execute("SELECT * From test")

Thanks for any help you can give (to either question)

Christy

[Anatoli]

Is the test.fp5 running in FileMaker?

To compare Access vs FileMaker, hmm how about VW Beetle with clutch vs latest Mercedes 600 series?

[Robarov]

What do you mean ? Filemaker is like a Mercedes 600 ?

You think its that magnificant ?

[Lee Smith]

Hi Robarov, and welcome to the Forum.

Anatoli hasn't been active since October of last year, so I wouldn't expect a response from Anatoli.

Don't you think that FileMaker is magnificent, why else would you be here in a FileMaker Form?

Lee

[Robarov]

Yes, I think is great for easy simple application.

For that is wonderfull.

I m trying to connect to a filemaker database in VB6

I can t get it working... can you get me some directions ?

myConnString = "DRIVER={FileMaker Pro}; DBQ=C:test.fp5"

Dim myConnection As New ADODB.Connection

myConnection.ConnectionString = myConnString

myConnection.Open

MsgBox "ServerVersion: " & myConnection.Version & vbCrLf & "DataSource: " & myConnection.Provider & vbCrLf & "State: " & myConnection.State

myConnection.Close

I m lost here ...

[Garry Claridge]

Check the ODBC Forum. Maybe some hints there.

All the best.

Garry