Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    11

    Exclamation Unanswered: Linked table RecordSet Problem

    Access 2000,2003 cannot open the recordset on the SourceTable (being a linked table) using this code below:

    Dim QNumber As Integer
    Dim rst As Recordset
    Set db = CurrentDb

    Set rst = db.OpenRecordset("SourceTable", dbOpenTable)
    QNumber = rst.RecordCount

    I have a code that creates a new table and inserts records from the source table randomly into this new table. The database worked well. But Because of security reasons I have had to split the database tables into Front-End and Back-End using Database Splitter. Now it doesn't work.

    Can someone please help me change this code to make it compatible with a linked table?

    Thanks,

    Sudney

  2. #2
    Join Date
    May 2004
    Posts
    65

    Question

    Is the table already linked to your front end?

  3. #3
    Join Date
    Nov 2003
    Posts
    11

    VB does not see any questions

    Yes, I have split the database and see the arrow next to the table which tells me the table is linked. I can also click on the table and all the data is present. But VB does not see any questions? Any suggustions?

    Thanks,
    Sudney

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •