RE: argument style, was Re: Access Database Replication

2010-09-09 Thread Greg Keogh
splort hundreds? influential? worldwide? (apologies for all those questionmarks, to whomever was commenting on them t'other day It pleases me to imagine this is true – Greg

argument style, was Re: Access Database Replication

2010-09-08 Thread silky
On Thu, Sep 9, 2010 at 10:05 AM, Arjang Assadi arjang.ass...@gmail.com wrote: [...] Allowing people to directly play with data nullifies any attempt of forcing business rules in a system. It's interesting. Nobody said anything about this. Yet, you are refuting what is arguably 'common sense',

Re: argument style, was Re: Access Database Replication

2010-09-08 Thread silky
This is a good read on the subject: http://www.xent.com/pipermail/fork/2001-June/000438.html (relevant to a specific mailing list but generally applicable). I appear to be currently engaged in The Level Lunge. -- silky http://dnoondt.wordpress.com/ Every morning when I wake up, I experience an

Re: Access Database Replication

2010-09-08 Thread Arjang Assadi
David, I have found your rant both educational and informative. I had not considrered such a situation.The situation you described does make Access the correct choice (at least for now, not sure what would happen when the business grows but who does anyway?) I would use That Depends in Access

Re: argument style, was Re: Access Database Replication

2010-09-08 Thread DotNet Dude
You're crazy silky :-) On Thu, Sep 9, 2010 at 10:41 AM, silky michaelsli...@gmail.com wrote: This is a good read on the subject: http://www.xent.com/pipermail/fork/2001-June/000438.html (relevant to a specific mailing list but generally applicable). I appear to be currently engaged in The

Re: argument style, was Re: Access Database Replication

2010-09-08 Thread KO CHANG
Here is my +1. On Thu, Sep 9, 2010 at 10:53 AM, David Burela david.bur...@gmail.comwrote: Here is another idea. Instead of focusing on argument styles, how to troll correctly, etc. How about we just stop attacking people on this mailing list and just talk tech. I talk to a lot of people

Re: argument style, was Re: Access Database Replication

2010-09-08 Thread silky
On Thu, Sep 9, 2010 at 10:53 AM, David Burela david.bur...@gmail.com wrote: Here is another idea. [... amusing irony ...] FYI, I've asked David to discuss this with me offlist (assuming he is talking about me). I won't comment further on the matter on the list. I suppose my last comment would

Re: argument style, was Re: Access Database Replication

2010-09-08 Thread silky
On Thu, Sep 9, 2010 at 12:52 PM, Les Hughes l...@datarev.com.au wrote: [...] We should just settle this like fine grown gentlemen a punch-on at the 'Nerd Violence Dinner' tonight in Melbourne. While I know you and know this is meant as a joke, legitimate threats of physical violence from

Re: Access Database Replication

2010-09-07 Thread Arjang Assadi
¿ʇnoqɐ buıʞןɐʇ sʎnb noʎ ǝɹɐ ʇɐɥʍ On 7 September 2010 15:46, silky michaelsli...@gmail.com wrote: On Tue, Sep 7, 2010 at 3:43 PM, mike smith meski...@gmail.com wrote: On 7 September 2010 15:15, silky michaelsli...@gmail.com wrote: On Tue, Sep 7, 2010 at 3:09 PM, mike smith meski...@gmail.com

Re: Access Database Replication

2010-09-07 Thread David Burstin
On Tue, Sep 7, 2010 at 4:23 PM, Peter Griffith pgrif...@senet.com.auwrote: Les, ConvertU2 has developed an app to convert (migrate?) Access applications to SQL Server. The Microsoft Migrate tool and SSMA only migrate tables and don't do that all that well. Doesn't

Re: Access Database Replication

2010-09-07 Thread Arjang Assadi
How many forms are we talking about here? On 7 September 2010 12:32, Les Hughes l...@datarev.com.au wrote: Hi All, I've got a legacy MSAccess app in VBA which is been used at two separate office locations (Melbourne Singapore), with two separate copies of the database. There is a table

RE: Access Database Replication

2010-09-07 Thread Ian Thomas
Australia -Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Les Hughes Sent: Tuesday, 7 September 2010 11:36 AM To: ozDotNet Subject: Re: Access Database Replication Ian Thomas wrote: What are the problems of putting the MDB back-end

Re: Access Database Replication

2010-09-07 Thread Les Hughes
Ian Thomas wrote: Les You could always suggest some separation of the 'common' info for each client office, and create additional and separate Melbourne-only and Singapore-only tables. Over years, I've done a lot of migration of databases / info systems to and from Access. Often, the clients

Access Database Replication

2010-09-06 Thread Les Hughes
Hi All, I've got a legacy MSAccess app in VBA which is been used at two separate office locations (Melbourne Singapore), with two separate copies of the database. There is a table with 5,000 rows in it (about 30 columns) which has inserts/updates at both offices, and we were looking for

RE: Access Database Replication

2010-09-06 Thread Ken Schaefer
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Les Hughes Sent: Tuesday, 7 September 2010 10:33 AM To: ozDotNet Subject: Access Database Replication Hi All, I've got a legacy MSAccess app in VBA which is been used at two separate office locations (Melbourne Singapore), with two separate

Re: Access Database Replication

2010-09-06 Thread Craig van Nieuwkerk
Ideally, we would either migrate the app to .NET/SQL Server (which would be fairly expensive... management say 'grrr'), or use RDP and having the app on one computer. (which is also for some reason is also 'g') Is the cost of SQL due to license issues or redevelopment costs? If it is a

Re: Access Database Replication

2010-09-06 Thread Les Hughes
Craig van Nieuwkerk wrote: Ideally, we would either migrate the app to .NET/SQL Server (which would be fairly expensive... management say 'grrr'), or use RDP and having the app on one computer. (which is also for some reason is also 'g') Is the cost of SQL due to license issues or

Re: Access Database Replication

2010-09-06 Thread David Burstin
On Tue, Sep 7, 2010 at 12:44 PM, Les Hughes l...@datarev.com.au wrote: Redevelopment costs I've heard you can throw SQL Express directly on the back of an Access App (Access 2003), has anyone had any success with this? Yes. The current project I am on did exactly this. We set up the SQL

RE: Access Database Replication

2010-09-06 Thread Ian Thomas
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Les Hughes Sent: Tuesday, 7 September 2010 10:33 AM To: ozDotNet Subject: Access Database Replication Hi All, I've got a legacy MSAccess app in VBA which is been used at two separate office locations (Melbourne Singapore), with two separate

Re: Access Database Replication

2010-09-06 Thread Les Hughes
Ian Thomas wrote: What are the problems of putting the MDB back-end in the cloud (using the term loosely)? Surely both ends have a permanent always-on internet connection? I think there is some data they don't want shared between the offices? No idea really. This is one of those

Re: Access Database Replication

2010-09-06 Thread mike smith
On 7 September 2010 15:01, noonie neale.n...@gmail.com wrote: Greetings, On 7 September 2010 13:36, Les Hughes l...@datarev.com.au wrote: Ian Thomas wrote: What are the problems of putting the MDB back-end in the cloud (using the term loosely)? Surely both ends have a permanent always-on

Re: Access Database Replication

2010-09-06 Thread silky
On Tue, Sep 7, 2010 at 3:09 PM, mike smith meski...@gmail.com wrote: [...] Probably why some people have stopped asking me questions :-P And the downside is? That looks suspiciously like a question, meski. -- Meski Going to Starbucks for coffee is like going to prison for sex. Sure,

Re: Access Database Replication

2010-09-06 Thread noonie
On 7 September 2010 15:09, mike smith meski...@gmail.com wrote: On 7 September 2010 15:01, noonie neale.n...@gmail.com wrote: Greetings, On 7 September 2010 13:36, Les Hughes l...@datarev.com.au wrote: Ian Thomas wrote: What are the problems of putting the MDB back-end in the cloud

Re: Access Database Replication

2010-09-06 Thread mike smith
On 7 September 2010 15:15, silky michaelsli...@gmail.com wrote: On Tue, Sep 7, 2010 at 3:09 PM, mike smith meski...@gmail.com wrote: [...] Probably why some people have stopped asking me questions :-P And the downside is? That looks suspiciously like a question, meski. ¿sorry?