Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing File Paths
Hi Jez, Some years ago I constructed a property web site + database. I designed a number of .asp pages to enable the site administrator to upload image and pdf files of property details and store details in a database - bits of this is what I think you are looking for. The web server supported...- ianataqsl
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
Why can't I make design changes on client PC's
For anyone following this thread - the problem was with the Access2000 connection to SQL2000 running under Windows 2000 Server + SBS (but still don't know why). A client PC with just Access2000 loaded replicated the problem (unable to open server objects in design view or run procedures). When...- ianataqsl
- Post #4
- Forum: Microsoft: Access Project (ADP)
-
ADO + Check For Duplicate Records
Believe your problem is due to the Recordset.Clone being updated. Try getting the data directly from the server, thus Dim rst As ADODB.recordset Dim myStr As String Dim stLinkCriteria As String Set rst = New ADODB.recordset myStr = Replace(Me![SDist], "'", "''") rst.Open ("Select...- ianataqsl
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
unbound forms in multi-user environment
Concurrence (writeconflict) issues with Access is a BIG subject. If you have a copy of Access Developers Handbook by Litwin-Getz-Gilbert refer to chapter 6, Volume 2 (Enterprise Edition). If you don't, and want to use Access to develop SQL Server applications, I strongly recommend you purchase a...- ianataqsl
- Post #2
- Forum: Microsoft: Access Project (ADP)
-
Why can't I make design changes on client PC's
Thanks for your reply cmmrfrds The client PC's are connecting directly to the SQL2000 server via the Access.adp, the clients therefore should not need any of the SQL 'bits' - should they? other than mdac v 2.6 or higher ? However, the original SQL Db was developed on SQL7 and then moved onto...- ianataqsl
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
Why can't I make design changes on client PC's
I have an SQL2000 Db with an access.adp front end which works fine on the server, but on client PC's I can't open tables in design view or run stored procedures (other than under VBA control with a currentproject.connection). On the client PC's the procedures appear in the database window with a...- ianataqsl
- Thread
- Replies: 3
- Forum: Microsoft: Access Project (ADP)
