I have an external DBase IV file created and continually updated by 3rd party software. Using OLEDB I can sequentially read through the DB all ok. see attached code snippet.
Question 1: Kn...
I want to create an dbf file from VB. I have used ADODB with connection string as - "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<Path>;Extended Properties="DBASE IV;"
The file is getting cr...
Hi,
I have been developing an application for a company using MS Access 2007 and when you run the application (some forms are long and require you to scroll down) the mouse wheel does not see...
Hi all...
I've been trying to find out more about this but have largely been unsuccessful. We have a small Access 2007 database roughly 6MB that some of us access via VPN when we're able to...
I'm back, here's my next problem. in my table I have a field that's data type as yes/no. On my form I have a combo box that drops down Yes and no. The combo box works but i have 2 issues.
...
C++Builder 5.02 / Windows XP
TMS Software (DBAdvGrid) to display a query (PobMod->PobQuery1)
Tables
(T_COMPANY fields: C_CODE, C_COMPANY)
(T_EMPLOYEE fields: C_CODE, E_ID, E_NAME,..........
I try to create a dbf file (dBase 4) from C# using an OleDb connection as shown in code snippet.
When I run it the file is created but the number field is written with 5 decimal points.
How ...
I have an inherited MS C development environment which I usually use for reading Btrieve files and writing out to dBase (.dbf) files; this is done by a prewritten function extractToDbase which...
I need to deploy a HOTFIX to MS Access 2003 (http://support.microsoft.com/kb/945674/en-us
) across about 300 PC's.
This is an .MSP file and the previous regime didn't do an administratrati...
I have a need to translate some simple Pascal/C/PHP + MySQL skills to Visual FoxPro (various versions from 2.6 through 8.0+). Programming logic is not the issue - it's just my grasp of VFP th...
Hi, I have a DBF file and one of its columns is called Date, and its datatype is Date (8). I used the following statement to select records for specifc date, but it does not work:
SELECT * ...
Hi ,
We are the processess of changing our storage from SAN to NAS. This is the same location where the widows quorum drive is also located. I created a 2 Gb drive in NAS and mounted to bot...
I have a old accounting system using dbase IV as database..
when running the recalculate balances, error code 107 (operator/operand mismatch) and code 9, (data type mismatch) appears.
I've...
After installing an UPS on our main server we are unable to open our database with ACT! 8.0. we are given the following error message
"The last database opened cannot be located"
when lo...
Is it possible when importing via CSV in SQLyog to add lines with the same value for the Primary Key.
trying to add records to an existing database and some of the existing records have the s...
I'm working on creating a dbase in access, I have 3 tables linked, and have some calculations being done in some of my fields. I have 2 subforms that may have several items in them, and I need...
We have an ASP page running on a Windows 2000 server. The ASP page connects to a dbase database with the following code.
set dbconnection = server.createobject("adodb.connection")
dbconne...
How can data be recovered from the MFT? How can I open or read .rdb file extensions?
This is all being done on an XP Home OS, and I also have access to several OSX systems.
I've used severa...
Can a MySQL database be moved from one hosting plan to another?
I have two tables. MgrInfo and SafetyInfo. I a primary key in each table. Id_mgr and Id_safety then I created a 3rd field in the SafetyInfo table and just made that numeric. I used the dia...
Someone in another office has a Zope DB and has some tables I need to get into my MS SQL database. I am not sure that a CSV will work. The guy in the other office has tried to develop a dbf fo...
Hi All,
Please see the attached document as this was easier to explain with the printscreens. I am basically having trouble returning relevant records from a local table. It may be an easy ...
Hello everyone,
We are running a Windows environment (XP clients with Server 2003). We currently use Goldmine 6.7 for customer records, ect. We need to export certain data out of Goldmine 6...
I have my tables and relationships but want to make sure I have a good structure. It seems like I have a lot of tables
How do I convert dbase iii plus programs to run in MS access?
