IT SOLUTIONS
Your full service technology partner! 
PMartins [Unspecified] -Collapse +Expand
-Collapse +Expand
PMartins
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (7)

Search PMartins:

Advanced
Personal Account . . .
PMartins
Bath, UK



Real Name:  PMartins [Unspecified]
Primary Role:  Coder
Joined: Nov 2000 (21 years ago)
Visits: 10
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

7 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

PMartins
Access graphs & NT
We appear to have a problem with Access 97 graphs in NT4., One of our databases produces graphs in reports. The graphs work fine in Access 97 on Windows 98, and Access 2000 in Windows NT4., However, when producing the same report in Access 97 in Windows NT4, the reports either contain truncated graph elements, or no plotted data at all., , Because this database is used by a few different companies, we need it to work in these various combinations., , Can anyone suggest a reason for this happening?, Thanks.
Posted to MB Topic: MS Access Interactive « Access Board
20 years ago
Nothing New Since Your Last Visit
1891
Hits

Microsoft Access

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

PMartins
SQL Distinct Problem
We are in the process of upsizing our Access 2000 interface and database to SQL server., Our interface involves a fairly complex query which contains 33 tables., To use SQL server, we need to change the DISTINCTROWS clause in the query to DISTINCT, and a reference to 'False' to '0'., The query itself now runs fine in SQL server, but cannot be run from our mdb, returning an error of 'Query too complex'. Initial investigation seemed to point the finger at a 16 table limitation of ODBC V2, but having used the same syntax in an Access-Only environment, the same error is returned. This seems to suggest that the fault does not lie with ODBC, but with the syntax instead., Has anyone had any problems with the DISTINCT clause in an Access/SQL environment?, , Thanks,, Paul
Posted to MB Topic: MS Access Interactive « Access Board
20 years ago
Nothing New Since Your Last Visit
3215
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

PMartins
Database replication problems
We have a database which uses replication. A front-end for users, and a back-end for development. During the last sync, thousands of replication was created., We want to resolve the majority of those conflicts by using a delete query on tablename_conflicts. However, when we try to do this, running the query produces the error message 'operation must use an updatable query'., , Will deleting record in the tablename_conflicts tables resolve conflicts, and can a delete query be used to achieve this?, , ------------------, Paul Martins
Posted to MB Topic: Access News / Other « Access Board
20 years ago
Nothing New Since Your Last Visit
1842
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

PMartins
Database Pros and Cons
We have hit problems using Access 97 as a front end to our contacts database. The limitations are in the functionality within the constructed interface, not an issue such as too many records (Although speed is also an issue here). We are therefore looking to other types of front-ends to replace Access. , Could anyone provide any relative Pros and Cons to using... , , Access 2000 , FoxPro , Oracle Forms , VB6 , HTML + ASP , C++ , J++ , Delphi , , .. to construct the front-end interface. Any pointers would be gratefully received! , , Thanks, , Paul
Posted to MB Topic: DB Other & Misc. « DBA Board
21 years ago

Scott
{Too Long!}
20 years ago
Nothing New Since Your Last Visit
3914
Hits

DBA, Databases, & Data

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

PMartins
Re: Database Pros and Cons
{Too Long!}
Posted to MB Topic: DB Other & Misc. « DBA Board
21 years ago
Nothing New Since Your Last Visit
2
Hits

DBA, Databases, & Data
More...
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2021 Prestwood IT Solutions.   [Security & Privacy]