Recent content by cravincreeks

This is more likely to be and ODBC issue rather than a Postgres. We ran into this problem when attempting to do something similar with SQL Server (MSDE). ODBC won't let you update two tables at the same time if both tables have columns on the same form. Instead you can put fields from one...

Hello all. I developed a simple MS Access 2002 database (.mdb) with a few forms that have custom code. I initially used ADO 2.7 libraries. I sent it to a person in an entirely different department who is using Access 2000. She's repeatedly getting "Method or data member not found" when she...

Hello all. I'm trying to test some code that's executed by an Access form, but am encountering what seems to be some inconsistent behavior. This form is used for data entry and has many tabs on it. The first tab has THE four required fields. When they change a combo box on another tab, it...

Hello all, We're migrating a large volume of data from an ESRI personal geodatabase stored in MS Access to a ESRI ArcSDE geodatabase stored in Oracle. The actual migration process must use ESRI proprietary objects that are necessary to ensure the spatial data and the related spatial indexes...

Hello all I'm working on a legacy database created by another person. It has a form whose record source is a select query. The form has a combo box, which is not bound to the record source, on it that can be used to 'jump' to a record in the query by typing a unique file number into it...

Hello all, I'm stuck on this query. I have a Parcels table which has a record for every parcel such as ParcelID -------- Parcel1 Parcel2 Parcel3 Parcel4 I also have a land use table that relates to the parcel via the ParcelID. A single parcel can have many land uses. ParcelID...

Thanks for your reply. I heard the FSO is slow. (see http://www.tek-tips.com/viewthread.cfm?qid=1260861&page=1) Do you agree?

Hello all. I'm seeking a fast routine that will list all files (by file name) in a given directory that were created after a particular date and time. This will be run in ESRI's ArcGIS and that software has its own 'Application' object. Consequently, it could get tricky if I attempt to use...

Any free code or COM dll's out there for printing to PDFs? Ideally, it will work any printable document ... similar to using PDF Distiller from Print Menus. But I would like to be able to programmaticly specify the output directory and file name? I intend to use this for saving Access reports...

That fixed the problem. Thanks

Hello all, I have a bar chart in a report that is based on a query. I manually stretched the bar chart so that it fills most of the 8.5" by 11" page (if it were smaller, it'd be difficult to read). The bar chart renders correctly, but there are 41 pages in the report, all with the same exact...

We're scoping SSE 2005. I image that SSE 2005 maintains a transaction log? Is that correct? If so, would you be able to do a point-in-time recovery of a SSE 2005 database using the FREE tools that you can download along with SSE 2005? Scenario: We have complex processes that insert, update...

Hello, We are considering migrating several of our access databases/apps to the SSE 2005 back end. The Microsoft site says that the DB size is limited to 4 GB. More literally: "4 GB maximum database size". Does that mean that one can only store 4GB of data on the database server period. Or...

Hello all. I've decided to go with the RAID0 (striped) and back up my files onto my other PC. The to-be RAID0 box has a 100GB HDD and an 80GB HDD. In the RAID set up utility, it indicates that if striping is used, I only have an effective capacity of 160GB (80GB + 80GB), which makes sense...

Thanks for your reply. I looked in the BIOS 'proper' for any RAID settings and could not find any. But I could enter a RAID set up utility, more specifically "Fast Build Utility 1.32 by Promise Technology". It contains an Auto Set Up utility where you can specify that you'd like to optimize...