Re: MDE not possible ?

Alright that must be it then :)

Thank you !

Rob.

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> schreef in bericht
news:u9TcAyS7GHA.3836@xxxxxxxxxxxxxxxxxxxxxxx
The default file format for Access 2003 is actually the Access 2000 file
format. If your database is in Access 2000 file format (it should say on
the database window), Access 2003 cannot convert it to an MDE: you must
convert the file format first. To convert to the new file format, look
under Tools | Database Utilities.

You can also change the default file format under Tools | Options, but
that will only affect any databases you create ongoing.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Rob Hofkens" <rob@xxxxxxxxxxxxxxxxxx> wrote in message
news:452cda5c$0$4513$e4fe514c@xxxxxxxxxxxxxxxxx
Hello eveyone.

First, I know little about a MDE but I think its a database that has
compiled VB code and it runs faster ?
Maybe I am totaly wrong about this but someone might explain a bit more.

Second, I have a Access 2003 front end and a SQL2000 Server back end.
When I try to create a MDE I get an error about the "file format from the
used database" (translated from dutch) .
The error window suggests to convert the data ??
Is this normal with my setup ?

Thanx in advance.

Rob.








.

Relevant Pages

  • Re: MDE not possible ?
    ... First compile the MDB and make sure that there are no errors in the code ... before creating the MDE. ... Because of the methode used to compile the database a lot of references ... If your database is in Access 2000 file format (it should say on ...
    (microsoft.public.access.formscoding)
  • Re: Btrieve legacy migration
    ... The first question is to figur eout your file format and database ... and get the white paper on "Finding Your Database Engine Version". ... do a STAT of one of your data files to determine ... or a description of the file format. ...
    (comp.databases.btrieve)
  • Re: .MDE file
    ... The "Make MDE file" option will be disabled until you convert the database ... file format to the current version of Access. ... Access XP and want to convert an Access 2K MDB database into an MDE, ...
    (microsoft.public.access.security)
  • Re: Two questions about moving data between a SQL DB and XML
    ... better method of exporting data to a file format for later reimport be? ... Is there a better option than XML? ... dozen tables from one database and importing them into another database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Stuff
    ... You don't have to have Access installed to use it's file format. ... Set ogAccess = Nothing ... End Function ' OpenDataBase ... of separate machines such that each person is accessing the same database ...
    (microsoft.public.vb.general.discussion)