Search results for query: *

I'm trying to drop the Default on a field in my MSACCESS 2000 table Here is my Code: dbs.execute "ALTER TABLE tblJobs ALTER COLUMN JOBNoOnFile_R DROP DEFAULT" I'm getting syntax error and don't see why. Does anyone know what I'm missing Thanks for your help, LaDeana

I have a query which uses a formfields as it's parameter. I can use code to open this query docmd.openquery however, when I try to set it as a dao recordset, I get "Too Few Parameters expected Expected 2." I am using txtfromdate and txttodate from a form and the query runs great even in code...

I have some old foxpro 2.6 tables which need to be linked to my access db in code. I have an ado connection string which works for me to access the tables: "Provider=vfpoledb;" & "Data Source=W:\testf;" & _ "Mode=ReadWrite|Share Deny None; Collating Sequence=Machine; Password=''" Can I use...

I have developed a database with a sql server 2000 backend and now need my mac users to work with the data. Does anyone know if there are OLEDB drivers available for sql server which are compatible with Excel x? I would need to run stored procedures from Excel. Has anyone successfully used...

I am trying to link foxpro 2.6 free tables and their indexes in msaccess through code. (.dbf file and it's associated .cdx file) I'm able to link them using dbase IV however, the indexes will not update when deleting or adding records. I have tried to create an inf file which points to it's...

I am trying to link foxpro 2.6 free tables and their indexes through code. (.dbf file and it's associated .cdx file) I'm able to link them using dbase IV however, the indexes will not update when deleting or adding records. I have tried to create an inf file which points to it's cdx index...