Tag Info

New answers tagged

0

You can try "Viobo Access to MSSQL Data Migrator" https://www.cheapsoftwaremarket.com/products/business-finance/viobo-access2mssql.html I have used the demo version to convert small Access 2003 file to MSSQL 2005, it was OK. I don't know if it does support MSSQL 2014, but you can try.


0

If you go to the DATA tab, there is an icon labelled "Connections". If you click on that, you get a list of connections and you can delete the one called evec_api_map.


0

What about DB Browser? http://sqlitebrowser.org/ For Windows and Mac (screenshot - dmg)


2

Assuming that you have 32GB of Memory allocated to Redis and other memory available to your system resources, you can calculate the number of entries you can store. However, keep in mind that this is extremely generalized as there is always some sort of overhead. Regardless, if you look at the pure number of entries from a math perspective, you could store ...


0

Daily backups with truncate were already in place, Apparently my solution is to make the log file significantly larger in hopes that I won’t have to schedule multiple truncates during the day.


1

As a general rule, you should only really use clustered indexes for Identity fields, and autonumbers are the best, since they are ever increasing. Updating an identity column is somthing you should do about once every millenia, and certianly not at application runtime, so you should never have to reorder page contents via a standard DML statement. Within ...


1

You are not following best practice for SQL. I am assuming it is also running on a domain? Never run SQL service with Network service or local service. create a basic AD user or local user if no domnain (NOT ADMIN ACCOUNT) and run the SQL service as this user: Please see below from technet: User cannot create new database when SQL Server 2012 services ...


0

First install the MySQL ODBC driver. 5.1 or 5.2. I like to set it up for unicode. Then get the MySQL server running. Then from Access: New | Link table | ODBC | MySQL5.1 or MySQL5.2 ODBC Driver and select the base and table you want to link to. (There is better documentation elsewhere, and you will probably need to consult it, but this is the nuts and ...


0

It's better to import the text files from within MariaDB itself. You can use either mysqlimport [OPTIONS] database textfile ... or LOAD DATA INFILE 'file_name' INTO TABLE tbl_name ... for this purpose. References: mysqlimport and LOAD DATA INFILE


-2

set theOutputFolder to choose folder with prompt "Please select an output folder:" tell application "Database Events" make new database with properties {name:"Test", location:theOutputFolder} save database "Test" end tell Add the save command to save your new database. It will then be visible in Finder.



Top 50 recent answers are included