database connection error

[agosfernandes]

Hi!



I've created a database and all was working to the perfection... in my desktop!
Once I've split it (one file without any tables, just forms, reports, etc. and another with the tables only) in a network folder I'm getting the yellow VBA color highlight in this line:

Set rs_users = db.OpenRecordset("Users", dbOpenTable)

Do I need to change the database path somewhere??

Thank you!

[agosfernandes]

Nevermind... figured it out.

Just needed to define its path: OpenDatabase("Q:\...

Thanks anyway

[Bulzie]

Might need to see all your code. From your FE databases(one with forms), click on your linked tables to make sure you have a good connection. Go to the top of the code window, hit Debug and Compile and see what message it gives you. Also if you get no message but code just stops, could be bug so just copy that link of code, Delete the line of code, hit Save. Then copy that line back and do debug/compile again and save, etc. Try it again.

[agosfernandes]

I believe I fixed the problem:

just needed to fix the database tables location like this:

Set db = OpenDatabase("C:\Path\To\Database.accdb")

instead of just:

Set db = CurrentDb

I am still checking the whole db

Thanks for your help!