• Back end cloud solution for Microsoft Access

    For the past 5 years, our organization has used Access for its database. Now, we're look to keep the same database on the front end but switch to a cloud solution on the back end. We don't want Office 365 (too costly) / SharePoint so what's the best option for us? MySQL perhaps? Furthermore - we...

    ITKE440,735 pointsBadges:
  • How to implement middleware?

    We are building Android Mobile application and a server web application in PHP and Database in MySQL. We are going to host it online and release the app in Google store, since the number of users using the app is less at the begging, I’m confident that our client server model of implementation...

    vatsa133120 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Connecting SPSS to AS/400 DB2

    Hi I need to connect SPSS to AS/400 DB2 in order to run queries and get data. I try to connect using iSeries Access ODBC Driver I receive the following error: "Database connection failed. The driver may not be configured properly." I tried to connect to AS/400 from ACCESS and from iSeries Navigator...

    felixb95 pointsBadges:
  • Access Microsoft Access database using Python

    Would I be able to access my Access database using Python? If not, how about SQL? I'm looking for something within Linux but for a final option, Windows too. Appreciate the help.

    ITKE440,735 pointsBadges:
  • Uninstall Microsoft Access runtime through command line

    I know this is pretty old but we have Microsoft Access 2007 and that uses runtime. I'm in the process of upgrading several users to 2010 runtime but it's difficult since they are all located in different areas. Can I uninstall runtime through the command line? Thanks!

    ITKE440,735 pointsBadges:
  • Should I run a SQL view in my SQL Server database?

    For SQL Server, should I run a SQL view in my database? My friend told me to just run a stored procedure but I would rather run a view for security purposes. What should I do?

    ITKE440,735 pointsBadges:
  • SQL command for database recovery

    Does anyone know if there's any SQL command that can determine the recovery model of my SQL Server database? I'm trying to figure out if the database is in full recovery. Thank you very much.

    ITKE440,735 pointsBadges:
  • Public base domain database

    What is name of public base domain database?

    mrnazish5 pointsBadges:
  • Can I add file browser to Microsoft Access form?

    Can I add a 'browse' button to my Access 2007 from so that it brings up the file browser, followed by allowing the user to select the perspective directory? Also - when the user exits out of the browser, I need the path to be written to a text box in the Access form too. Thanks for the help.

    ITKE440,735 pointsBadges:
  • Megabytes for table storage

    If we need to store 100,000 records, what is the estimate size of megabytes needed?

    jrey32215 pointsBadges:
  • Generate a database schema level diagram like ERD for MM module in SAP

    How can I generate a database schema level ERD diagram? This diagram will show relationships between all tables in a schema like MM schema.

    gram7720 pointsBadges:
  • Corruption in Access 2010 databases?

    Hello - is anybody seeing frequent corruption problems in Access 2010? I work with 2 other developers, and we are seeing: tables losing indexes losing ALL the code modules (form & global) in accdb losing the accdb itself (not in the Recycle Bin, not in our user drives; just gone) That third one...

    wilfridsoyer5 pointsBadges:
  • Store MySQL query in Microsoft Excel

    I have a MySQL query and I need to store it in Excel. Here's the query I have: SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) How can I go about doing this? Thank you very much.

    ITKE440,735 pointsBadges:
  • Download a CSV app

    How can I download a csv. app?

    frharrison5 pointsBadges:
  • How to import data without exporting from the source database?

    How can I import data without exporting from the source database?

    payalshah5 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • How to structure a Microsoft Access combobox with four columns, two columns from one table and the other two columns from another table

    Sir, I have two tables: Quartier and street. I want a combobox that displays Quartier ID, quartier name, street ID and street name.

    beltibrightGods4lif5 pointsBadges:
  • VB.NET with MS access data type dismatch

    provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" datafile = "D:\weighment\weighment.accdb" connstring = provider & datafile myConnection.ConnectionString = connstring myConnection.Open() Dim str As String str = "Insert into WeighingData...

    aishjack45710 pointsBadges:
  • How to test or compare two cloud based databases one of them is replicated

    We are migrating from one cloud based database to another. We are replicating data and tabeles. How to test or compare both.

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