CODEWITHSUNDEEP
databasems-accessvbams-access-2010
Noora No
Noora No

Reputation: 309

Access VBA error after splitting database

I have an Access database was created, it's working perfectly. After successfully splitting the database to back and front end I shared the _be file in shared drive and front end file in my local, I tried to run the front end and I am getting error when macro is executing:

Macro error

I even put the back and front end in my local machine but still I am getting the error, I tried to remove the macros but still getting errors since I am not the one developed this application.

Dim fdb As Database
Dim utab As Table, otab As Table
DBEngine.SystemDB = "System.mdw"
Set fdb = CurrentDb() 
Set utab = fdb.OpenTable("Users")
Set otab = fdb.OpenTable("Organization")

After tracing the function findorg() I found this error

Item not found in the collection

For this line

Set utab = fdb.OpenTable("Users")

I tried to change the code to be 

Set utab = fdb.Rescordsets("Users")

But still I am getting the same error.

Note that I am using back and front end, I have all my tables linked.

Upvotes: 1

Views: 728

Answers (2)

Noora No
Noora No

Reputation: 309

i was able to solve the issue by using DAO 3.6 object library, as i found that the current database application is using DAO 2.5, so i recompiled the application and fixed all errors. also i managed to rename the functions that's been called by macro, i found that in macro when i write calling function as findorg() will not work, but in function name i specify "findorg" between double quote, which run successfully.

Upvotes: 0

Manuel Castro
Manuel Castro

Reputation: 138

"Users" table is not linked in the database in which you are running this code. Link it again and check, check for all tables that should also be linked.

Upvotes: 0

Related Questions