Linked Access ODBC Sun Sysytem SQL files

Linked Access ODBC Sun Sysytem SQL files - locking?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ML - 25 Nov 2006 23:48 GMT

I have a simple Access system, using unbound forms, which links to ODBC Sun
System SQL files via a Select Query - for reference material.
e.g customer names, product description - but updates only its own tables -
and by unbound forms and an eventual code update - not a form save.

The Access system is set as no locking, sharing etc....
The ODBC link, as far as I can see, has no locking comments.

The Masters of the Sun System, claim that the Access users are locking the
Sun System records.

Can someone give me some advice please?

TIA
Michael Lewis

Reply to this Message

Stefan Hoffmann - 26 Nov 2006 10:02 GMT

hi Michael,

> The ODBC link, as far as I can see, has no locking comments.

You already have had the right idea. Try to find a driver which supports it.

> The Masters of the Sun System, claim that the Access users are locking the
> Sun System records.

Discuss it with them. They should know the answers, cause they are the
Masters.

Try the following:

Don't read from the tables, use views on the Sun system instead. So
locking should be solved by the server itself.

mfG
--> stefan <--

Reply to this Message