Splitting database

[Kerri Storr]

Hi I hope someone can help.

I've recently split a datbase - not via the access function - I've manually moved the tables to a new db (location is \\kfn11\access\scripts\tables.mdb)

One of my forms currently uses a recordset, fomat as follows:

Dim inst As Recordset
Set inst = CurrentDb.OpenRecordset("tbl_problem_instance", dbOpenDynaset)

I know I have to replace the 'CrrentDB' bit, but each time I type the location string of my new db it wont work. I'm sure it's just a fromatting issue?

Any ideas?

 

[John.Woody]

Having split the db into FE and BE I take it you've attached the BE tables to the FE? If you have you could leave your code as was
Set inst = CurrentDb.OpenRecordset("tbl_problem_instance", dbOpenDynaset)
and it should still work

 

[Kerri Storr]

Hi, thanks for posting a reply.

Attach them how? I've been going into the queries / forms etc and changing the source db to the be. Is there a quicker way?

 

[wh00t]

File > Get External Data > Link Tables

then link all the tables and it should then be OK