OO.o supports an Access like system. The caveat is that you have to use a real DB on the backend. The latest edition will link directly to a MySQL DB or any ODBC compliant DB.
Steps on a migration would work something like this.
Install MySQL or PostgreSQL
Create a DB to house your current Access DB
Setup ODBC connection into said DB
Launch Access and add a connection to new ODBC DSN
Start moving tables over to the new DB
Relink forms to use the ODBC based tablespace (this gives you something that continues to work while you do the next step)
Start redesigning the forms in OO.o's forms system linking against new DB tablespace
It is obviously going to take a bit of work to do the conversion, but you've already got all the logic sitting there, you just have to convert it to OO.o's syntax.
Learn about Linux
Download Linux
Get Linux help
Re:vb and access
Posted by: tykeal on December 18, 2003 12:38 AMSteps on a migration would work something like this.
- Install MySQL or PostgreSQL
- Create a DB to house your current Access DB
- Setup ODBC connection into said DB
- Launch Access and add a connection to new ODBC DSN
- Start moving tables over to the new DB
- Relink forms to use the ODBC based tablespace (this gives you something that continues to work while you do the next step)
- Start redesigning the forms in OO.o's forms system linking against new DB tablespace
It is obviously going to take a bit of work to do the conversion, but you've already got all the logic sitting there, you just have to convert it to OO.o's syntax.#