Search results for query: *

I'm looking at setting up a test with an SQL 2008 Express. Company is looking at finding the best solution to extract data daily from a pervasive database (Timberline) to an SQL database. I have SQL 2008 express and managed to create a LInKED server to the pervasive database. Basically, need...

One other note... Should mention i'm using SQl Express 2008 for the testing with the Import and Export Feature.

When tryying to use the Data Import export feature, i recaive the final error for each table: dbo.<tablename> "Cannot Find Column -1" I'm using the .net framework provider for ODBC (as for seems like the Pervasive interface doesn't work) I select the ODBC Connection to the Pervasive Database...

Looks good, tested this and it seems to do the job. Thank you both, RMc

Thanks for the info, I wasd looking for a more complicated solution.. could be as simple as this. My only problem now is the Cancel = true. I have this in the print detail section. It doesn't stop the printing... it loops all through the recordset and prints/displays the 5 records and leaves...

I have a report that pulls up equiopment info. Within this report, there is a subreport that pulls up all maintenance info for that piece of equipment. There may be up to 100+ records, though I only want to print 5. The sub report on the main report it linked by the master and child field. (The...

Finally foud it with the assistance and direction from the forums. Code used was: Set G_Workspace = DBEngine.Workspaces(0) Set G_Database = G_Workspace.OpenDatabase(G_DatabaseName, False, False, "MS Access;PWD=" & G_password) You need the readonly and options declared as per MS Arcticle...

I've been trying to open a password protected MS Access database from Excel VBA. I've been using the following code to open nonm password protected database with out an issue. Is there an additional perameter that I need to add? Here is the partial code: Set G_Workspace =...