• Porting MS Access database to SQL Server

    I've got a problem with porting my MS Access database to SQL Server. In my inventory database, I have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, I do with this kind of queries: a....

    Ipong40 pointsBadges:
  • MySQL Replication I think!

    Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front end at...

    Awestrope5 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Save or export VB 6 form

    Hi, I have a VB project which displays information from a MS Access database on textboxes and Labels for names and other calculation records. I would like to export the form containing these textboxes and lables filled with data from the MS access database to either PDF, doc or any other file type...

    Terdex10 pointsBadges:
  • What is the code that links VB 6.0 to MS Access and how to go about it?

    What is the code that links VB 6.0 to MS Access and how to go about it?

    nyaga135 pointsBadges:
  • MS Access DATABASE and combobox in VB6.0

    hellooo plz i need help  i am new to VB6.0 and i've learned alot now i have a database in MS Access and i want to create a combobox named (Combo1) that will be populated from the field (Name) in table (Customer) in the database (weighbridge.mdb) and then when i choose a name in the combobox i want...

    Ahedfares895 pointsBadges:
  • Deleting and redirecting a relationship in Access 2013

    I inherited a database that has a duplicate table and both tables are pointing to different things in the relationships. I would like to delete one of the tables and direct all relationships to the existing table.As it stands, I have to update both tables with the exact same information (the table...

    smithp15 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Converting from Access 2003 to Access 2007

    Hi everyone, I have 3 desktop with Access: One have Access 2003 two of them have Access 2007. So I divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop's. Because of that difference I convert for...

    BUG68235 pointsBadges:
  • Display data item which is start from Particular letter from database table in C# .NET

    In C# .NET (SELECT * FROM [tablename] where fristname LIKE 'k*') this query is not work with MS Access database.

    K1115 pointsBadges:
  • Access 2007 database query question

    I have imported a 2007 Excel spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd...

    JHartley10 pointsBadges:
  • Back-up copies of the database

    We have an access database that has multiple users for data entry. without fail, we end up with several "back-up" copies. Is this the result of the different users "saving" or is it from having shortcuts on their individual laptops?

    Joyrider64825 pointsBadges:
  • Access database table linked to Excel file question

    Can multiple instances of the same access database be open when linked to same excel file?

    SeenFresh25 pointsBadges:
  • How to change the location where JPG is looked for in ACCESS

    I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume somewhere the...

    Gingkobrother5 pointsBadges:
  • Exclusive access to Access 2003 database

    I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message "You do not have exlucive access to this database at this time." It pops up 4 to 6 times...

    Ryker5 pointsBadges:
  • Change user/file path in Access database

    My boss left and I took over her access database. When I try to pull the information from tables she created I get error that says"C:user****is not a valid path make sure path name correct or connected to server. How can I change the database to be "mine" so I can access the tables information?

    tkarp5115 pointsBadges:
  • export VB6 report in pdf format.

    I'm making a project in VB 6 using MS Access as a database. I'm making a report in crystal report and want to export that report in PDF format.

    Ambastha5 pointsBadges:
  • Multiple numbers for the same part in Microsoft Access

    I have 3 relating part numbers for the same part with the same description. How do I enter them into an Access DB for tracking?

    vaustin5 pointsBadges:
  • Calculating Exp. Dates in Microsoft Access

    I am creating a database for my boss that houses realty leases and I need to have a calculated field that will let me know 60 days before the lease expiration date.

    LaceyRae5 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following