• Import of Microsoft Access database file to SQL Server is slow

    I've noticed that there's an issue whenever I'm trying to import my Microsoft Access database file into SQL Server. My Access file has a ton of data but whenever I try to do the import, it takes a long time. Is there a way for me to speed it up? Thanks very much.

    ITKE976,675 pointsBadges:
  • SQL code for deleting Microsoft Access database rows

    I need to delete all of the content in several rows on a Microsoft Access database. How can I setup SQL to do this? I found this but I'm not sure if this works: Dim SqlQuery As String = "DELETE * FROM QuestionResults WHERE Quizname = " & txtQuizName.Text & ";" Can anyone help?

    ITKE976,675 pointsBadges:
  • Transfer data from SQL Server to Microsoft Access

    Hello, we need to move a large amount of data from a SQL Server database to a Microsoft Access database. The table structure is already setup. Is there anything from SQL I can use for the migration? Or do I have to use a ODBC data source? Thanks.

    ITKE976,675 pointsBadges:
  • Import Microsoft Access database into MySQL

    I'm currently on a Windows machine with a Microsoft Access database. I need to import that into MySQL on another Linux web server. Here's what I'm doing right now: Exported as text file Copied with FTP Loaded into MySQL Is there a better process for this? Any help would be appreciated.

    ITKE976,675 pointsBadges:
  • How to show last entry in data environment in Visual Basic 6 and Microsoft Access

    How can I show the last entry in a data environment. I'm using VB 6.0 and Microsoft Access in the back end.

    HARDIKJOSHI5 pointsBadges:
  • Run a macro on Access database on a server

    I need to run a macro in an Access database on a server. What do I need on server to run .mde? Do I need Access?

    saxmanmiller5 pointsBadges:
  • Exporting VB6 data to PDF using SQL select query from MS Access

    Hi my name is vishal. I think I have a problem in exporting VB6 data to PDF using SQL select query (join query from multiple tables). I have a form in which when user selects a GRNno from combobox and then press button with caption: Generate it should generate a PDF report regarding GRNno. Given...

    Ametuer30 pointsBadges:
  • Populate a Word document

    I have customer table and I have customer input form. I would like to populate a Word document (contract) and print that document from the add record screen from just hitting a button labeled print The specific form

    ase335925 pointsBadges:
  • MySQL: Look for top 3 in each group

    I know this has been discussed MANY MANY times, but I've used all the previous answers and still have issues. In my table we have to look for top 3 in each group and show ties. So if there is a tie it should return more than 3 rows. I have a working MS Access query, but MySQL doesn't use TOP and...

    DanielKYantis5 pointsBadges:
  • Create MDX file from Access database

    I want to create an mdx file for dbase from access database. How do I do that?

    thetcrew0045 pointsBadges:
  • Rename Microsoft Access table using VBA

    I'm sorry for the short question but does anyone know how I can rename a Microsoft Access table through VBA from Microsoft Excel? Appreciate the help.

    ITKE976,675 pointsBadges:
  • VB6 retrieving MSAccess all records in VB6 ComboBox

    Im beginner to VB6 and I have project to buildup company Database, I will be so grateful if anybody could help me in that: "How can I get all records of any field of MSAccess database in ComboBox or ListBox of VB6

    ScorpionEyes45 pointsBadges:
  • How to round in Microsoft Access and VBA

    By any chance does anyone know how to round in Microsoft Access / VBA? I figured out how to do it in Excel but I don't want to rely on that.

    ITKE976,675 pointsBadges:
  • Will streaming media work in a motorhome?

    I am new to Streaming.  A couple of questions.  How are my computers, VCR, and TV connected to the provider.  We are planning to buy a motorhome and need to know if this is a good solution to use on the road? Rex Ralston netrex@aol.com

    Rnetrex20045 pointsBadges:
  • Microsoft Access 2013 Search Box

    I created a search text box that is on a form off a navigation form. The problem I am having is that I get a box saying "Enter Parameter Value" Forms!2frmHomeOwnerMain!txtSearch. It works fine when I bring up the form by its self, but when it is in the navigation form it does not. I believe I need...

    fubr69z15 pointsBadges:
  • Filtering a Record Selector (Microsoft Access)

    I need help figuring out how to filter a combobox that serves as a record selector. I set up a box that provides clients name & need it to filter them by agents assigned to each customer once the filter is set but, i cant get it to filter out customers under other agents. I would prefer a...

    mmorrison35 pointsBadges:
  • Using LIMIT query in Microsoft Access 2007 database

    For Microsoft Access 2007 - I have created several queries in my database. But for some reason, it's giving me an error when I use LIMIT in my query. How can I correctly using LIMIT in my queries?

    ITKE976,675 pointsBadges:
  • Getting field names of Microsoft Access database table

    Would it be possible for me to get the field names of my Microsoft Access database table? Is there a SQL query I can use? Thank you.

    ITKE976,675 pointsBadges:
  • List Microsoft Access database tables using SQL

    Would there possibly be a way to list all of my tables in a Microsoft Access database using SQL? I know how to do it in SQL Server but not sure of the command in Access. Thanks!

    ITKE976,675 pointsBadges:
  • Compact Microsoft Access database in VBA

    My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

    ITKE976,675 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following