Access97: Combo Box and FE/BE split

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan Scott - 30 Mar 2005 03:58 GMT

I am trying to split my database into a front-end and a back-end.

I could not find a way to keep my forms' Combo Box as a Table/Query, as the
database has become remote and there is no way to make the Table/Query type
Combo Box query that other database.

So I decided to make it a Value-list Combo Box and query the DB, creating
the properly delimited string for the values to appear in that Combo Box. I
try running it, and what do I get? The string making up the values for the
Combo Box is too long!

Is there a better way to go about this? The only other way I can think to
keep my Combo Box as a Table/Query is to try and create a link locally to
the table I need before I open the form. Does anyone else know how to get
around this "too long" problem, or how to make Access97 use my string
despite its length?

Jonathan Scott

Reply to this Message

Larry Linson - 30 Mar 2005 05:29 GMT

In a split FE / BE environment, you link the Tables in the BE and use the
table name of the link. If, as many do, you name the table-link in your
database the same as the name of the table in the BE, it will simplify your
debugging. One way to handle the RowSource of Combo Boxes is to use a Query.

Larry Linson
Microsoft Access MVP

> I am trying to split my database into a front-end and a back-end.
>
[quoted text clipped - 14 lines]
>
> Jonathan Scott

Reply to this Message

Jonathan Scott - 30 Mar 2005 06:34 GMT

Many thanks!

I now realize one or more of my assumptions were incorrect. The size of the
database after the split led me to believe that the frontend was in fact
still holding the tables. I compacted it and it is now much smaller, as
would be expected. This will help greatly.

Now to figure out transactions in Access97... Any good resources on tactics
in using transactions in Access97? :)

Jonathan Scott

Reply to this Message