Losing link?

[Guest]

I have a database that has a frontend backend setup. I created these 2
databases from replicated databases importing all but the tables, and used
the query method to transfer the tables. What happens is that this VB
statement will work until I close and reopen the database:
Set rs1 = db.OpenRecordset("Notes", dbOpenDynaset)
Notes being one of the linked tables. After closing the first time I get an
error message :
Runtime error 3112 , records cannot be read, no read permission on notes.
If I refresh the links everything is again ok until I close and reopen.
Thanks for the help!!!

 

[david epsom dot com dot au]

Where are you gettting/setting "db"

(david)

 

[Guest]

In the line just before:
Set db = OpenDatabase(locFilePath_backEnd)
Set rs1 = db.OpenRecordset("Notes", dbOpenDynaset)

 

[Guest]

Try this:

set db = application.dbengine.opendatabase(

(david)

 

[Guest]

Thanks David! It worked.

Try this:

set db = application.dbengine.opendatabase(

(david)

 

[Guest]

I'm glad it helped :~)

I'm guessing that you are using user level security, and
that the problem happens at startup. In other places
in your code, it is probably not necessary to to use
the long form like that.

(david)