Split Database

[injanib]

Hi,



This may be a silly question, but I am curious.
When a database is split, the back-end is placed in a centralized location and the front-end on the individual work stations. Say for example the current event of a form is running a code that is supposed to look at the current database's path using currentproject.path. I know that the code will be executed from the workstation where the front-end is open, but is it going to look at the path name of where the back-end is located? Because it is supposed to look in a folder that is in the same directory as the back-end.

Thanks.

[RuralGuy]

I think you should try asking that question another way. Sorry, but what you asked does not make a lot of sense to me. What are you trying to accomplish?

[injanib]

Thanks,

I think I will experiment what I am trying to do hands on and then share the results.

[Dal Jeanis]

The path name from the front end to the back end is not going to be relative to the front end - it's an absolute path.

Also, generally, there's a "current" version of the front end that's stored "near" the back end. That way the active front end can check itself against the "current" front end to see if it needs to be updated.

Hope this helps.

[June7]

CurrentProject.Path will be the path of the frontend because that's where the code is running.

I use UNC to reference backend path in VBA code: \\server name\folder path