Search:

Type: Posts; User: Dylan Morley; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    1,885

    Re: MDB File Version (Jet)

    If in use by another user, then it will error & write info to log file. Unlikely tho, we're going to be running this overnight as a service (We've told users again & again 'compact your databases',...
  2. Replies
    9
    Views
    1,885

    Re: MDB File Version (Jet)

    Managed to do it with a bit of error handling;

    Try and compact with the Jet OLEDB:Engine Type=4 argument (Jet 3.X), if this errors (would for Access 2000) then try again with Jet OLEDB:Engine...
  3. Replies
    9
    Views
    1,885

    Re: MDB File Version (Jet)

    Hmmm....I'd have to create a connection to the db to determine that tho, would be too resource hungry for what my app is doing. Was hoping for an API of some sort...

    Thanks anyway.
  4. Replies
    9
    Views
    1,885

    MDB File Version (Jet)

    Is there any way to programatically determine the version of an .mdb file??

    I'm writing a database compacter program that scans our network and compacts databases that it finds. The problem is...
  5. Replies
    2
    Views
    1,064

    Re: Form & Subform 'Undo' (Access 2000)

    Thanks for the links Hans, very helpful.
  6. Replies
    2
    Views
    1,064

    Form & Subform 'Undo' (Access 2000)

    I have a main order form and it contains a sub-form with a number of the order details. The form & it's contorls are bound to a datasource.

    There's a 'Cancel & Exit' command button that basically...
  7. Re: Access Project Security (Access 2000 / MSDE)

    Thanks for reply...

    Yes, it's an ADP file, backend is MSDE for this db, but I do have the Enterprise version of SQL Server (and all client tools) for some other systems I administer.

    I'm just...
  8. Access Project Security (Access 2000 / MSDE)

    I've developed a client / server access project with an MSDE back-end. I'm launching the database via a shortcut as follows...

    "C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE"...
  9. Replies
    2
    Views
    2,632

    Re: Showlevels (Excel VBA)

    Thanks, I'll give this a go...
  10. Replies
    2
    Views
    2,632

    Showlevels (Excel VBA)

    I have some code that shows data to a certain level in an Excel sheet...

    ExcelObject .ActiveSheet.Outline.ShowLevels RowLevels:=4

    4 used to be the second to last level of detail, 5 would...
  11. Re: Access in Thin Client Environment (Access 2000 / Citrix XP MF)

    Thanks for responses people...

    Mark - yes, we have an application that does all of our database launching. Whenever they launch a DB from it, it will copy a new front end to a directory local to...
  12. Re: Access in Thin Client Environment (Access 2000 / Citrix XP MF)

    Wendell,

    Thanks for the reply....

    Yes, our databases are split into FE/BE, we're experiencing corruption in the back-end of the databases. We also have a single workgroup that we are using for...
  13. Re: Access in Thin Client Environment (Access 2000 / Citrix XP MF)

    Thanks Charlotte, but how would this stop Access database corruption?? Does this driver cause problems under thin-client?
  14. Access in Thin Client Environment (Access 2000 / Citrix XP MF)

    Has anyone had any experience of using Access under a thin client environment?

    We're using a number of multi-user Access applications and we're constantly getting corruptions. This seems to be an...
  15. Replies
    2
    Views
    268

    Re: Form Behaviour (Access 2000)

    Thanks Dave...!
  16. Replies
    2
    Views
    268

    Form Behaviour (Access 2000)

    We've just upgraded to Access 2000 & a few users are complaining that each form they open creates another 'window' on their toolbar or running applications. I suppose you can get round by closing...
  17. Replies
    10
    Views
    1,362

    Re: Force Disconnect (Access 2000)

    Thanks Charlotte, I think I'm going to try and write some sort of COM DLL to do this....if I have any joy I'll make the source available...!

    It's even more of a nightmare in our company at the...
  18. Replies
    10
    Views
    1,362

    Re: Force Disconnect (Access 2000)

    Thanks Hans, that's a better version of what I was going to write...!!

    You would've thought an admin tool for doing this would've been shipped with Access...?!
  19. Replies
    10
    Views
    1,362

    Force Disconnect (Access 2000)

    Is there any way to force all connections to a back-end database to be dropped?

    We have a network database back-end and an MDE distributed to multiple clients. The database BE has become...
  20. Replies
    7
    Views
    1,147

    Re: Duplicate Primary Key (Access 97)

    Yes, the database is compacted when the VB application is first opened & no other users are connected.

    We do have version / OS issues in the company. Some of our users are on thin-client Citrix...
  21. Replies
    7
    Views
    1,147

    Re: Duplicate Primary Key (Access 97)

    The field is unique. That's the dilemma
  22. Replies
    7
    Views
    1,147

    Duplicate Primary Key (Access 97)

    I have a vb application with an Access 97 db backend. There are 3 main tables in the application for Order details, Catalogue information & Order quantity info...

    In the catalogue table...
  23. Re: Database Conversion (Access 97 > Access 2000)

    Have tried with a few databases and seems very good...

    My only moan is that it only returns TRUE or FALSE, in the case of FALSE I would want to know why it failed (security etc). But it's going to...
  24. Re: Database Conversion (Access 97 > Access 2000)

    Was toying with my own conversion program but this looks like exactly what I need. I'll test this today & let you know how I get on, many thanks for finding....
  25. Replies
    6
    Views
    1,998

    Re: Syntax of Update Statement (VB6)

    As far as I can see, there are 3 objects expected in this statement (cnAdmin, SysDefaults & tblPath). Are all 3 supposed to be objects (tblPath.StoredPath ??) and are they all valid within the scope...
Results 1 to 25 of 116
Page 1 of 5 1 2 3 4