Search results for query: *

Thanks Tom and Shaun for replying so quickly. As to Tom's thought, the primary key is not an autonumber field so I don't think that article applies. As to Shaun's point, I agree that moving the data into a new database should help, but I've already tried that and the problem still happens...

Thanks for the reply Shaun. While your solution will fix the problem once it has occurred, I'm looking to find out the reason the problem happens in the first place. For instance, is it an issue with a slow network computer not finishing one database call before another call is made? It...

Hi all. I have an MS Access 2000 database used as the backend for VB code. At a client's site, multiple networked users are connected to the database at any time. Some users occasionally receive the message: "Record(s) cannot be read; no read permission on 'XXXXXXX'" on a few...

LazyMe (Rick), Thanks for your original reply regarding using DCOMCNFG. After getting that all important tip, I did some more research and eventually got my ActiveX EXE to work on the remote server.

Thanks lespaul, but I'm trying to avoid having to explicitly alias every field name. That's why I was curious whether it's possible in SQL to change the way field names are "auto-aliased" as in [TABLE_NAME.FIELD_NAME].

I'm in the process of converting my VB app from Access 2000 to MSDE 1.0 (SQL Server 7). I've been modifying the queries as necessary, but have one question for which I can't seem to find an answer. Here's a query example: SELECT E1.EmpNo, E2.EmpNo FROM (Trxn_Mast AS TM LEFT JOIN...

I created an ActiveX EXE to replace a class that may need to be changed often. Instead of having to recompile the application (8 MB), I wanted to be able to simply and quickly replace the ActiveX EXE (80 KB) via an internet connection. The application is placed on the server with multiple...

I have multiple images that are named in sequential order (i.e. Image01.jpg, Image02.jpg, etc.). I would like to give the user a way to re-order the images visually by simply displaying all images in the current sequential order and allowing the user to drag images into the desired order...

Gerald, You should be able to set the RecordSelectionFormula if you change the single quotes to pound signs. This lets CR know to expect a date rather than a string. &quot;{ado.DateofNexVisit} <= #&quot; & todaysdate & &quot;#&quot; Hope this helps, Tim

Here are the steps I would take: (1) multiply the actual value by 4 (2) round the result to the nearest whole number (3) divide the rounded value by 4 For example: (1) 64.4 * 4 = 257.6 (2) 257.6 => 258.0 (3) 258.0 / 4 = 64.50 (1) 96.8 * 4 = 387.2 (2) 387.2 => 387.0 (3) 387.0 / 4 =...

Believe me, I've tried using the Verify method. I seem to get it to work if I first convert the DB driver to ODBC, but that does no good since the networked computers don't have any DSNs pointing the the DB. I'm trying to find out if there is any way to verify a report if it was designed using...

I have 100+ reports which were created using a native connection (psbdao.dll) to an Access2000 DB in Crystal Reports 8.5. In VB using the craxdrt.dll, I'd like to automate a way to verify each report against the DB. I am able to view a report at run-time if the DB has not changed, but I get no...