Load a Linked table into front end when switchboard starts

[smeghead67]

Greetings all,



In the database i created, I have an excel file that i have created a linked table for. What i use it for is the end users will enter a asset number and a macro in my form will do a DLookup to get a serial number from the table that matches the asset number. The excel file has much more info in it than is used, currently, in my data base. If i have the table open in my front end, the look up is instantaneous. If isn't, it will take over 30 seconds to come back with the data.

My question is, what do i do to make this linked table open when a user starts the front end of the database? can i make it load in the background? as it takes 30 seconds to load into the front end. I want this to be automatic so the end users do not have to manually do this.

Smeghead

[June7]

So, no matter what, will be a 30-second wait before user can proceed? Maybe either bind default open form to the linked Excel object or code behind the default form runs a query or DLookup.

[smeghead67]

June,

I forgot to mention that i tried putting a DoCMD.OpenTable in the "on load" property of the switchboard, access didn't like that very much. maybe i will put it into the on load of the form i need. I will let you know if it works.

Ted

[smeghead67]

Ok,

I put an event procedure into the "on Load" in the event tab of the property sheet.

Private Sub Form_Load()
DoCmd.OpenTable("MPI Game Master File", acViewNormal, acReadOnly)
End Sub

Gives me a syntax error.

Does any one have a suggestion?

Ted

[June7]

I tested OpenTable in a form load event and it worked just fine. Can't see any issue with your code syntax. The parens are not needed but did not cause me issue.

[smeghead67]

June,

I played with it and got it to work, here is what the final code looks like.

Private Sub Form_Load()
Dim Dumb As String
Dumb = "MPI Game Master File"
DoCmd.OpenTable Dumb, , acReadOnly
End Sub

I thought that the name of the table was causing grief, also i had the acview as the default, so i just left it blank to set it as default. This combination is making it work. The form doesn't display until the table loads.

Ted