A
ann
I used the database splitter to split my database in to a
front and back end. I am now having trouble referring to
recordsets that are in the back end. In a few part of my
database I used the following type of code:
Dim cnn As Connection
Dim rstRequest As New ADOBD.recordset
Set cnn = CurrentProject.Connection
rstRequest.Open "Request", cnn, adOpenKeySet,
adLockOptimistic, adCmdTableDirect.
cnn.BeginTrans
Now that I have split the database it is looking for the
table request in the front end but it is in the back end.
How do I change the connection to the back end?
front and back end. I am now having trouble referring to
recordsets that are in the back end. In a few part of my
database I used the following type of code:
Dim cnn As Connection
Dim rstRequest As New ADOBD.recordset
Set cnn = CurrentProject.Connection
rstRequest.Open "Request", cnn, adOpenKeySet,
adLockOptimistic, adCmdTableDirect.
cnn.BeginTrans
Now that I have split the database it is looking for the
table request in the front end but it is in the back end.
How do I change the connection to the back end?