Compile errors (1 Viewer)

harrisw

Registered User.
Local time
Today, 04:57
Joined
Mar 27, 2001
Messages
131
Have an access database with a front and back end.

Front end holds forms etc and sits on each local pc and the backend sits on a network server.

Most of the users are working ok bar 2 they recieve compile errors.

When the database starts it runs an autoexec macro that basically checks version tables in the front and back end to make sure they corrispond. If they don't the user is prompted to update the database.

When this autoexec macro runs the error occurs and the debug immediately points to the statement

Set rstVerTabFE = CurrentDb.OpenRecordset("Version")
Set rstVerTabBE = CurrentDb.OpenRecordset("VersionBackEnd")

and highlights the currentDB funtion.
If I remove the autoexec the same happens when the user hits another process that uses the current DB function

I've checked references and nothing is missing.

Its appear to be pc specific as if I try to logon to the database on the pc I get the same error yet I work fine any where else

Any ideas?
 

harrisw

Registered User.
Local time
Today, 04:57
Joined
Mar 27, 2001
Messages
131
The exact error that appears is

function or interface marked as restricted or the function uses an automation type not supported by visual basic.
 

BukHix

Registered User.
Local time
Today, 00:57
Joined
Feb 21, 2002
Messages
379
Did you ever get this solved? The error just popped up for me on one of my client machines. The CurrentDb.OpenRecordSet is tripping it up also. I haven't found anything helpful in the KB database and am now searching this forum.
 

Users who are viewing this thread

Top Bottom