[AccessD] Back from SQL Server

[Gustav Brock]

Hi Bob

You could even use the LocalDb:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15

https://www.mssqltips.com/sqlservertip/5612/getting-started-with-sql-server-2017-express-localdb/

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af Jim Dettman via AccessD
Sendt: 7. marts 2022 14:49
Til: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Emne: Re: [AccessD] Back from SQL Server


As with the others, I would suggest sticking with SQL Server, even on a single laptop.

While there is more involved with SQL, SQL today pretty much takes care of
itself.   The only thing you need to do is cap the memory available to it,
and setup a maintenance schedule.

Jim.

-----Original Message-----
From: AccessD On Behalf Of accesspro at cox.net
Sent: Monday, March 7, 2022 7:49 AM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Back from SQL Server

No
Not cost. Just simplicity. I anticipate running all of it on a single laptop.
I will ultimately gut a lot of the functionality.

thx

Bob


-----Original Message-----
From: AccessD <accessd-bounces+accesspro=cox.net at databaseadvisors.com> On Behalf Of Paul Hartland via AccessD
Sent: Sunday, March 6, 2022 8:14 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Paul Hartland <paul.hartland at googlemail.com>
Subject: Re: [AccessD] Back from SQL Server

Is it cost driving the decision back to access, can they not go to SQL Server Exoress ?

On Mon, 7 Mar 2022, 04:10 Stuart McLachlan, <stuart at lexacorp.com.pg> wrote:

> What sort of connection to the SQL Server (what driver?)
>
>
> On 6 Mar 2022 at 19:46, accesspro at cox.net wrote:
>
> > Hello to the list,
> >
> > A long time ago I did a pretty complex Access app.
> > The client went on later to have someone hook it up to SQL Server.
> > They now are scaling their biz back and wish to just use Access. I 
> > bet there is a way to "import" the tables back into Access, but I 
> > don't know how. Not too concerned about any views yet.
> >
> > TIA
> > Bob Heygood