0

I am doing my A Level coding project in Visual Basic and the AQA requirements are that you should use an SQL database. I have looked online and have successfully setup SQLStudio in VB with no problems. It is a fantastic piece of software. However I am wondering whether using the third party software could somehow limit how capable the examiners see me as (since I am cutting out alot of work by using SQLS).

I am not using Excel in my project, I am going to build a modelling program that runs through Thomas Schelling's segregation model - and needs to save user settings and data.

Is there a way to use SQLite in VBA without using the third party software, and saving the db file locally - not on a MSQL or such server (since I don't have one).

Improve this question
12
  • 1
    That's SQLiteStudio, not SQLStudio. SQLite Studio is an application that allows you to manage SQLite databases the same way you would server-based databases. Just like any other application, it uses a driver as well. You don't need it to connect to open SQLite databases, you need the correct driver. Commented Jan 18, 2021 at 10:41
  • 1
    Why not use Access? It is an SQL database. You can write your project in ms access directly (which is the simplest way), or use excel vba (if you prefer) Commented Jan 18, 2021 at 10:49
  • 1
    @Proto VBA is a language only used for Office macros, especially Excel. If you have VBA questions, 99% of the answers will be for Excel. No other application uses VBA Commented Jan 18, 2021 at 10:56
  • 1
    The point I was making is that your local database file may be an access file: I wasn't suggesting for you to use its graphical user interface to build and manage your database. Using VB or VBA you can create an access database and then create and manipulate tables using SQL statements from within your VB/VBA code. Commented Jan 18, 2021 at 11:03
  • 1
    @SuperSymmetry thank you very much, this is what I was looking for Commented Jan 18, 2021 at 11:04
Related questions
12
Using SQLITE with VB6
0
sqlite and visualstudio
11
How do I access SQLite from VBA?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.