Search results for query: *

I just installed Namo Webeditor v3.08 and it is a slick WYSIWYG editor with built-in HTML source and browser running simultaneously.  It produces clean, basic easily manipulatable code for people who would rather be a bullet than an atom bomb because they prefer 'the personal...

Go to control panel ODBC data sources, choose system DSN, add the one for your database.&nbsp;&nbsp;Make up your data source name--that is the name used in the connect string for your ASP code.<br><br>A file DSN is a snapshot of the data.&nbsp;&nbsp;&nbsp;A user DSN is not visible to...

Sounds like your form or query is corrupted.&nbsp;&nbsp;<br>Find out which one.&nbsp;&nbsp;Execute the query by itself by opening it for modification and then execute it (the exclamation mark on the toolbar).&nbsp;&nbsp;If it returns the records it should then check the form for obvious...

I agree with Jim, but sometimes Access can be pretty slow in adding the data into Oracle--it wants to transfer all of the records at once--which takes a lot of memory and wastes time building big &quot;undo&quot; and &quot;rollback&quot; files.&nbsp;&nbsp;We've found that after we link the...

How about two rows of two dashes? <br> <br> -- This is a comment<br> --<br> <br> <br>

Solo, <br> <br> Two things that may help..<br> <br> (1) You should also check your linked table to make sure that the field names are valid field names in access. <br> (2) In the ODBC control panel settings dialog there is a trace function--turn it on to see what the difficulty may be.<br> <br>...

If you are using the 8.0.05 version of the Oracle ODBC driver for Access then you should upgrade to the 8.0.058 version. It will eliminate many problems.<br> <br> However, I have found one bug in both drivers. My linked tables are actually linked to Oracle views built from the following...

If you are using the 8.0.05 version of the Oracle ODBC driver for Access then you should upgrade to the 8.0.058 version. It will eliminate many problems.<br> <br> However, I have found one bug in both drivers. My linked tables are actually linked to Oracle views built from the following...

Public Function Search_All(srchSTR as String, Yourcolumn as String)<br> Dim qdf as Querydef<br> Dim tdf As TableDef<br> Dim wsp As Workspace<br> Dim dbData As Database<br> Dim rst As Recordset<br> Dim i As Long<br> Set dbData = CurrentDb<br> On Error Resume Next<br> With dbData<br> For...

Q #1 This site<br> Q #2 SQL server is faster than Access.<br> <br> <br> <br>

You can build a view using a where clause. <br> <br> For instance, two locations using the same employee table. Site_ID field contains the location name. <br> View would be <br> Select * from employee where site_id = user;<br> <br> Or even--<br> Select * from equipment where site_id in...

Actually, I used the demo tables which came with Oracle 8.0.5 as a testbed without success. This morning I had a table who's structure had been unchanged but the data had been mixed case and I updated it to upper case. For some reason access continued to see the data as mixed case. So I used...

Thank you Jim, but I used one of the demo tables and I think just about every column is indexed. I wonder if there is a way to let access know what the primary key columns are using code? It's five AM and I've been working on this all night (not just this one problem of course) The error...

Nope. It doesn't work after the tables are modified in SQLPlus. Once that happens the refresh method becomes worthless. Maybe it has to do with selecting the unique identifier for the table (Access, when linking using ODBC asks for the unique key for each table before linking to it). I had...

You can never ensure that the quality of scans will be perfect to your satisfaction so just concentrate on what you can control. If you use the width and height tags on your images you can force the image into a predefined size. Most images are scanned at 640 by 480 or some multiple of that...

Thanks for trying to help. Here is what I have:<br> <br> Backend: Oracle 8.0.5 26 tables with views based on username<br> Front end: Access 97 Links to those views which are then renamed to be user-friendly.<br> <br> I have 26 views built from 26 tables in the back end. When I modify a table in...

Thanks for trying to help. Here is what I have:<br> <br> Backend: Oracle 8.0.5 26 tables with views based on username<br> Front end: Access 97 Links to those views which are then renamed to be user-friendly.<br> <br> I have 26 views built from 26 tables in the back end...