ODBC & Access

[mekim]

Hi All

Sometimes when I have a database open in access I get an error when trying to use the same access database w/ ODB

and othertimes....i don't get an erro

What am I doing wrong (or for that matter right :)) that doesn't allow me to use share us

Regard
mekim

[Mary Chipman]

Hard to say without being there. Access/Jet is not a server, and it
depends on who/what other processes may be using it and locking
tables, etc.

--Mary

On Fri, 2 Apr 2004 12:56:04 -0800, "mekim"
<an*******@discussions.microsoft.com> wrote:

Hi All,

Sometimes when I have a database open in access I get an error when trying to use the same access database w/ ODBC

and othertimes....i don't get an error

What am I doing wrong (or for that matter right :)) that doesn't allow me to use share use

Regards
mekim

[Mary Chipman]

Hard to say without being there. Access/Jet is not a server, and it
depends on who/what other processes may be using it and locking
tables, etc.

--Mary

On Fri, 2 Apr 2004 12:56:04 -0800, "mekim"
<an*******@discussions.microsoft.com> wrote:

Hi All,

Sometimes when I have a database open in access I get an error when trying to use the same access database w/ ODBC

and othertimes....i don't get an error

What am I doing wrong (or for that matter right :)) that doesn't allow me to use share use

Regards
mekim

[Paul Clement]

On Fri, 2 Apr 2004 12:56:04 -0800, "mekim" <an*******@discussions.microsoft.com> wrote:

¤ Hi All,
¤
¤ Sometimes when I have a database open in access I get an error when trying to use the same access database w/ ODBC
¤
¤ and othertimes....i don't get an error
¤
¤ What am I doing wrong (or for that matter right :)) that doesn't allow me to use share use

It might help us identify the problem if you could post the error and line of code on which it
occurs.

In addition, I would highly recommend using the Jet OLEDB provider instead of using the Access ODBC
driver.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Paul Clement]

On Fri, 2 Apr 2004 12:56:04 -0800, "mekim" <an*******@discussions.microsoft.com> wrote:

¤ Hi All,
¤
¤ Sometimes when I have a database open in access I get an error when trying to use the same access database w/ ODBC
¤
¤ and othertimes....i don't get an error
¤
¤ What am I doing wrong (or for that matter right :)) that doesn't allow me to use share use

It might help us identify the problem if you could post the error and line of code on which it
occurs.

In addition, I would highly recommend using the Jet OLEDB provider instead of using the Access ODBC
driver.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)