Results 1 to 4 of 4

Thread: Access 2003 Compact networks and central database

  1. #1
    Join Date
    May 2008
    Posts
    38

    Access 2003 Compact networks and central database

    I know very little SQL.
    I built an Access 2003 which I put in a network using the access runtime installed on all workstations.
    So I have a ridge on a network drive and a front on display in various posts and seizure (approximately 10).
    I compacted the dorsal one evening checking first no.
    Since there are error messages with "-1547 ..." indicating that the error is unknown and it blocks the macros.
    I reset the linked table but in some cases, it still does not work. I am sure it is related to compaction. What to do? With the runtimes, I am forced to reinstall the local databases on items not equipped with Access.
    I also think that there is a bug in Access because I do not see why it works once then it goes ... Did you notice? Thank you for your help.

  2. #2
    Join Date
    Apr 2008
    Posts
    2,565

    Re: Access 2003 Compact networks and central database

    What version of Access is installed on the client?

  3. #3
    Join Date
    May 2008
    Posts
    38

    Re: Access 2003 Compact networks and central database

    most users are on the Access2003 runtime to save the purchase of licenses.
    The runtime does not suffice when action on the base itself to create tables.
    I have created forms before and until I compact it worked well.
    In fact, I think that compaction cut links between the foundation and basis frontal dorsal compacted.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,565

    Re: Access 2003 Compact networks and central database

    Yes indeed. In access, it is best to avoid using compaction.
    I believe that there are only two solutions:

    1) you use a name compacted
    2) if you want to compact the database, the client must have Access installed.

Similar Threads

  1. Replies: 3
    Last Post: 11-12-2010, 11:45 PM
  2. Open and print Access Database without access?
    By Boagrius in forum Software Development
    Replies: 6
    Last Post: 28-08-2010, 11:28 PM
  3. Replies: 4
    Last Post: 16-02-2010, 08:13 PM
  4. Replies: 2
    Last Post: 28-06-2008, 11:22 PM
  5. convert filemaker pro database to access database
    By Czack in forum MS Office Support
    Replies: 3
    Last Post: 15-04-2007, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,717,394,564.51402 seconds with 16 queries