• WSgradyk

    WSgradyk

    @wsgradyk

    Viewing 15 replies - 1 through 15 (of 52 total)
    Author
    Replies
    • in reply to: Linking tables over network (Access 2000) #813690

      Thank you both – Hans and WendellB – The permissions on the folder are set as such that they have read/write access (ability to modify data and structure), however I noticed one problem that I’ve come accross before and that is I can’t get the “archive” check box cleared out – can that be a source of the problem. I have followed the whole root structure of what I want to share but it doesn’t seem to help. Have I lost you guys are am I totally on the wrong path.
      Thanks!
      Grady

    • in reply to: Linking tables over network (Access 2000) #813691

      Thank you both – Hans and WendellB – The permissions on the folder are set as such that they have read/write access (ability to modify data and structure), however I noticed one problem that I’ve come accross before and that is I can’t get the “archive” check box cleared out – can that be a source of the problem. I have followed the whole root structure of what I want to share but it doesn’t seem to help. Have I lost you guys are am I totally on the wrong path.
      Thanks!
      Grady

    • in reply to: Linking tables over network (Access 2000) #813420

      I’m not excatly what you mean by user permissions… the FE has not been compiled to a MDE and it has no restrictions on it? How do I check for “create” permissions.

      Thanks In Advance!
      Grady

    • in reply to: Linking tables over network (Access 2000) #813421

      I’m not excatly what you mean by user permissions… the FE has not been compiled to a MDE and it has no restrictions on it? How do I check for “create” permissions.

      Thanks In Advance!
      Grady

    • in reply to: Linking tables over network (Access 2000) #813418

      Hi Hans,

      When the user opens up the FE on the main computer it automatically links to the BE but no locked file is created for the BE?!? I’ve tested it out several times and it always does the same thing.

    • in reply to: Linking tables over network (Access 2000) #813419

      Hi Hans,

      When the user opens up the FE on the main computer it automatically links to the BE but no locked file is created for the BE?!? I’ve tested it out several times and it always does the same thing.

    • in reply to: Linking tables over network (Access 2000) #813360

      Hi Hans,

      Yes all users have read/write priviledges. What I discovered is that I have to open the BE.mdb file manually and force it to create an .ldb file and then it seems to work because if link into the BE on the main PC with the FE no .ldb is created? Why wouldn’t a direct link to the BE create the locked file?
      Thanks!
      Grady

    • in reply to: Linking tables over network (Access 2000) #813361

      Hi Hans,

      Yes all users have read/write priviledges. What I discovered is that I have to open the BE.mdb file manually and force it to create an .ldb file and then it seems to work because if link into the BE on the main PC with the FE no .ldb is created? Why wouldn’t a direct link to the BE create the locked file?
      Thanks!
      Grady

    • in reply to: running sum in a query (Access 2000) #790971

      Hi Hans, I went through those articles in fine detail but there is just something I’m missing because it is giving me just the overall balance in each record and not doing it on each ID field.
      Thanks in Advance and here is the SQL code where “acct-bank-Vystar chk9912” = table, and the [amount$] and [id] are fields in the query and in the table itself.

      SELECT [ACCT-BANK-Vystar CHK 9912].ID, Sum([ACCT-BANK-Vystar CHK 9912].[Amount$]) AS [SumOfAmount$], Format(DSum(“amount$”,”acct-bank-Vystar chk 9912″,[id]>0),”$0,000.00″) AS Balance, [ACCT-BANK-Vystar CHK 9912].Date
      FROM [ACCT-BANK-Vystar CHK 9912]
      GROUP BY [ACCT-BANK-Vystar CHK 9912].ID, [ACCT-BANK-Vystar CHK 9912].Date;

    • in reply to: running sum in a query (Access 2000) #790972

      Hi Hans, I went through those articles in fine detail but there is just something I’m missing because it is giving me just the overall balance in each record and not doing it on each ID field.
      Thanks in Advance and here is the SQL code where “acct-bank-Vystar chk9912” = table, and the [amount$] and [id] are fields in the query and in the table itself.

      SELECT [ACCT-BANK-Vystar CHK 9912].ID, Sum([ACCT-BANK-Vystar CHK 9912].[Amount$]) AS [SumOfAmount$], Format(DSum(“amount$”,”acct-bank-Vystar chk 9912″,[id]>0),”$0,000.00″) AS Balance, [ACCT-BANK-Vystar CHK 9912].Date
      FROM [ACCT-BANK-Vystar CHK 9912]
      GROUP BY [ACCT-BANK-Vystar CHK 9912].ID, [ACCT-BANK-Vystar CHK 9912].Date;

    • in reply to: won’t boot (XP professional) #762514

      I’m afraid you are correct in your diagnosis…..CTRL-ALT-DELETE doesn’t even work. Odd thing is I remember the last time I used this machine there was a lot of static electricity in the office….My Partner was assembling some of those Big Wheels in the office and everything I touched gave me a shock which has never, ever happened before . Can static electricity damage a motherboard?

    • in reply to: won’t boot (XP professional) #762515

      I’m afraid you are correct in your diagnosis…..CTRL-ALT-DELETE doesn’t even work. Odd thing is I remember the last time I used this machine there was a lot of static electricity in the office….My Partner was assembling some of those Big Wheels in the office and everything I touched gave me a shock which has never, ever happened before . Can static electricity damage a motherboard?

    • in reply to: won’t boot (XP professional) #762497

      Hi there, I am using regular PS/2 port mice so there’s no batteries involved. I have tried TAB or SHIFT-TAB but that doesn’t work either. Any Ideas?

      Thanks!
      Grady

    • in reply to: won’t boot (XP professional) #762498

      Hi there, I am using regular PS/2 port mice so there’s no batteries involved. I have tried TAB or SHIFT-TAB but that doesn’t work either. Any Ideas?

      Thanks!
      Grady

    • in reply to: Win98SE and XP networking #760973

      Thank You! I appreciate your reply.

    Viewing 15 replies - 1 through 15 (of 52 total)