Access database of small procedures how to package release-CodePudding

access database of small procedures how to package release? When not to install access can normal use, thank you!!!!!!

CodePudding user response:

Feeling can't ah

CodePudding user response:

Ms have alone can release the Access Runtime, an exe, can be installed with their program, but not small volume, dozens of MB, can also use the BDE, it is recommended to use desktop database program, best transplanted into the firebird embedded SQL version, does not require any drive, and support for SQL, stored procedures, triggers, etc., good transplant to a large database,

CodePudding user response:

Using ado should not require other east east can access it

CodePudding user response:

Using BDE can connect directly to access files, data sets operation,

CodePudding user response:

Installed on the client machine access drive bai,

CodePudding user response:

reference liups reply: 3/f

use ado to should not need of others can access it

BDE is don't use, early jilted EM,,,

CodePudding user response:

Using ADO connection, generally don't have to install access database alone, because the operating system has MDAC, if for some reason is uninstalled, download a mount is),
The ans is doing just that a lot of small system,

CodePudding user response:

refer to 7th floor leeky response:

use ADO connection, generally don't have to install access database alone, because the operating system has MDAC, if for some reason is uninstalled, download a mount is),
We did a lot of small systems,

This is where a relatively complete answer, the other says one upstairs BDE also can access the access, but BDE need separate installation

CodePudding user response:

@ DelphiGuy

The firebird embedded SQL version, and SQLite, what's the difference? Which good?

CodePudding user response:

@ leeky

Access to more than 2007 version database can not install Access by MDAC software?

CodePudding user response:

The

references to the tenth floor u010165006 response:

@ leeky

Access to more than 2007 version database can not install Access by MDAC software?

I have not tried,
But: in order to move with the 2007 version?

CodePudding user response:

11 references liups response:

Quote: reference to the tenth floor u010165006 response:

@ leeky

Access to more than 2007 version database can not install Access by MDAC software?

I have not tried,
But: in order to move with the 2007 version?

After all, can't always use Access 2000 or 2003, the operating system upgrade,

CodePudding user response:

refer to 12 floor u010165006 reply:

Quote: reference 11 floor liups response:

The
Quote: reference to the tenth floor u010165006 response:

@ leeky

Access to more than 2007 version database can not install Access by MDAC software?

I have not tried,
But: in order to move with the 2007 version?

After all, can't always use Access 2000 or 2003, operating system, also the upgrade

You're just a MDB library files, has nothing to do with the upgrade

CodePudding user response:

reference 13 floor liups reply:

Quote: refer to 12 floor u010165006 reply:

Quote: refer to the 11 floor liups response:

The
Quote: reference to the tenth floor u010165006 response:

@ leeky

Access to more than 2007 version database can not install Access by MDAC software?

I have not tried,
But: in order to move with the 2007 version?

After all, can't always use Access 2000 or 2003, operating system, also the upgrade

You're just a MDB library files, has nothing to do with upgrade now

Also have MDAC win10 or after the system?

CodePudding user response:

On the 14th floor u010165006

reference response:

Quote: refer to the 13th floor liups response:

Quote: refer to 12 floor u010165006 response:

Quote: refer to the 11 floor liups response:

The
Quote: reference to the tenth floor u010165006 response:

@ leeky

Access to more than 2007 version database can not install Access by MDAC software?

I have not tried,
But: in order to move with the 2007 version?

After all, can't always use Access 2000 or 2003, operating system, also the upgrade

You're just a MDB library files, has nothing to do with upgrade now

Also have MDAC win10 or after the system?

I don't have pure win10 (installed office2003 and vc6), no mdac installed,
One of the most simple ado program set up by using the delphi7, access MDB, normal operation under win10
Connection string as follows:
The Provider=Microsoft. Jet. The OLEDB. 4.0; User ID=Admin; The Data Source=C: \ ado \ dbdemos MDB. Mode=Share Deny None; The Jet OLEDB: System database=""; The Jet OLEDB: Registry Path=""; The Jet OLEDB: Database Password=""; The Jet OLEDB: Engine Type=5; The Jet OLEDB: Database Locking Mode=1; The Jet OLEDB: Global Partial Bulk Ops=2; The Jet OLEDB: Global Bulk the Transactions=1; The Jet OLEDB: New Database Password=""; The Jet OLEDB: Create the System Database=False; The Jet OLEDB: Encrypt Database=False; The Jet OLEDB: Don 't Copy the Locale on Compact=False; The Jet OLEDB: Compact Without up Repair=False; The Jet OLEDB: SFP=False;

CodePudding user response:

reference 15 floor liups response:

Quote: refer to the 14 floor u010165006 response:

Quote: refer to the 13th floor liups response:

Quote: refer to 12 floor u010165006 response:

Quote: refer to the 11 floor liups response:

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull