Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,995 total)

  • Reply To: It Just Works

    call.copse wrote:

    Fair enough, these points I can accept. A good report designer needs to be bought for VS to make it usable for such purposes. Access doesn't do anything like...

    November 21, 2019 at 10:51 am

    #3699516

  • Reply To: Query tuning of SELECT

    I know this is blindingly obvious, but put a clustered index on the table (maybe on create_date) - then recompare

    you have no idea how many issues you can get into...

    November 21, 2019 at 9:15 am

    #3699497

  • Reply To: Verify your SQL Server database backups

    quite interesting - I've been using a low power server to do my DR testing - my databases get restored regularly but I've avoided checkdb purely on the amount of...

    November 21, 2019 at 9:01 am

    #3699493

  • Reply To: It Just Works

    @rod - where is the double facepalm emoji when you need to show your frustration at excel users?

    I'm glad you are looking at devops - if you haven't then get...

    November 20, 2019 at 4:38 pm

    #3699261

  • Reply To: The Conference Springboard

    I can't remember who it was (I think it might have been itzik ben-gan or Michael hotek) who presented a chess game in management studio - this was back at...

    November 20, 2019 at 2:43 pm

    #3699209

  • Reply To: It Just Works

    30 across our "zoo" of applications (they are all named after animals) - I have no idea how many - maybe 40 or so access frond ends (I still call...

    November 20, 2019 at 10:03 am

    #3699136

  • Reply To: It Just Works

    but how do you manage version control and merge changes for multiple developers?

    only one person can work on it at a time - and there is no way (that I...

    November 20, 2019 at 9:37 am

    #3699133

  • Reply To: It Just Works

    we have the same system - about 1000 ish people log in to many different access clients (stock control, despatch control timesheets etc)  - these are split across multiple shifts...

    November 20, 2019 at 9:19 am

    #3699128

  • Reply To: The Conference Springboard

    I think I might take your offer up on the article

    I would add that getting to a conference or even trying to speak can be career changing.

    I attended Data relay...

    November 20, 2019 at 9:06 am

    #3699125

  • Reply To: It Just Works

    WILLIAM MITCHELL wrote:

    We use the Access runtime on a terminal server as the front end, with a SQL Server back end. Each of the 100 users has their own copy of...

    November 20, 2019 at 8:53 am

    #3699118

  • Reply To: It Just Works

    GeorgeCopeland wrote:

    I have never done any development on Access, but I have sure been called to consult for a lot of Access applications. On many occasions, I have had the...

    November 19, 2019 at 4:23 pm

    #3698888

  • Reply To: It Just Works

    smiley coder, please don't tell me you used MIMS or any of my access databases for track inspections 🙂

    November 19, 2019 at 3:55 pm

    #3698875

  • Reply To: It Just Works

    roger.plowman wrote:

    Um, what? 🙂

    In terms of SQL language (as opposed to flow control and other non-SQL elements) Jet supports nearly as rich an array of language elements as SQL Server...

    November 19, 2019 at 3:34 pm

    #3698862

  • Reply To: It Just Works

    John N Hick wrote:

    roger.plowman wrote:

    But T/SQL *sucks* as a language, and having to learn two distinct languages to do a single project is insane.

    Wow.  One can do nearly everything except build windows...

    November 19, 2019 at 3:06 pm

    #3698846

  • Reply To: missing storage space

    the database size was from dbcc shrinkfile and the size on disk through RDP

    November 19, 2019 at 2:33 pm

    #3698832

Viewing 15 posts - 661 through 675 (of 1,995 total)