I have a legacy Delphi database, with an application written in Borland Pascal. It's an old system, running on a virtual XP box, since it won't run on anything newer.
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")
Good morning, I'm new here, live in Venezuela, glad to know about you, come here to solve a problem with a connection between a Visual Basic 6, and Sql Server 2000, converted my Access database to Sql database with Access, .adp, and move to Sql server 2000 with access2003.
Hello All, I am facing one issue like "External table is not in the expected format." with 2013 micro enable excel . when i am trying to open the connection string for reading the excel file i.e oleConn.Open(); .
I have an aspx web page that connects to an Access database through an ASP.NET connection string. The code works perfectly when I preview the page on my local machine. But I get this error when I publish the web site to a Windows server at my hosting company:
Hi, I have an Access database (.mdb) that has some tables which are native and some which are linked to an ODBC database (actually a remote SQLServer database)
Could you help me? I made a small webservice in c#, there is an oledb connection. The webservice is operate from developer tools perfectly, but in the IIS only appear, and the connection does not work.
How to write connection string to 2003 Excel file( .xls ) with Operating system 64 bits because the provider " Provider=Microsoft.Jet.OLEDB.4.0 " not exist in 64 bits OS.
I have a payroll system project with VB 6.0 and I want to connect it to Database (Access) that located in my office via Public IP. So, anyone can give me a code to connect that system to Database via Public IP ?
Here's the setup: MS Access has a linked table to SQL Server. SQL Server has a password on it. Trying to use Excel VBA to query this linked table in Access, but I can't get the connection string co
I've got an application in Visual Studio, that uses an Access database and I want to be able to save the database file on Dropbox. How do I get the connection string for an access database file locat
I've got an application in Visual Studio, that uses an Access database and I want to be able to save the database file on Skydrive. How do I get the connection string for an access database file loca
Sir, I am New in VB. I am using MS Access v2003 and VB v2008 I want Step by Step Help for Opening a password protected MS Access through VB.Net v2008. Please Help me in detail. Thanking You Saubhik
sir, The following is the extract written in the module . The access always failed when i tried to access ms access password protected database from within the visual basic 6. Displaying Datareport a