Linked Access ODBC Sun Sysytem SQL files - locking?

  • Thread starter Thread starter ML
  • Start date Start date
M

ML

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
 
hi Michael,
The ODBC link, as far as I can see, has no locking comments.
Click to expand...
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.
Click to expand...
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 <--
 
Back
Top