Feedback on new Dell Laptop with Ubuntu Linux

[/pine]

Is he going to run his old Access forms to get at his new SQL data? Or is he going to dive into the world of HTML?

No need to use the old forms...that is what the front end interfaces do...SQL is used to parse the table structure and data so it can be recognized and imported...

The only reason HTML would be required is for public (access) applications..or users could be given limited "grant" permissions to access and use the interface (rather than HTML forms)

Personally I prefer using "phpmyadmin" as an interface...installing the required dependent packages is as easy as installing mysql...
phpMyAdmin can be run on a local area network as well as across wide area networks like the Internet...

 

[riptides]

No need to use the old forms...that is what the front end interfaces do...SQL is used to parse the table structure and data so it can be recognized and imported...

Do you understand the difference between data and code? If his reports run expressions or functions he will have to recode them on his new platform.

If that code was bound to a form, it will have to be recoded on the new platform.

 

[/pine]

Do you understand the difference between data and code? If his reports run expressions or functions he will have to recode them on his new platform.
If that code was bound to a form, it will have to be recoded on the new platform.

yes the "action" of any existing forms would have to be edited to execute SQL but that would not be necessary if they (query results) are not meant to be viewed by the public... the user can simply execute pure SQL queries from a GUI...
It would be relatively simple to convert the query from existing form actions to SQL...

forget that "code" and and the forms if you change platforms it is worthless anyway...the user would not need the existing "code"...It would not be difficult to move from MS to pure SQL...it's the same data, any query can be run to output the desired results...

granted it would take a few minutes +/- to re-write/edit existing queries (forms) but once they are done that's it...converting to SQL is not difficult...it is a very straight forward set of commands...the GUIs make it very easy on the other hand it is not difficult to do it manually with HTML forms...(set the parameters and write a loop to display the results)

it can all be automated to output whatever report Results etc...

 

[2manyrocks]

I tried to follow what you guys were saying, and got lost. Can the db be moved over into the open office database in Ubuntu and still work? OpenOffice.org Base - Wikipedia, the free encyclopedia It's not an application that I have worked with, but I see the open office software being used here and there in nonprofits that don't want to pay for MS products.

Just found this migration guide: http://documentation.openoffice.org/manuals/oooauthors2/0600MG-MigrationGuide.pdf

 

[riptides]

I tried to follow what you guys were saying, and got lost. Can the db be moved over into the open office database in Ubuntu and still work?

Yes you can move the data. The issue is if you have forms or code that are calling on specific windows functions or expressions only. These most likely will have to be re-programmed. An example is a simple count routine using a function to examine say number of records matching blue tractors. This code is called when you click on a command button.
You will have to examine how you get at your data and reports. Anything not pure query SQL driven, is most likely suspect to fail.

MicroSquash has great resources for what may not make the move cleanly to SQL server, google or bing "upsizng MS Access", look for support sites from msdn.