Click here to Skip to main content
15,503,143 members
Home / Discussions / Database
   

Database

 
GeneralRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 6:57
professionalEddy Vluggen21-Aug-22 6:57 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 10:20
Calin Negru21-Aug-22 10:20 
GeneralRe: how a data base file works Pin
Eddy Vluggen22-Aug-22 9:04
professionalEddy Vluggen22-Aug-22 9:04 
GeneralRe: how a data base file works Pin
Eddy Vluggen22-Aug-22 9:22
professionalEddy Vluggen22-Aug-22 9:22 
QuestionOLE DB provider Pin
suren ramakrishnan18-Aug-22 22:16
suren ramakrishnan18-Aug-22 22:16 
AnswerRe: OLE DB provider Pin
Richard MacCutchan18-Aug-22 22:31
mveRichard MacCutchan18-Aug-22 22:31 
AnswerRe: OLE DB provider Pin
RedDk19-Aug-22 14:14
RedDk19-Aug-22 14:14 
QuestionReplacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik7-Aug-22 5:00
Nick Katditsik7-Aug-22 5:00 
We use a legacy application (vb6 / access). The UI uses DAO to connect to the local front-end MDB file. Local tables are linked to the back-end mdb file which is located on the server.
So far so well.
The problem is that the back-end MDB is now 1,8 Gb and it will be 2 Gb pretty soon, which is fatal in MS-Access world.

We're thinking of replacing the back-end db with sql server express, so we'll have to make minimal changes to the front-end databases (just the connection string).

Is it a good idea? What is the correct procedure to import the back-end MDB to SQL server express? Which version (LocalDB etc) should we use?

Thanks in advance.

PS
There is no option of making/buying a new application. We are trying to solve our problem with minimum effort.

modified 9-Aug-22 4:10am.

AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Mycroft Holmes7-Aug-22 13:44
professionalMycroft Holmes7-Aug-22 13:44 
GeneralRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik8-Aug-22 6:42
Nick Katditsik8-Aug-22 6:42 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Richard Deeming7-Aug-22 22:50
mveRichard Deeming7-Aug-22 22:50 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 6:07
Nick Katditsik17-Aug-22 6:07 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Craig Robbins17-Aug-22 7:53
Craig Robbins17-Aug-22 7:53 
AnswerRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
CHill6017-Aug-22 8:00
mveCHill6017-Aug-22 8:00 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 20:46
Nick Katditsik17-Aug-22 20:46 
QuestionHow would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 8:18
professionalJoan M6-Aug-22 8:18 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Gerry Schmitz6-Aug-22 9:06
mveGerry Schmitz6-Aug-22 9:06 
GeneralRe: How would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 13:08
professionalJoan M6-Aug-22 13:08 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Mycroft Holmes6-Aug-22 13:48
professionalMycroft Holmes6-Aug-22 13:48 
Questionsql query problem Pin
pitwi28-Jul-22 0:06
pitwi28-Jul-22 0:06 
AnswerRe: sql query problem Pin
Richard Deeming28-Jul-22 0:54
mveRichard Deeming28-Jul-22 0:54 
GeneralRe: sql query problem Pin
jsc4217-Aug-22 7:20
professionaljsc4217-Aug-22 7:20 
GeneralRe: sql query problem Pin
Richard Deeming17-Aug-22 7:26
mveRichard Deeming17-Aug-22 7:26 
GeneralRe: sql query problem Pin
jsc4217-Aug-22 23:40
professionaljsc4217-Aug-22 23:40 
Question.sql script in c# Pin
Member 1373522830-Jun-22 3:15
Member 1373522830-Jun-22 3:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.