access on server

[Chris]

Hello,

I have a database (version 2003) that has to be placed on a server. I split
the tables in a _be.file and made an mde.
Tables of the mde are linked to the _be.file.

On a PC with Access 2003 everything works fine. On a PC with Access 2007
some forms are not showing or are giving errors. The mdb and mde file work
fine in Access 2007. It is after linking the tables that the problems occur.

Can anyone give me a solution to solve this?

Thanks,
Chris

 

[Douglas J. Steele]

You'll need to supply more details. What kind of errors are you getting?
What action causes them?

For what it's worth, there's no reason for the back-end to be an MDE. MDEs
are intended for code, not data.

 

[Chris]

Doug,

The back-end is no mde. I have a file content.mde with the forms, queries,
etc and a file content_be.mdb with the tables. I guess this is correct?

The problem that I have is that one form (opened after clicking a button on
a start form) is perfectly showing when I use the original content.mdb, is
showing perfectly when I use content.mde but is not showing after I linked
content_be.mdb with content.mde. Debugging showed no errors.

On another form I get a parameter window asking for a reference to another
form (Forms!...). Here the same situation: no problems with the mdb or the
mde, only after linking mde and _be.

I hope this explains enough to help you find a solution.

Chris

 

[Douglas J. Steele]

Is the front-end located in a Trusted Location? (If you're not familiar with
what this mean, check what Jeff Conrad has at
http://accessjunkie.com/faq_01.aspx )

 

[Chris]

I'll have to check that. Will be somewhere this week. I'll get back to the
group if this doesn't solve the problem.
Thanks for the input.

Chris

 

[Tony Toews [MVP]]

Is the front-end located in a Trusted Location? (If you're not familiar with
what this mean, check what Jeff Conrad has at
http://accessjunkie.com/faq_01.aspx )

Note that the Auto FE Updater now allows you to set the target PCs
front end folder as an Access 2007 Trusted Location.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[zion gerald]

well thats what u think

 

[Chris]

meaning?

well thats what u think