I have tried to connect to a network sql database with vba in excel 2003 with no success. I have seen several examples on this site buy none seem to work. I can connect to the database from ...
The database could not be exclusively locked to perform the operation.
ALTER DATABASE failed. The default collation of database 'Apex' cannot be set to SQL_Latin1_General_CP1_CI_AS.
System...
Hi. I have a button on a Access form which opens a folder in explorer using the following code:
Private Sub Command12_Click()
Dim ProjPath
ProjPath = "Z:\" & Me.PolicyNo.Value
Shell "C:\...
hello, below is the error i'm getting on trying to upgrade sql 2k5 to sp3. everything upgrades fine except the database portion...
Product: Microsoft SQL Server 2005 - Update 'Service Pack...
At work I have a Windows logon account called username 'bullwinkle' and a password called 'moose'
The IT dept has set up a new machine for me so I can setup IIS with a virtual server to an ...
I was wondering if anyone knew of a free ODBC driver that would work with DBASE? We have a windows 2003 server that needs to connect to a point of sale system that uses an old Dbase database. ...
Hi,
I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the erro...
I have always in other versions of Microsoft Access 2007 used the Command Buttons to open other forms from the "main form." While my buttons that are already on the main form open the new for...
HI,
Web based reporting system was working ok up until today. Got the error ending 'error127' Tried to connect to the dbase via the dsn with the existing credentials that were already ther...
We have a vpn and use MS Access - it is very slow as it is so big and sometime does not open remotely if other users are in it at the office or also remote - how can we get this to work? Do we...
Hi. I have been using the FoxPro ODBC driver to open dBase3 files with nonstandard extensions and it works just fine. However, when I try to open a dBaseIV file I get the error "ERROR [42S02] ...
Hi
I am trying to set up linked server in SQL server 2008 (x86 32 bit) to a folder of FoxPro files. I have downloaded and installed the FoxPro OLE DB driver and tested it by using it in VS ....
Hello All,
I will do my best to explain this problem. I am attemping to query 3 dbf files for student information. The School uses a program called SASI. Some of you may be familiar with th...
Hi,
I've read plenty of posts about incompatibility of standard OLEDB and ODBC drivers with x64 Windows systems. But due to specific reasons I cannot run my IIS in 32bit mode. Is there any fr...
This I am sure is basic but I am having a hard time visualizing it. I have a Database for Tenants. Included is tblTenant, tblState, tblDeveloper and a couple others. Now I have hit a wall b...
Hi,
Hi,
I have a big question about database design. I have some products to keep their properties in database. But there is not a exact template of this products. Some could have 50 fie...
I believe my Microsoft dBase ODBC driver has gotten corrupt because I can't add a User DSN with it. When I try to add one I get the following error:
"The setup routines for the Microsoft dB...
Hi,
I have an ancient laptop running windows 95 and a DOS based accounting program called Apex on it.
I would love to get the program running on windows xp but so far I have been unsucce...
Dear Experts.
I have several database files from 1996 that I need to open. These files have the extension PRG and BAK. I do not know the origninal program that was used to create these files...
HI,
I have the following code which is supposed to connect to a .dbf file and then update (i'm using test values) - first I got the error that the Jet engine couldn't find the table "WV_regio...
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...
I want to create MDX and CDX files of the a DBF file. Can any body help me how to do that?
I have tried to get this to work but it filters out everything instead of reporting everything. I checked the many different ways on this forum but get the same result whether I use a module ...
i have created a form with one textbox, one button and a datagirdview i want to connect dbf file with datagridview andfilter the records.
hi
Could somebody advise on quick and easy solution for using MYSQL / Delphi 2007
1) Which is the best way to connect to the database?
a) dbExpress. ( I have problems with on this on ...
