|
 |
asp_web_howto thread: ODBC connection to access mdb in readonly
Message #1 by "Rob v. Osnabrugge" <osnabrr@h...> on Mon, 14 Oct 2002 14:44:02
|
|
Dear ASP
how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"
Many thanks,
Rob
Message #2 by "TomMallard" <mallard@s...> on Mon, 14 Oct 2002 07:48:57 -0700
|
|
Open the ODBC mgr and click options...brings up the read-only box.
tom mallard
seattle
-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Monday, October 14, 2002 2:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC connection to access mdb in readonly
Dear ASP
how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"
Many thanks,
Rob
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #3 by "Rob v. Osnabrugge" <osnabrr@h...> on Tue, 15 Oct 2002 20:13:18
|
|
Tom,
I did not mean via control panel, but by means of the connection string in
an ASP page
Rob
> Open the ODBC mgr and click options...brings up the read-only box.
tom mallard
seattle
-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Monday, October 14, 2002 2:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC connection to access mdb in readonly
Dear ASP
how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"
Many thanks,
Rob
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #4 by "TomMallard" <mallard@s...> on Tue, 15 Oct 2002 20:32:16 -0700
|
|
Add "ReadOnly=1;" to the connection string...here's an example of most of
the attributes you can set.
[ODBC]
DRIVER=Microsoft Access Driver (*.mdb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=1
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=MS Access
Exclusive=0
DriverId=25
DefaultDir=C:\Inetpub\root\data\kitesport.com
DBQ=C:\Inetpub\root\data\kitesport.com\ksp.mdb
tom
-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Tuesday, October 15, 2002 8:13 PM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: ODBC connection to access mdb in readonly
Tom,
I did not mean via control panel, but by means of the connection string in
an ASP page
Rob
> Open the ODBC mgr and click options...brings up the read-only box.
tom mallard
seattle
-----Original Message-----
From: Rob v. Osnabrugge [mailto:osnabrr@h...]
Sent: Monday, October 14, 2002 2:44 PM
To: ASP Web HowTo
Subject: [asp_web_howto] ODBC connection to access mdb in readonly
Dear ASP
how can I make my existing odbc connection to an Access database on the
web-server such that the connection is set to "readonly"
Many thanks,
Rob
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
|
|
 |